Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 924
  • Last Modified:

Inserting new line in data using SQL Loader

Hello,

I have to insert a record using SQL Loader. One of the field of the record has a new line between the data. Due to this new line the record is continued on the next line and during the SQL Loader insert the record is considered to be 2 records. Ideally this is one record with a new line in the data. how do I insert the record with a new line in the data using SQL Loader.

Thanks
0
d_lalit
Asked:
d_lalit
  • 3
  • 2
1 Solution
 
Jinesh KamdarCommented:
Is this data field wrapped between any symbols like ' or " ?
0
 
d_lalitAuthor Commented:
I am using data that is delimited by |.
E.g.
COL231|COL245|COL
567|COL789
0
 
Jinesh KamdarCommented:
Post at least 3 sample records from the file?
How big is the data? If not much, open the data file in an editor like Edit-Plus and merge these 2-line records into 1 by Replacing the Reg-ex : COL\n with COL
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
d_lalitAuthor Commented:
I want the data to be inserted in the way it is i.e. the third column data should have a new line after it is inserted in the column. I do not want the data to merge.

TEST1123|TEST345|TEST456|TEST
789|TEST987|
TEST1|TEST2|TEST3|TEST
4|TEST5|
0
 
Jinesh KamdarCommented:
Its kinda difficult to load variable-length multi-line records without any specific field terminators. Youu can try the CONCATENATE option in the control-file.

http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q_21241284.html
http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q_21232748.html
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch10.htm
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now