remove the spaces

[andyrebs]

Hi ,

how can I write the script, if i want to remove the spaces in the field?

Example:

Field
(London    )
(London)
(Paris       )
(Paris)

Many thanks

[#2 · Accepted solution]

Hi Andy,

Use below code.

text(trim(purgechar(Field, ' ')))

[#3]

Hi,

Trim(Subfield(FieldName,')',1))&')' as FieldName

It might helps you.

Best of luck

[#4]

Hi,

have you tried TRIM function ?

Load *,

       Trim(Field) as FieldTrim

From ....

Hope it helps

Giampiero

[#5]

Hi in the script write

LOAD

trim (field) as newfield

from...

[andyrebs]

Many Thanks