String Function Needed

[Anonymous]

Hi Friends

I need a string function to remove spaces in between field values

Example

New York

New Delhi

Uttra pradesh

Result Should be like this

NewYork

NewDelhi

Uttraprades

Any string function available means please help me

Thanks in Advance

Sirajahamed

[Anonymous]

Siraj

Use the Replace() function, something like this:

     replace (  'q w e r t y' , ' ' , null() )

Best Regards,     Bill

[Anonymous]

Thanks Bill

In this function we are giving value like ('q w e r t y' ) and replacing but my scenario

i have a field name called Product Group in that field Value is in

7 up

Lime Soda

like that

i use replace(Product Group,' ',null()) as ProductGroup

but result will be same spaces are not trimming

7 up

Lime soda

please any other idea to solve this

Regards

Siraj

[Anonymous · Accepted solution]

You need to careful with Field names with spaces in them and use [ ] suitabley if needed.

replace( [Product Group] ,' ',null() ) as ProductGroup

[Anonymous]

Thanks Bill

It's working perfectly

i use like this  replace( [Product Group] ,' ',' ' ) as ProductGroup

Thanks Lot.