Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Transforming fixed width files

Transforming fixed width files 10 months 2 weeks ago #18579

  • Derrick
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hello

We have to take a series of Excel and CSV files that we need to translate into a fixed text length file that one of our partners requires.
We don't have any programmers on staff so we are looking for the right tool that we can setup and repeat to meet our partner's strict fixed text length format.
We are only translating flat files there is no need for databases.

Derrick

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

Transforming fixed width files 10 months 2 weeks ago #18580

Hi Derrick.

Thank you for contacting us.

For fixed width files Advanced ETL Processor would be the most suitable.

Working with very wide fixed width files can be very tricky.
Yes, you can use the mouse to set the width but what if there are 100+ fields?
With our software, you can copy and paste fields definitions from excel, that saves a lot of time.
(There are a lot of small things designed to make the life of a developer easier)

Please watch these tutorials to get started.
www.etl-tools.com/tutorials/data-writer-tips-and-tricks.html
www.etl-tools.com/tutorials/01-introduction.html

The trial period is 30 days and we can extend it for you if necessary.
Our software is fully functional during the trial period.

I recommend using the 32-bit version at the beginning, it is much easier to set up.

Maria

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

  • Page:
  • 1

We have 294 guests and no members online