Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello expert,
I have a question about data load with subfield() function.
For example,
C1 |C2 | C3
------------------
a | x/y | m
b | y | n
c | y/z | n
d/e| x | m
In the above table, some columns contains multiple values with separater '/' and
they should be splited. But I'm not sure what column has multiple values before
loading data.
Simply writing is loading ALL fields with subfield(), but it is not smart.
LOAD
subfield(C1, '/') as C1,
subfield(C2, '/') as C2,
subfield(C3, '/') as C3
...
I'd like to make the logic which evaluate the values of each field at loading.
Does anyone help me?
Thank you,
what format is the data you are loading in? Can you use the "delimeter" option on loading?
Hear '123455' this is string formate time .hear how to use delimete ,i.e.time is 12-34-55 whate is function used for written delimeter replay fast friends
You may use:
LOAD
Regards,
som
You may do custom format like :
Left(Fld_name,2) & '-' & Mid(Fld_name,3,2) & '-' & Right(Fld_name,2)
Regards,
Som