The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"Changing .csv data."
redbaron1981
Member Posts: 3 
Contributor I
Hey Guys,
Can anyone help me with this query or point me in the right direction?
I am new to Rapid but I've been trying to edit this data from a forex database. It is in .CSV so I import it into Rapid but I'd like to change the date and time columns so they are a little more usable. This is how it appears after import:
XAGUSD200101022309004.574.574.574.574
But I'd like to have it like this:
XAGUSD2001:01:0223:09:004.574.574.574.574
My plan is once I have the date and time in a more useable format I then want to run queries through the data and export the results to R or Matlab!
Any help would be much appreciated.
James.
Can anyone help me with this query or point me in the right direction?
I am new to Rapid but I've been trying to edit this data from a forex database. It is in .CSV so I import it into Rapid but I'd like to change the date and time columns so they are a little more usable. This is how it appears after import:
XAGUSD200101022309004.574.574.574.574
But I'd like to have it like this:
XAGUSD2001:01:0223:09:004.574.574.574.574
My plan is once I have the date and time in a more useable format I then want to run queries through the data and export the results to R or Matlab!
Any help would be much appreciated.
James.
Tagged:
0
Answers
please take a look at the Nominal to Date operator. You can enter there arbitrary Date Formats to extract the real (numerical) date. You can then filter on this accordingly.
Greetings,
 Sebastian