OraFAQ Forum: Server Administration » String Move in Text Editing, etc....

Home » RDBMS Server » Server Administration » String Move in Text Editing, etc....

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

String Move in Text Editing, etc.... [message #372114]

Wed, 10 January 2001 13:17

sat
Messages: 3
Registered: January 2001

Junior Member

Need help with text editing, sql or string conctenate of multiple lines relating to one record. I wish to convert a cuistomer master into an importable asci file but the problem I have is that the file is print file and has cust #, name on line 1, and add line_1 on the next line, etc.

example: 1000 Nameless Trader
10020-90 Avenue
Surrey, BC
V3V 4BX

I need to put them as follows:-

1000 Nameless Trader 10020-90 Avenue Surrey, BC V3V..

Any assistance will be highly appreciated

Thanks in advance

Report message to a moderator

Previous Topic:	Defragmentation of tables in oracle
Next Topic:	recommended books

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 06:05:14 CDT 2024