topic Re: Convert a string data column to an appropriate format in QlikView

Convert a string data column to an appropriate format

Anonymous — Wed, 21 Feb 2018 09:46:00 GMT

Hello,

I've got a column "DAYS" in a source data file with the following data (week's days):

FRI,SAT

THUS/MON

WED

...

As you can see, delimiters and symbols are different. How to get the following result in QlikView by the easiest way:

Fri/Sat

Thu/Mon

Wed

With best regards,

Evgeniy Sharahov

amira_khemissi_ — Wed, 21 Feb 2018 16:30:04 GMT

Hi,

You can try if(wildmatch(field,'*,*')>0,replace(field,',','/'),field)

Anonymous — Fri, 23 Feb 2018 06:43:56 GMT

Hi Amira,

Thank you. And we also need to add Capitalize() to convert to the appropriate format.

amira_khemissi_ — Mon, 26 Feb 2018 10:32:54 GMT

You can use the UPPER() function of QlikView