Hi,

I'm trying to import a .txt file with variable names in second row, some of which contain brackets. Is there a way to customize the syntax so that the brackets are ignored but the variable is still imported?

GET DATA /TYPE=TXT

/FILE="/Users/me/Desktop/U0XXXRB.txt"

/ENCODING='UTF-16LE'

/DELIMITERS="\t"

/QUALIFIER='"'

/ARRANGEMENT=DELIMITED

/FIRSTCASE=3

/DATATYPEMIN PERCENTAGE=95.0

/VARIABLES=

BlockList.Cycle AUTO

BlockList.Sample AUTO

Procedure[Block] AUTO

The syntax won't run when brackets are included, and when removed, the variable is skipped because it doesn't match the name in the txt file.

Thanks!

There is no direct way to do this. The choices are

1. set the syntax so that it specifies no variable names and rename after import
2. open the file in a text editor and delete the brackets
3. maybe, include [and ] in the list of delimiters. I don't recall exactly how multiple adjacent delimiters are handled by that command.