Extract the two fiels from a field

[ecabanas]

Hi

I have this code  20161099 and I want to extract the position 5 and 6 "10" in load script.

Many thank's

Eduard

[MarcoWedel · Accepted solution]

Hi,

one solution might be:

LOAD *,
     Mid(Code,5,2)as SubCode
Inline [
Code
20161099
20171100
20181201
20191302
];

hope this helps

regards

Marco