Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

"Changing .csv data."

redbaron1981

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.

Find more posts tagged with

AI Studio

CSV

Accepted answers

All comments

land

Hi,
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