Importing txt column missing

ealindahl — Sat, 10 Jun 2023 23:50:27 GMT

I am importing a txt file that has junk in the first row and data starts on the second. The junk data is not consistent between different files so I want to get rid of it, but when I use the following to get rid of the first line and designate no headers, the first column of data disappears. How do I import this file without losing that column and without column headers.

Alternatively can I import the file with the column headers and then rename each column based on its position rather than based on its title?

open(File,

Table Contains Column Headers (0),
Treat Empty Columns as Numeric(1)
Data Starts|Data starts on line (2)

);

0	2022-06-23 14:55:29	#ARC-FILE#	1.1a	2022-05-04	2022-06-23	CEDEX BIO HT	630026	6.0.1.2102 (1905)	ADMIN																
10	2022-06-14 10:20:59	CA2B	CAL C	62232400	261	62809100	mg/L	 	  78.00	  0.00					  0.10250	  0.00779					  0.0077860	  20.546763	 	 	 
10	2022-06-14 10:22:18	CA2D	CAL C	62232400	261	62809100	mg/L	 	  780.00	  0.00					  0.10121	  0.00793					  0.0079316	  20.863648	 	 	 
10	2022-06-14 10:23:01	FE2B	CAL C	62232400	572	61840600	mg/L	 	  3.80	  0.00					  0.04336	  0.00318					  0.0031815	  1693.9365

Re: Importing txt column missing

jthi — Tue, 28 Jun 2022 18:16:08 GMT

I would suggest opening the file with Open menu and using Preview:

then it is easier to see what different options do

and you can get the script from table script.

Open(
	"$DOWNLOADS/junk.txt",
	columns(
		New Column("c000001", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000002",
			Numeric,
			"Continuous",
			Format("y/m/d h:m:s", 22, 0),
			Input Format("y/m/d h:m:s", 0)
		),
		New Column("c000003", Character, "Nominal"),
		New Column("c000004", Character, "Nominal"),
		New Column("c000005", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000006", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000007", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000008", Character, "Nominal"),
		New Column("c000009", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000010", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000011", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000012", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000013", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000014", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000015", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000016", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000017", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000018", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000019", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000020", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000021", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000022", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000023", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000024", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000025", Numeric, "Continuous", Format("Best", 12)),
		New Column("c000026", Numeric, "Continuous", Format("Best", 12))
	),
	Import Settings(
		End Of Line(CRLF, CR, LF),
		End Of Field(Tab, CSV(0)),
		Strip Quotes(1),
		Use Apostrophe as Quotation Mark(0),
		Use Regional Settings(0),
		Scan Whole File(1),
		Treat empty columns as numeric(0),
		CompressNumericColumns(0),
		CompressCharacterColumns(0),
		CompressAllowListCheck(0),
		Labels(0),
		Column Names Start(1),
		Data Starts(2),
		Lines To Read("All"),
		Year Rule("20xx")
	)
)

topic Re: Importing txt column missing in Discussions

Importing txt column missing

Re: Importing txt column missing