Hi,
I need to redact the multiple 0s in front of numbers in like mentioned in the below table, can someone please help with the best way to do it?
Hi @SP3000
You can use the TrimLeft() Function:
trimleft([No],'0')
Wow, just like that ..thank you so much @Luke !!
@SP3000 ,
I completely agree with @Luke_C on the trimleft() function. If you want a "NUMBER" you can also convert ToNumber() the entry and that will remove all of the multiple zeros naturally.
Cheers,
Mark
