Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to add leading zeros
ex:
ACCL25 = 00ACCL25
ACCL9 = 000ACCL9
Thanks..
Hi:
If(IsNum(Right(FieldName,2))
,'00'& FieldName
,If(IsNum(Right(FieldName,1))
,'000'& FieldName)) as FieldName2
Hi
Try like below
Load *, Repeat(0, 8-Len(field1))&field1 as field2 Inline
[
field1
ACCL25
ACCL9
];
Hi:
If(IsNum(Right(FieldName,2))
,'00'& FieldName
,If(IsNum(Right(FieldName,1))
,'000'& FieldName)) as FieldName2
Hi
Try like below
Load *, Repeat(0, 8-Len(field1))&field1 as field2 Inline
[
field1
ACCL25
ACCL9
];
Hi, try the below.
Text(If(Len(KeepChar(FieldName,'0123456789')) =1, '000'&FieldName,
If(Len(KeepChar(FieldName,'0123456789')) =2, '00'&FieldName))) as FieldName2
Absolutely brilliant! Thank you very much!