Split single line data into Many

[techvarun]

Hi QliXperts,

I need to convert the below single line of data into three.

          This is my actual data.

Receiving Date	Doc In	Avarage package	Batch Type	BatchID	Barcode	ComplaintID	Assign Date	Date Scan	System
6/29/2016 15:32	3	30	Outer Package	681633	16005003228 to 16005003230		6/29/2016 15:32	6/29/2016 15:34	Vat Tool Header 1

I need to covert that into three based on Barcode column Like below

Receiving Date	Doc In	Avarage package	Batch Type	BatchID	Barcode	ComplaintID	Assign Date	Date Scan	System
6/29/2016 15:32	3	30	Outer Package	681633	16005003228		#########	#########	Vat Tool
6/29/2016 15:32	3	30	Outer Package	681633	16005003229		#########	#########	Vat Tool
6/29/2016 15:32	3	30	Outer Package	681633	16005003230		#########	#########	Vat Tool

Any help would be appreciated.

Thanks,

Villa

[tresesco]

Try like:

Load *,

  SubField(Barcode,'to',1)-1+IterNo() as Barcode2

While SubField(Barcode,'to',1)-1+IterNo() <=SubField(Barcode,'to',2);

Load * Inline [

"Receiving Date", "Doc In", "Avarage package", "Batch Type", BatchID, Barcode

6/29/2016 15:32, 3, 30, Outer Package, 681633, 16005003228 to 16005003230

]