Posted: Wed Oct 19, 2011 10:00 pm Post subject: leading zero in source file
I'm using CSV file as a source.
client edits this file in excel, and after save leading zero in one field is gone. I cannot prevent this editing, client wants leading zero back in output file.
would be easy to use Prefix, but my problem is:
proper value size is 6 digits: some of values in source file have proper size, like '100200', but some of the values have only 5 digits and need that leading zero. like: used to be '010020', after client's edit '10020', they want it back to '010020' in output.
what is the best way to do it?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum