Not sure if this has been discussed before but struggling to find any thread about it
I export SVs and one column is Form1. However, the data exported to the CSV converts some of the number & characters to date format.
In the example below of 3 runners one runners Form output in the CSV file is displayed as '06-May', when in effect it's form figure is actually '6/5'
Form1 UP-
Form1 06-May
Form1 423
Is there a way to ignore " / " or " - " when exporting the information? Or is there any other fandango solution?
I've tried to convert the CSV to various formats and even used PQ to change the data but with no success.
Exporting SV data - numbers covert to date
- paspuggie48
- Posts: 634
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Unless anyone has a solution...
I selected: -
Extract characters from middle of value
Position of first char = 1
Position of last char = 1
Then repeated the rule multiple times, changing the Positions as above to 2, then 3, then 4 etc
It creates multiple columns in my export but removes the date issue...then again combining it all with PQ it's not an issue
I selected: -
Extract characters from middle of value
Position of first char = 1
Position of last char = 1
Then repeated the rule multiple times, changing the Positions as above to 2, then 3, then 4 etc
It creates multiple columns in my export but removes the date issue...then again combining it all with PQ it's not an issue