topic Re: need help in qlik requirement in QlikView

need help in qlik requirement

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

Hi Team

can you please help me with the below scenario

i have field name "mat" in my table which has data like is shown below

Mat:

96-HF469A1-SRVC
UW-HA546A1-SRVC
SI-815100-B21-JK03
SI-865408-B21-JK03
TN-P00930-B21-JK03
UW-HA454A1-021-JK03

output should be like below

output:

HF469A1
HA546A1
815100-B21
865408-B21
P00930-B21
HA454A1-021

Thanks and regards

siva

Re: need help in qlik requirement

zhadrakas — Fri, 21 Aug 2020 05:43:07 GMT

this should do what you need.

RAW: Load if(SubStringCount(mat, '-') >=3, subfield(mat, '-', 2) & '-' & subfield(mat, '-', 3), subfield(mat, '-', 2)) as mat ; LOAD * INLINE [ mat 96-HF469A1-SRVC UW-HA546A1-SRVC SI-815100-B21-JK03 SI-865408-B21-JK03 TN-P00930-B21-JK03 UW-HA454A1-021-JK03 ];

Re: need help in qlik requirement

chakiw5 — Fri, 21 Aug 2020 05:57:51 GMT

Please do call this writing to the module

function output(val)
dim p1,p2
p1=instr(val,"-")
p2=instrrev(val,"-")

output=Mid(val,p1+1,p2-(p1+1))

end function