leading zero in source file

[sveta]

Hi.
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?

[Sergei]

Hello,

You need to use Replace function with the field(s) you try to add a leading zero. Example how to do it uploaded here http://bit.ly/tcrr6t

Datamap example like this.

Edited .CSV file - Transform - Edited .CSV file

If you have other questions feel free to let us know.
_________________
Regards,
Sergei