Discussion board where members can get started with Qlik Sense.
I'm having trouble creating an IF statement that cleans and pulls through the correct text from a string.
I have 2x types of strings in my data source, see below;
The cleaned versions will be ORD-XXXXXXXX (so ignoring any additional characters after the 8 numbers AND replacing LOC with ORD). This is so I can then match up to another data table.
I currently have;
LOAD "CCT_THIRDPARTY",If(Index("CCT_THIRDPARTY",'ORD-',1)=1,Mid("CCT_THIRDPARTY",Index("CCT_THIRDPARTY",'ORD-',1),12)) as Clean_CCT
How would I go about adding REPLACE("CCT_THIRDPARTY", 'LOC', 'ORD') to this statement?
Thanks in advance
View solution in original post
Perfect! Thank you that worked a treat.