How to insert unix new line in between the single records?

say2prabhu1 · Post by **say2prabhu1** » Thu Jun 05, 2008 5:08 pm

Each record having length of 1800.. While I am loading into the file ,I need to split these records into three.. Basically I need to insert unix new line after 600 length.. the second and third records 600 column defintion(column length) is different..

How can i load the single record into three rows in the final file?

Advanced Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jun 05, 2008 5:44 pm

Run the UNIX command split over the file. Or, instead of outputting one 1800-character string, output an 1802-character string with two Char(10) characters inserted.

Code: Select all

Left(InLink.TheString,600) : Char(10) : InLink.TheString[601,600] : Char(10) : Right(InLink.TheString,600)