Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I am trying to remove spaces between the below string . Can anyone help me how should i do it?
I tried the trim functions and the same does not work
Origional data : CGB0 024425
Exoected result: CGB0024425
Thanks for your help in advance
Regards,
Viral
You can try replace too: replace(MyField, ' ','')
But purgechar works fine for me. For example =PurgeChar('CGB0 024425',' ') returns CGB0024425.
purgechar([Your Field], ' ')
Hi Nicole,
I tried purgechar , but it does not work
Thx
Viral
You can try replace too: replace(MyField, ' ','')
But purgechar works fine for me. For example =PurgeChar('CGB0 024425',' ') returns CGB0024425.
Can you post a .qvw? There is no reason why it shouldn't work...
Thanks This works 🙂