Maintain String format in a CSV File --

Question

Hi

I have an issue where the DATA displays correctly in Desginer output -- however, when it outputs to a csv format the data changes .. Hence, designer shows it as 0100  -- however, when it output to CSV format, it changes to 100.  Are you able to assist

Account100

ll98 · Accepted Answer

@MarqueeCrew   -In Notepad it shows as    0100 -- Which is how I want to show it in the CSV.file

ll98 · Accepted Answer

@MarqueeCrew   I'm loading the file into a database and it needs to be loaded as '0100" instead of 100....

MarqueeCrew · Accepted Answer

As long as the db has it defined as a string, you should be good.

ll98 · Accepted Answer

@MarqueeCrew   Thanks