Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC:

Batch Processing Fixed Width Text Files to Excel 1 year 2 months ago #19178

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
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?

Please Log in or Create an account to join the conversation.

Batch Processing Fixed Width Text Files to Excel 1 year 2 months ago #19181

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7856
  • Karma: 33
  • Thank you received: 475
Do you want to create one excel file per source or just one big excel file?
Mike

Please Log in or Create an account to join the conversation.

Batch Processing Fixed Width Text Files to Excel 1 year 2 months ago #19183

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
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.

Batch Processing Fixed Width Text Files to Excel 1 year 2 months ago #19185

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7856
  • Karma: 33
  • Thank you received: 475
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
Mike

Please Log in or Create an account to join the conversation.

Batch Processing Fixed Width Text Files to Excel 1 year 2 months ago #19186

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
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.

Batch Processing Fixed Width Text Files to Excel 1 year 2 months ago #19187

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7856
  • Karma: 33
  • Thank you received: 475
Here it is

Mike
Attachments:

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2

We have 223 guests and 2 members online