Discussion Board for collaboration on QlikView Scripting.
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 ?
Go to Solution.
Hi, use the Replace() Function, like:
replace(field, ' ', '').
Hope this helps you.
=PurgeChar( ColumnName , ' ' )