Delete space in data

[christophebrault]

Hi,

In one of my fields, i have data like 'AAAA  BB CC' or 'AAA BB CCC' and i want them as 'AAABBBCC' and ' AAABBCCC'.

How can i do that ?

[fosuzuki · Accepted solution]

Hi, use the Replace() Function, like:

replace(field, ' ', '').

Hope this helps you.

Regards,

Fernando

[jagan]

Hi,

Use this

=PurgeChar( ColumnName , ' ' )

Regards,

Jagan.