- Posts: 26
- Thank you received: 0
Batch Processing Fixed Width Text Files to Excel
4 years 4 months ago #19178
by cchavez
Batch Processing Fixed Width Text Files to Excel was created by cchavez
I have been able to read in a single fixed width text file and convert it into an excel spreadsheet and it works great. I have 40 of these text files that all have the same layout that I would like to batch process so I don't have to do every individual file.
I was thinking I could have two readers one for the file directory and the other for reading in a fixed width text file but that doesn't look like a solution with the reader objects.
Given this use case to read in a directory of fixed width text files what is the best practice to batch these files into the .xlsx now I am able to transform them?
I was thinking I could have two readers one for the file directory and the other for reading in a fixed width text file but that doesn't look like a solution with the reader objects.
Given this use case to read in a directory of fixed width text files what is the best practice to batch these files into the .xlsx now I am able to transform them?
Please Log in or Create an account to join the conversation.
4 years 4 months ago #19181
by admin
Mike
ETL Architect
Replied by admin on topic Batch Processing Fixed Width Text Files to Excel
Do you want to create one excel file per source or just one big excel file?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
4 years 4 months ago #19183
by cchavez
Replied by cchavez on topic Batch Processing Fixed Width Text Files to Excel
Ideally, I would like to create one excel per source. A nice to have would be able to create one big excel file.
Please Log in or Create an account to join the conversation.
4 years 4 months ago #19185
by admin
Mike
ETL Architect
Replied by admin on topic Batch Processing Fixed Width Text Files to Excel
This functionality has been here from the day the software was created.
To create one excel file from multiple text files specify the mask.
To create one file from one source file use examples provided within default repository
Dynamic Files Names 1 - Dynamic Files Names 2
To create one excel file from multiple text files specify the mask.
To create one file from one source file use examples provided within default repository
Dynamic Files Names 1 - Dynamic Files Names 2
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
4 years 4 months ago #19186
by cchavez
Replied by cchavez on topic Batch Processing Fixed Width Text Files to Excel
Thanks I apologize where are the default repository - Dynamic Files 1 & 2? I see a demo repo that gets installed.
Please Log in or Create an account to join the conversation.
4 years 4 months ago #19187
by admin
Mike
ETL Architect
Replied by admin on topic Batch Processing Fixed Width Text Files to Excel
Mike
ETL Architect
Please Log in or Create an account to join the conversation.