Trim Inside

[Elso]

Hello

I am trying to find away to trim white space from the inside of a string.
I am using the following derive_fields (with many thanks to Russell) to trim off white space in front and after the fieldnameX values and any leading zeros.

<input type="hidden" name="derive_fields" value="
     fieldname1=%rtrim(fieldname1)%,fieldname1=%ltrim0(fieldname1)%,
     fieldname2=%rtrim(fieldname2)%,fieldname2=%ltrim0(fieldname2)%,
     fieldname3=%rtrim(fieldname3)%,fieldname3=%ltrim0(fieldname3)%,
                    " />

If someone was to enter 8 8, I need to be able to trim the inside white space to result in 88.

Ideas?

Thank you
Nelson

[russellr]

Hi,

There is no function to trim inside a field.

If someone enters "8 8", you're better to generate an error using a conditions test than to assume they mean "88".

I can't think of any computer system that would make that assumption - it always has to be a data entry error.