Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
load inline [
Department
emplyoye,
distribution,
G101010
GA201020
S081
G00089
GA00123
];
How to remove names,alphabets and leading zeros
Expected output:
Department:
101010
201020
81
89
123
Thank you
Try this:
Table:
LOAD Num(KeepChar(Department, '0123456789'), '00') as Department;
load * inline [
Department
G101010
GA201020
S081
G00089
GA00123
];
Try this:
Table:
LOAD Num(KeepChar(Department, '0123456789'), '00') as Department;
load * inline [
Department
G101010
GA201020
S081
G00089
GA00123
];
try
Floor(KeepChar(Department,'0123456789')) as Department
Thanks for reply Sunny. It's working fine.