I’m working in Toad for Oracle v 18.104.22.168.
I’m trying to import a text file into a table consisting of two columns, an IDENTITY column and a rec_text varchar2(4000). The file consists of different record types as well as some free descriptive text at the beginning. No row is over 320 characters. Unfortunately, the file is issued by a governmental entity and I have no control on how it is created.
So I’m looking to pull the raw rows into a table and resolve the parsing within a procedure.
The problem that I’m encountering is that some rows have leading spaces which are important in differentiating the different types of records. Using the data import functionality through the Schema Browser always results in the leading spaces being trimmed even though I have turned off the trimming in the import wizard.
I’m looking for thoughts and suggestions. Thanks.