Skript

[kkarlste]

Hi

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

[Anil_Babu_Samineni]

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

];

[kkarlste]

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,

[kkarlste]

Hi

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

    

[Anil_Babu_Samineni]

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

[kkarlste]

Hi

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