Hi @mgildemeister ,
The SQL Command works as written, however the File: Open command needs to be modified so that the schema.ini generated when the file is opened contains the column headers for the two temporary columns listed in the SQL command (RightChar and Length), see below:
After the appropriate schema file is generated, the columns don’t need to be listed in the File: Open command, though it doesn’t hurt anything to have them there. The schema.ini being accurate is required to use SQL commands on Structured Text Files in VENUS.
Thank you,
Dan