Custom Parsing CSV Fil

Copper Contributor

Hi,

 

I have a CSV file with 4208 columns. But only first 8 columns are main columns and remaining 4200 columns are grouped into 14 groups with 300 fields each. But all are separated by commas. I don't want to read them as separate columns. Those will be too many columns. I want to read first 8 columns, and 14 columns each column containing 300 fields without splitting them.

Basically i want to read like below. can i do this custom parsing using copy activity (source)

col1, col2, col3, col4, col5, col6, col7, col8, [Col9-Col308], [Col8-Col607]...[Col3909-Col4208]

0 Replies