Reading Postal Code From .csv file (via table) trims leading 0

[shrunkeehead]

Greetings,

I am reading a .csv text file thru the Table feature of ProjectMaker. I have column "Postal Code" which often begins with a 0 and is in the format "01234". My problem is that when the data arrives in ProjectMaker, it is given as "1234". Is there any way to prevent the leading zero from begin excluded?
I have tried armoring the field with quotes and so forth, without success. Do I need to prepend the zero manually? Please help.

Best Regards,
Scott

 

[rostonix]

Do you talk about preview which you can see in table's settings or about taking data from table and about what you see in variables when you take it from there?

 

[shrunkeehead]

Hello,

Both.

01234 in the actual .csv file displays as 1234 in the Table preview and 1234 in the variable that was taken from the Table.

Thanks in Advance,
Scott

 

[rostonix]

Ok. Will test today.

 

[rostonix]

All 02121 0787 formatted to 2121 and 787 in my Excel automatically...
Can you provide you table file?

 

[shrunkeehead]

Of course, here is my .csv file. http://trwebco.com/Customer%20List%20For%20Citations.csv
It is column F from which the leading '0' is trimmed.

Regards,
Scott

 

[lokiys]

Of course, here is my .csv file. http://trwebco.com/Customer%20List%20For%20Citations.csv
It is column F from which the leading '0' is trimmed.

Regards,
Scott

In column F there is no any ''0'' at the beginning.

UPDATE: This zero thing is not zenno fault. It is excel.
I would suggest you to use .txt files for your job. or add ''work with text'' action in zennoposter and add that zero there...

 

[shrunkeehead]

In column F there is no any ''0'' at the beginning.

UPDATE: This zero thing is not zenno fault. It is excel.
I would suggest you to use .txt files for your job. or add ''work with text'' action in zennoposter and add that zero there...

I appreciate your trying to help. This file was created with Notepad. I think you are telling me to use the .txt extension on my file because that is handled differently from .csv extension in ZennoPoster. I will give that a try.

Best Regards,
Scott

 

[traumatic]

In column F there is no any ''0'' at the beginning.

Sorry but that is not correct as there ARE leading zeros. If you can't see them it may be because your opening the csv via doubleclick / excel.
Just open the csv in notepad or any other text-editor and you will see the zeros.

 

[rostonix]

If you need to operate data in the way it presented in Notepad, use *.txt extension for you file.
If you use *.csv extension, get ready for data to be presented like in excel.

 

[shrunkeehead]

In column F there is no any ''0'' at the beginning.

UPDATE: This zero thing is not zenno fault. It is excel.
I would suggest you to use .txt files for your job. or add ''work with text'' action in zennoposter and add that zero there...

As per the Moderators suggestion, and yours, I simply changed the filename extension from ".csv" to ".txt" and it works! The leading zero is now retained.
Thank you both!

Best Regards,
Scott