topic String manipilation in QlikView

String manipilation

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

Code looks like below ....

001-0525-04-555-121

001-0525-02-555-121

001-0525-01-555-121

001-0525-04-555-122

001-0525-02-555-122

001-0525-01-555-122

I have code as above in the file..If anything has 04 then ABC,IF 02 THE DEF ,IF 01 then HIJ

How can I do thia ?

Thank you.

Re: String manipilation

vishsaggi — Mon, 15 May 2017 18:54:55 GMT

Try this may be:

LOAD *,

Pick(Match(Subfield(Value, '-', 3), 04,02,01), 'ABC','DEF','HIJ') AS NewField INLINE [

Value

001-0525-04-555-121

001-0525-02-555-121

001-0525-01-555-121

001-0525-04-555-122

001-0525-02-555-122

001-0525-01-555-122

];

Re: String manipilation

apthansh — Mon, 15 May 2017 19:59:08 GMT

Awesome.Thank you.

Re: String manipilation

apthansh — Mon, 15 May 2017 20:07:33 GMT

jontydkpi‌

stalwar1‌

sunny‌

I need to add one more to this ...

if 04-555 and 01-555 then XYZ .

Can I add this in the same line of script ?

Pick(Match(Subfield(Value, '-', 3), 04,02,01), 'ABC','DEF','HIJ') AS NewField

Thank you much.

LOAD *,

Pick(Match(Subfield(Value, '-', 3), 04,02,01), 'ABC','DEF','HIJ') AS NewField

INLINE [

Value

001-0525-04-555-121

001-0525-02-555-121

001-0525-01-555-121

001-0525-04-555-122

001-0525-02-555-122

001-0525-01-555-122

];

Re: String manipilation

vishsaggi — Mon, 15 May 2017 20:21:26 GMT

In the Same Field you mean ?

Re: String manipilation

apthansh — Mon, 15 May 2017 20:30:52 GMT

Ya..

Re: String manipilation

trdandamudi — Mon, 15 May 2017 20:41:46 GMT

May be as below:

LOAD *,
If(mid(Value,10,6)='04-555' or mid(Value,10,6)='01-555','XYZ', Pick(Match(Subfield(Value, '-', 3), 04,02,01), 'ABC','DEF','HIJ')) AS NewField
INLINE [
Value
001-0525-04-555-121
001-0525-02-555-121
001-0525-01-555-121
001-0525-04-555-122
001-0525-02-555-122
001-0525-01-555-122
];

Note: I modified Nagaraju code and added a If condition.

Re: String manipilation

apthansh — Wed, 17 May 2017 13:36:40 GMT

Awesome. Thank you very much.