delimited flat-file

[nitin376]

How to turn spread sheet (xls) into a delimited flat-file ?

[mctny]

How to turn spread sheet (xls) into a delimited flat-file ?

you can save the file as csv ( coma delimited) or tab delimited or unicode text.

[nitin376]

How to turn spread sheet (xls) into a delimited flat-file ?

you can save the file as csv ( coma delimited) or tab delimited or unicode text.

Thanks for the promt reply.
See I am new to datastage , I have been told to convert spred sheet file to delimited flat file using datastge.
What i did is saved that files as cvs and then i loaded into seq stage and used the transformer just to map and then out put into seq stage with extenstion .dat. Also in the format tab i clicked first row is column.
The programs runs but when I see the output of the seq stage file , it shows same data format as input.
Please help me with concepts, i may be doing a sily mistake.

thanks

[mctny]

what do you want to do ?
you don't need DataStage to convert an excel spreadsheet to a flat file.

just save the spreadsheet as a csv, if you want a different delimiter other than comma, open the csv file in notepad or wordpad and replace all commas with your desired delimiter.

after that you can save that file in dat extension as well. see you don't need datastage at all to do all of this.

[chulett]

If you have to use DataStage to do this, then search the forum for the many posts on using ODBC to read the .xls file directly. You'll see mention of setting up a DSN, reading 'system tables', handling worksheets, etc - this only works on a Windows server, by the way.

Well, not 'only', but for UNIX you need to purchase specific ODBC drivers, whereas Windows comes with what you need. You can certainly do it, but it's much simpler to save it as a .csv or some other format directly from Excel... or look into macros or other means to automate it.