topic How to replace character in QlikView

How to replace character

pra_kale — Sat, 07 Jul 2018 13:51:57 GMT

Hi,

In my data i have column member number which is having length 5. In that few members code is like '01ED2', '01EF3' ,'01E12','02E45','03E99'.

Now my challenge is I want to replace after E if only if last 2 characters are numbers. Means if member number is '01E12' then it should be '01E_12', '02E45' then '02E_45', '03E99' then '03E_99', for rest members there is no change.

Appreciate your help in this.

Thanks in advance.

Re: How to replace character

joseph_morales — Sat, 07 Jul 2018 21:40:49 GMT

A simple method in the Script is this.

A:
load
Field,
if(IsNum(right(Field,2)) and mid(Field,3,1) ='E',left(Field,3)&'_'&right(Field,2),Field) as NewField;
LOAD * INLINE [
Field
01ED2
01EF3
01E12
02E45
03E99
];

Regards

Re: How to replace character

pra_kale — Sun, 08 Jul 2018 12:32:49 GMT

Thanks Joseph..It is working.