hi,
i have a source file which is in csv format, i want to convert this to pipe delimited to load it into the database, can you please help how can we do this using data integrator
thank you.
manjub (BOB member since 2008-10-17)
Why do you want to create a pipe delimited file to load it into the database, while you can directly load .csv files using Data integrator.
Any ways you can use the information given in the below link to play with file formats…
https://wiki.sdn.sap.com/wiki/display/BOBJ/Flat%20Files
Let me know if you need more help…
Thanks,
BS
Bindaas BODS 
(BOB member since 2010-03-25)
Attached is the file in xls format because it is not taking in csv as a attachment, i need to do below task
1.i have to trim first 8 rows and 10th row then load it in to the data base, can i do this using data integrator please help
thank you.
AccountMedia.xls (36.0 KB)
manjub (BOB member since 2008-10-17)
Hi,
What you can do is create a file format for your source csv text file, skip the top 10 rows in the file format.
For the first time use:
Use the following in the file format:
Delete the 9th row,
Skip top 8 rows,
Skip row header. Then you don’t have to edit the field names…Once this is done, starting from the next load, edit the created file format and use
Skipped rows = 10 for all the next loads. Then there shouldn’t be any problem…
Once your file format is ready use the query transform and create an output file format with the pipe delimiter.
Lets see if someone can help you with a better solution.
Thanks
BS
Bindaas BODS 
(BOB member since 2010-03-25)
Hi everyone,
Is there a way to read “.csv” files directly in Data integrator
if not possible, may be a work around with out manual intervention . I have tried it myself with no luck.
Thanks and appreciate any replies.
BS
Bindaas BODS (BOB member since 2010-03-25)