Home » RDBMS Server » Server Administration » String Move in Text Editing, etc....
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
Previous Topic: Defragmentation of tables in oracle
Next Topic: recommended books
Goto Forum:
  


Current Time: Sun Dec 22 21:17:04 CST 2024