Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

complex flat file - delimited?? 2

Status
Not open for further replies.

q4s72534

MIS
Aug 19, 2003
59
US
I have a csv file that i want to start at the 4th record. so i'm using the complex flat file. how do i set it as delimited?

Thanks
 
Hi,

If I have read your question correctly, Im assuming you want to read a CSV file as an input into a job, and only want to take the 4th line (record) and records after that.

Why dont you just use a sequential file stage (comma delimited) and pass it through a transformer stage that has a constraint of @INROWNUM >= 4 ?

J
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top