Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Tab Delimit Import Problems

jfmcel
in Importing & Exporting

Featured Replies

I am importing data from a web submission. I am getting aberent characters that cause FM to create a new record too soon. If I go through the data in Word, I can find and eliminate most of these characters. (Most of the offending characters appear as little boxes in Word.) If I then look at the data in NotePad, I can find a few more. (In NotePad, the character appear as small boxes.) But in the end, I am still having records split up into different records. Any ideas?

Are you forced to use a tab-delimited file? If not, try a comma seperated file and see if you get better results.

Run the import through Excel, rather than Word. You can still strip the bad characters, but Excel will output a much better file for importing.

  • Author

I was thinking that approach might work.

I would like to automate the process. I suppose it might be time to start learning some Excel macros.

Create an account or sign in to comment

https://fmforums.com/topic/1444-tab-delimit-import-problems/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.