Page 1 of 1
Need to extract Excel file...
Posted: Tue Dec 26, 2006 4:10 pm
by swades
Hi Friends.
I have to load one excel file to Teradata DB.
But there is lots of white space in that file -row as well as in column,so need to remove.
and we dont have time to make macros for that.
so plz tell me better way to do it.
ok thanks .
Posted: Tue Dec 26, 2006 4:12 pm
by DSguru2B
Welcome Aboard
Save it as a CSV file or a tab delimited text file. Read it with a sequential file stage and load it to the database. Pass it via a transformer stage and use trim to trim the leading and trailing white spaces. Make sure you specify the columns as varchar.
Posted: Tue Dec 26, 2006 4:13 pm
by I_Server_Whale
Welcome Aboard !
Well! You can read the excel file and strip the white spaces while transforming.
Posted: Tue Dec 26, 2006 4:14 pm
by narasimha
Welcome Aboard :D
How do you plan to read the Excel file through datastage?
You have a ODBC driver for Excel on Unix to read from the Excel file?
If I had to do it, I would convert the Excel file to a csv file first and then go forward from there.
It's much easiers that way
Posted: Tue Dec 26, 2006 4:16 pm
by narasimha
Wow!
Three welcomes, swades - you are most welcomed newcomer!
Re: Need to extract Excel file...
Posted: Tue Dec 26, 2006 6:13 pm
by ray.wurlod
swades wrote:and we dont have time to make macros for that.
Make time.
Why is it there's never time to do it right, but always time to do it again?
It will require the same amount of work no matter which way you do it - DataStage is not a magic bullet.