variable loop

[GK31]

Hello,

I would like to load the file :

PRG       CITY

1              A;B;C

2              D;E

in a table that woul look like

CITY          PRG

A                1

B                 1

C                 1

D                2

E                 2

I can get near my objective using subfield() function, but I do not manage to get a variable loop limit.

If you can help would be great !

Thanks

Gérard

[Anil_Babu_Samineni]

What does it mean by "Variable Loop" ?

[StarinieriG · Accepted solution]

Hi,

try with something like this:

LOAD
PRG,
SubField(CITY,';') AS CITY
;
load * inline
[PRG,CITY
1,'A;B;C'
2,'D;E'
];

[GK31]

Just great, it answers 100% to my need.

Thanks a lot !

PS. I was using Subfield with two arguments 'SubField(CITY, ';', x)'

And I could not find a way to vary the value of x depending on the line.