Importing data from .csv files, prompt and matched dates
Posted: Mon Feb 05, 2024 1:34 pm
Hi there, EV team!
A question about the "import" command. I'm trying to import a CSV file. Through visual clicks I managed well to import the data and asking the EV to read data and match dates in a d7 frequency. However, when I do it through a .prg file, I continue to receive the prompt asking to select, for instance, the import method (sequential, matched read, append to the end etc). Help files didn't help me in trying to avoid the prompt and simply saying to apply a matched read automatically. Any clues?
I'm doing something like:
import C:\xxx\xxxx\xxxx\file.csv ftype=ascii rectype=crlf skip=0 fieldtype=delimited custom=";" mult colhead=1 namepos=custom eoltype=pad badfield=NA @freq D7 @id @date(date) @destid @date @smpl @all
When inside the prompt window, I just have to click on "matched read". However, I'd like to impose this into the command, avoiding the prompt.
Any help is welcomed.
Tks, Fabio
A question about the "import" command. I'm trying to import a CSV file. Through visual clicks I managed well to import the data and asking the EV to read data and match dates in a d7 frequency. However, when I do it through a .prg file, I continue to receive the prompt asking to select, for instance, the import method (sequential, matched read, append to the end etc). Help files didn't help me in trying to avoid the prompt and simply saying to apply a matched read automatically. Any clues?
I'm doing something like:
import C:\xxx\xxxx\xxxx\file.csv ftype=ascii rectype=crlf skip=0 fieldtype=delimited custom=";" mult colhead=1 namepos=custom eoltype=pad badfield=NA @freq D7 @id @date(date) @destid @date @smpl @all
When inside the prompt window, I just have to click on "matched read". However, I'd like to impose this into the command, avoiding the prompt.
Any help is welcomed.
Tks, Fabio
