Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
evgeniyita
Contributor

Convert a string data column to an appropriate format

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

1 Solution

Accepted Solutions
Highlighted
amira_khemissi_
New Contributor III

Re: Convert a string data column to an appropriate format

Hi,

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

View solution in original post

3 Replies
Highlighted
amira_khemissi_
New Contributor III

Re: Convert a string data column to an appropriate format

Hi,

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

View solution in original post

evgeniyita
Contributor

Re: Convert a string data column to an appropriate format

Hi Amira,

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

amira_khemissi_
New Contributor III

Re: Convert a string data column to an appropriate format

You can use the UPPER() function of QlikView