Removing spaces between a string.

[#1]

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

[Nicole-Smith]

purgechar([Your Field], ' ')

[#3]

Hi Nicole,

I tried purgechar , but it does not work

Thx

Viral

[Gysbert_Wassenaar · Accepted solution]

You can try replace too: replace(MyField, ' ','')

But purgechar works fine for me. For example =PurgeChar('CGB0 024425',' ') returns CGB0024425.

[Nicole-Smith]

Can you post a .qvw?  There is no reason why it shouldn't work...

[#6]

Thanks This works 🙂