Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following CSV file data:
V4.0;GL;R;Delta;IF;;09-14-2012;51630;209
100;3267;1770178000;;;;;;;;;;;;9587.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201
100;6225;1770178000;;;;;;;;;;;;5162.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201
100;7957;1770178000;;;;;;;;;;;;-14750;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201
100;3267;1770178000;;;;;;;;;;;;9587.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201202
100;6225;1770178000;;;;;;;;;;;;5162.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201202
I went to EDIT SCRIPT, TABLE FILES, and browsed for this file.
In the file wizard, I can only see up to 9 columns. I suspect this is because the first row line is only up to the 9 column.
But the data I really need are those rows 2 and below. These data are up to 21 columns.
How can I import that entire 21 columns of data based on above CSV file structure?
Thanks in advance.
If you can ignore the first line completely then in the table load window set some lines for the header. If you need to load the first line too then use
Load
@1 AS A,
@2 AS B,
@3 AS C,
.
.
.
@22 AS V
From...csv;
Hope this helps,
Jason
Posting an image of the CSV data, as my orig post looks mangled:
Thanks in advance.
If you can ignore the first line completely then in the table load window set some lines for the header. If you need to load the first line too then use
Load
@1 AS A,
@2 AS B,
@3 AS C,
.
.
.
@22 AS V
From...csv;
Hope this helps,
Jason