HomeForum
Welcome, Guest

Transfer data from a FoxPro DB to a MySQL DB
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Transfer data from a FoxPro DB to a MySQL DB

Transfer data from a FoxPro DB to a MySQL DB 1 year, 2 months ago #2197

  • Anna
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
  • Karma: 0
Hello

I’m using Aetl pro to transfer data from a FoxPro DB to a MySQL DB. For what ever reason, FoxPro has lots of spaces on every field (ex. First Name = “Anna “).
Is there a way for me to trim each field as I transfer the data?

Thanks,
Anna

Re: Transfer data from a FoxPro DB to a MySQL DB 1 year, 2 months ago #2198

  • Anna
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
  • Karma: 0
Add trim transformation function to each field

Like on picture attached

Peter
Attachments:
  • Page:
  • 1
Time to create page: 0.18 seconds

Testimonials

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top