Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there!
Can anyone tell me how I can remove leading zero's from a Text field?
I have a Text column where the data looks like:
Header 1 |
---|
Text |
ABC |
0001 |
02 |
TR01 |
I would like a function that picks up the leading zero values in the above column and remove it.
How can we do that please?
if(isnum(Field),Text(num(Field)),Field) as Field
Hi there.
Try something like this:
Table1:
LOAD IF(IsNum(Header1), NUM(NUM#(Header1)), Header1) as Header1;
LOAD * Inline
[
Header1
Text
ABC
0001
02
TR01
];
Kind regards,
Ernesto.
if(isnum(Field),Text(num(Field)),Field) as Field
Thank you so much both!