Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
subfield(left(Yourfield,len(Yourfield)-1),';') as whatever
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