Exporting SV data - numbers covert to date

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

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.
User avatar
paspuggie48
Posts: 611
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 ;)
Post Reply

Return to “Bet Angel - Automation”