topic Re: String Function Needed in QlikView

String Function Needed

Anonymous — Wed, 11 Dec 2013 07:15:15 GMT

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 — Wed, 11 Dec 2013 07:19:40 GMT

Siraj

Use the Replace() function, something like this:

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

Best Regards, Bill

Anonymous — Wed, 11 Dec 2013 07:39:46 GMT

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 — Wed, 11 Dec 2013 07:46:04 GMT

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

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

Anonymous — Wed, 11 Dec 2013 09:11:39 GMT

Thanks Bill

It's working perfectly

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

Thanks Lot.