Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"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