Getting Data In
Highlighted

Is it possible to use a part of the source name as _time during CSV import?

Motivator

Hi,

I'm uploading multiple CSV files. Unfortunately, they don't have a usable field for the timestamp.
Is it possible to grab a part of the filename (source field) to define _time?

The structure of the filenames look like this:

"random count of signs 2015-11-01-2015-11-30.csv"

I'm thinking of a combination of strptime and substr, something similar to this command:

strptime((substr(source, 1, len(source)-15)), "%Y-%m-%d")

Best
Heinz

0 Karma
Highlighted

Re: Is it possible to use a part of the source name as _time during CSV import?

Motivator
0 Karma
Highlighted

Re: Is it possible to use a part of the source name as _time during CSV import?

Esteemed Legend
0 Karma