load inline [
How to remove names,alphabets and leading zeros
LOAD Num(KeepChar(Department, '0123456789'), '00') as Department;
load * inline [
Thanks for reply Sunny. It's working fine.
Floor(KeepChar(Department,'0123456789')) as Department
Retrieving data ...