I have a field containing data like
I can use the SUBFIELD Function to seperate the data with a result of
But I also get a blank field because of the last comma, how can I remove these blank fields?
All the data in the field ends with a , (comma)
LOAD FIELD WHERE Len(Trim(SUBFIELD));
LOAD Subfield(FIELD, ',') as FIELD FROM ....;
I tried using
but I get an error saying SUBFIELD requires 2-3 parameters
Sorry, I edited my post and forgot the WHERE clause (it should be FIELD instead of SUBFIELD)
LOAD FIELD WHERE Len(Trim(FIELD));
In order to do it, you can use function Left and take all string except the last one char
this seems to work thanks
LOAD trim(F1) as FieldList
"AL , R , 267593 ,"
"AL , R , 2rqwrwe ,"
SubField(FieldList,',') as Field;
right(FieldList,1) = ',',
) as FieldList
Left() and len()-1
I do not see (now) what to use instead ...