Write to csv
Hi,
Is there a way to set the formatting of the csv column before writing?
An example would be if I have a header called "TEST" and I write out 6-8614 it automatically changes the format of the "TEST" column to date and in the csv the value is 06/01/14.
Not automatically, but you
Not automatically, but you could add a script that will take your token, run a sutil.reformatDate() on it, and then either 1) replace your token with the reformatted one, or 2) write it out directly.
I want to keep the text as a number
I want to keep 6-8614 as it is and not change it to the date format. In screen scraper "6-8614" appears as "6-8614", but in the csv it is change to the date format, which I don't want.
Oh, well that tells me that
Oh, well that tells me that you're looking at the CSV with MS Excel, and that is what is doing the change. If you look at it with Wordpad, you'll see that it is the string that you expect.
The problem is therefore with Excel. I think that if you prepend a apostrophe to your value, Excel will treat is as text and not attempt to format it for you.