Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi, use the Replace() Function, like:
replace(field, ' ', '').
Hope this helps you.
Regards,
Fernando
Hi, use the Replace() Function, like:
replace(field, ' ', '').
Hope this helps you.
Regards,
Fernando
Hi,
Use this
=PurgeChar( ColumnName , ' ' )
Regards,
Jagan.