Concatenation in SQL Loader
From: <michael_pusateri_at_i2.com>
Date: 1998/04/07
Message-ID: <6gdijn$f3n$1_at_nnrp1.dejanews.com>#1/1
Name - John Smith
Address - 1234 Anywhere Rd Suite 10
CityStZip - Dallas, TX 75248
Date: 1998/04/07
Message-ID: <6gdijn$f3n$1_at_nnrp1.dejanews.com>#1/1
I am trying to read an ASCII file and concatenate the following fields!
ASCII FILE
John, Smith,1234 Anywhere Rd, Suite 10, Dallas, TX , 75248
DATABASE TABLE
Name - John Smith
Address - 1234 Anywhere Rd Suite 10
CityStZip - Dallas, TX 75248
Any suggestion on how I would do this in SQL Loader?
Michael
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 07 1998 - 00:00:00 CEST