Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
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
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