I work with a tool that imports data into an ERP app. I believe that the tool uses VB.Net for scripts.
Anyway, I need to remove leading zeroes for a string field. That field is called _ORDERNUM.
As an example, 000004015414 should import as 4015414 only. There is no telling how many leading zeroes there will be for this string field.
I'd rather not use "variable programming" to do this. There's got to be a simple script, such as "TRIM", that would do this. But, I'm not familiar with such syntax.
So, hat programming syntax would be best to use?
Thank you! Much appreciated!