Rocket Software Homepage
Forum Home Forum Home > AccuTerm Knowledge Base (read only) > File Transfer
  New Posts New Posts RSS Feed - CR+LF within MS Access fields creates new items
  FAQ FAQ  Forum Search   Register Register  Login Login

The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum.

Forum LockedCR+LF within MS Access fields creates new items

 Post Reply Post Reply
Author
Message
lucasn View Drop Down
Newbie
Newbie


Joined: September 02 2016
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote lucasn Quote  Post ReplyReply Direct Link To This Post Topic: CR+LF within MS Access fields creates new items
    Posted: September 02 2016 at 4:14pm
Using FTIMPORT on D3.
I'm trying to import tables from an old MS Access .mdb file.
Some of the individual fields in the Access records contain embedded CR+LF characters.

When I use FTIMPORT to import one of these tables, every embedded CR+LF pair is treated like a record break and a new item is created.

As a workaround, if I use MS Access to export the table to an Excel spreadsheet first, FTIMPORT is able to handle the CR+LF pairs just fine, perhaps because DELIM in the MODE parameter is more meaningful with a spreadsheet?

Is there an AccuTerm FT routine + set of options that will correctly import from .mdb files with embedded CR+LF pairs?

Thank you!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.