topic Re: Skript in QlikView

Skript

kkarlste — Mon, 10 Apr 2017 05:41:33 GMT

I have a problem.

I need skript

hree or two or one letters and then line - and then one or two or three number

for example

AF-81

UAG-10
HAL-25

LAL-112

8IAF	8IAF
10UAG	10UAG
25HAL	25HAL
112LAL	112LAL

Re: Skript

Anil_Babu_Samineni — Mon, 10 Apr 2017 07:54:17 GMT

You want to split it as below?

LOAD Sample, SubField(Sample,'-',-1) & SubField(Sample,'-',1) as Sample1 Inline [

Sample

AF-81

UAG-10

HAL-25

LAL-112

];

Re: Skript

kkarlste — Mon, 10 Apr 2017 08:14:13 GMT

Yes this is field name [ANLN1]

I must replace this field same time . (point)

Is this correct?

LOAD Sample,[ANLN1] (Sample,'-',-1) & [ANLN1](Sample,'-',1) as Sample1 Inline [

Sample

[ANLA]: // Asset Master Record Segment
Load

// Replace ([ANLN1],'.', ' ') as ANLN1],,

Sample, [ANLN1](Sample,'-',-1) & [ANLN1](Sample,'-',1) as Sample1 Inline [

Sample,

Re: Skript

kkarlste — Mon, 10 Apr 2017 08:41:44 GMT

Now

[ANLA]: // Asset Master Record Segment
Load

// Replace ([ANLN1],'.', ' ') as Reknro,

[ANLN1], SubField ([ANLN1],'-',-1) & SubField (ANLN1,'-',1) as Reknro,

For example Reknro must be this model BP-100

BR-100

KAN-102

Re: Skript

Anil_Babu_Samineni — Mon, 10 Apr 2017 08:50:08 GMT

I am not following you here, Would you share inline data and tell us expected result. That would be better

Re: Skript

kkarlste — Mon, 10 Apr 2017 09:29:31 GMT

This is a data

This is correct model

letterletterletter-numbernumbernumber

100BP

100BR

102KAN

106HAO

109HAV

10CBA

10UAG

111ISS

AFO598

AFP296

AFT698

AFU291

AFX404

AGE590

AGM210

AGR941

AGT522

AGT555

AGT561

AGT563

AGT566

AGT923

AGT952