Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
In my description column, I would like to pick up the ref no: but these are not the same format. I would like to know how to get the required ref: no?
Best Regards,
Kyaw Myo Tun
I tried something like this, but this may not the feasible solution and also it will fail if there were symbols other than the used ones in script, i will look into some more solutions
LOAD Date,
ID,
DESCRIPTION,
AMOUNT,
F5,
Subfield(Replace(DESCRIPTION,':','-'),'-',2) as [NEW DESCRIPTION]
FROM
Source
Hi Kyaw,
Try this
LOAD Date,
ID,
DESCRIPTION,
AMOUNT,
F5,
KeepChar(DESCRIPTION,'0123456789') as [NEW DESCRIPTION]
FROM Source;
Dear K N,
it work well for the situation but I made a mistake in my excel. The ref no: is not only contain digit but also character. (eg....13050ABC1002). how can i get that data?
Best Regards,
Kyaw Myo Tun
Please post sample data containing mixed text
Dear K N,
Best Regards,
Kyaw Myo Tun
I tried something like this, but this may not the feasible solution and also it will fail if there were symbols other than the used ones in script, i will look into some more solutions
LOAD Date,
ID,
DESCRIPTION,
AMOUNT,
F5,
Subfield(Replace(DESCRIPTION,':','-'),'-',2) as [NEW DESCRIPTION]
FROM
Source
Hi,
This will help u to complete u r task.
keepchar is a string function it will help to separate text and string values
KeepChar(DESCRIPTION,'0123456789') as Newdata
Thanks and regards,
Balaji.k
Dear K N,
It work correctly for my purpose. Thanks for your help.
Best Regards,
Kyaw Myo Tun