Maintain String format in a CSV File --

[ll98]

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

Account

100

[MarqueeCrew]

@ll98 ,

please open the csv file using notepad instead of excel and see what the data looks like. 

cheers,

 mark

[ll98 · Accepted solution]

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

[ll98 · Accepted solution]

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

[MarqueeCrew · Accepted solution]

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

[ll98 · Accepted solution]

@MarqueeCrew   Thanks

[MarqueeCrew]

@ll98 You're welcome!