OraFAQ Forum: Server Utilities » FIELDS TERMINATED BY ","; NEED MISS "\," simboll

Home » RDBMS Server » Server Utilities » FIELDS TERMINATED BY ","; NEED MISS "\," simboll

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

FIELDS TERMINATED BY ","; NEED MISS "\," simboll [message #210499]

Thu, 21 December 2006 02:14

nmomtselidze
Messages: 3
Registered: December 2006

Junior Member

Hi,
In SQL*Loader CTL FIELDS are TERMINATED BY ",".
But same loading fields have symbols "\," as parts
of data fields. Have any possibility to avoid
field termination by "\,".
This symbol is not enclosed by "".
Raw example:
198.18.8.1,http://kiss.best.su/?best\,star\,step2\,\,353456c2\,,,39,0,[/url]
Part of ctl file:
........
INTO TABLE TEMPLOG
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
nampServerIPaddress ,
fetchedURL ,
originalURL ,
.......
Help me,please
Thank you

Report message to a moderator

Re: FIELDS TERMINATED BY ","; NEED MISS "\," simboll [message #210523 is a reply to message #210499]

Thu, 21 December 2006 03:39

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

1. I cant use the url - you are providing
2. You dont want to load the "\" sign into your database,
is that the question ?

You have to be describe your problem a bit better......
Show an example of the data you want to load as well....

Report message to a moderator

Re: FIELDS TERMINATED BY ","; NEED MISS "\," simboll [message #210565 is a reply to message #210523]

Thu, 21 December 2006 06:02

nmomtselidze
Messages: 3
Registered: December 2006

Junior Member

Thank you,
The loading data are pumped from Nokia station.
198.18.8.1,http://kiss.best.su/?best\,star\,step2\,\,353456\,,,39,0,...
CTL:
FIELDS TERMINATED BY ","
(
nampServerIPaddress ,
fetchedURL ,
originalURL ,
.......
This data from comma to comma have to be written to fields
but not \,. It is C like char of comma, not terminator.

198.18.8.1 => nampServerIPaddress
http://kiss.best.su/?best\,star\,step2\,\,353456\, => fetchedURL
null => originalURL
39 => ... and so on.
........
So the problem is that "\," is not field terminator, only "," is.
I need comma as part of field.

Other examples:
198.18.8.1,http://beeline.mmska.ru/pay/6631429655/\,order\,8063,,0,0,
198.18.8.1,http://free.wapstart.ru/pics/item/g_id\,1\,i_id\,17?wsf=cae6406538383cbb15cc3e86e1ab251d,,515,0,

Thank you very much

Report message to a moderator

Re: FIELDS TERMINATED BY ","; NEED MISS "\," simboll [message #210579 is a reply to message #210565]

Thu, 21 December 2006 06:40

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Why isnt the fields seperated with ; or |
Would be easier for you then.....

Have you looked into using external tables ?

[Updated on: Thu, 21 December 2006 06:40]

Report message to a moderator

Re: FIELDS TERMINATED BY ","; NEED MISS "\," simboll [message #210608 is a reply to message #210579]

Thu, 21 December 2006 09:08

nmomtselidze
Messages: 3
Registered: December 2006

Junior Member

Thank you,
Input data are comming from different switching stations,
and are constructed with the program which is beyond reach.
So I can not change it's stucture.
Moreover, they are tremendous large.
Extra revision takes a lot of time.
So I forced to use DIRECT loading which excludes
any additional processing while loading.
Most likely, I have to write some preprocessor to
avoid this problem.
Is it possible, there is some unreported opportunity,
like TERMINATED BY "," and NOT TERMINATED BY "\,"
or samthing like that?

Thank you anyway

Report message to a moderator

Re: FIELDS TERMINATED BY ","; NEED MISS "\," simboll [message #210663 is a reply to message #210608]

Thu, 21 December 2006 12:36

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

In your controlfile, can you not do this on every column:

column1 "substr(:column1,1,length(:column1)-1)"

Report message to a moderator

Previous Topic:	Load first 2000 characters using SQL LOADER
Next Topic:	Not import the file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 22:07:21 CST 2024