Re: Sqlldr help

funky.
I would replace \ by 0x10 (awk?)
and then should separated by '/' work

oli

On Fri, 22 Sep 2000, Ashish Shah wrote:
> I have file format like below.. it's only big line..
> fields are seperated by '/' and '\' means end of a
> record.
>
> What is the best way to load this file using sqlldr.
>
> 929827081384/QMSL/965821846858#216.10.166.52/1/7775/7775/0/0/0/1077.5249999
>95716/USD/965827868940/100/3/F/300////0/1B-
> -RN-26584356\963404816559/MNKN/965827167
> 777#172.153.170.192/1/850/0/0/0/0/1558.14999999708/USD/965827869212/25/1/F/
>25/7/11-13-5-10-30-29-39/$$/0/1-30-9-21-36-19-22-25-7-33-28-0\961264536939/C
>LSL/9658
> 7770775#63.76.159.204/1/22180/22180/0/0/0/1898.1949999965402/USD/9658278693
>28/5/
>
>
> =====
> Ashish
> Toronto, Canada
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/

-- 
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de
---------------------------------------------------------------