OraFAQ Forum: Server Utilities » Loading a single column in a data file into 2 columns in DB

Home » RDBMS Server » Server Utilities » Loading a single column in a data file into 2 columns in DB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading a single column in a data file into 2 columns in DB [message #70538]

Thu, 27 June 2002 02:26

pan
Messages: 3
Registered: June 2002

Junior Member

I am trying to load a pipe delimited file into the DB. I have one column in the data file which is split into 2 columns using SUBSTR. It inserts the 2 columns but somehow the sequencing changes while loading.

For ex

If the data is
A 1234 TEST EXAMPLE

I need this to be inserted as 5 columns
A 12 34 TEST EXAMPLE

but this gets inserted as
A 12 34 EXAMPLE and TEST gets left out.

Report message to a moderator