topic Re: Text changes to Date in storing CSV in QlikView

Text changes to Date in storing CSV

dana — Mon, 26 Aug 2024 09:17:25 GMT

Hi people,

I have a field that originally some of the values are numbers and some are text.

I used the Text function, and all of them are displayed in QV and in Excel as text.

After exporting to CSV, fields with values such as 01-01, 01-02, are displayed as 01-Jan, 01-Feb.

How can I resolve it?

Thanks!

Re: Text changes to Date in storing CSV

marcus_sommer — Mon, 26 Aug 2024 10:25:13 GMT

It's an Excel feature. Don't open the csv with Excel else open it with an editor and copy & paste the content to Excel. Then use the divide-in-columns feature from the menu Data and within the third/fourth step you could define for each column how Excel should interpret the content.

Re: Text changes to Date in storing CSV

dana — Mon, 26 Aug 2024 10:28:10 GMT

I've added a space to the field (' ' & FieldName) and it resolved the issue.

Re: Text changes to Date in storing CSV

seanbruton — Thu, 17 Oct 2024 15:03:43 GMT

Superb, very helpful solution!!!