subfield

[vijetas42]

hi all,

I have values in field like,

1234;231;422;

12344;8982;223;

1212;

and i want to separate out values in to different rows so, i have used subfield but, it is creating one more null record for each vale how to remove that

[m_woolf]

subfield(left(Yourfield,len(Yourfield)-1),';') as whatever

[MarcoWedel]

Hi,

one solution might be:

table1:
LOAD *
Where Len(Trim(value));
LOAD *,
    SubField(field,';') as value
Inline [
    field
    1234;231;422;
    12344;8982;223;
    1212;
];

hope this helps

regards

Marco