Skip 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.

Data sorting after flat text file import help

Featured Replies

  • Newbies

My current project requires me to import text files that contain names and related details, I have been successful in importing this data to a single field but in one recordonly. Is it possible to streamline this so I can get the name and related data into seperate records in the quickest and easiest way, my contraints appear to be because the source is not an excel doc or commas have not been entered in a logical way, carriage return has been used however. The word (txt) doc contains data like this:

Joe Blogs

Born Penzance Sept 1859

Joe Blogs2

Married Marlyebone, London Jul-Sep qtr 1848

Joe Blogs3

Died Henly Oct-Dec qtr 1849 (BMD 3b 466)

Each Joe blogs would ultimately become an individual record.

Thanks in advance for anyones input.

If you place the text file in its own folder and use the File>Import>Folder option you can import the complete text to one field (I would suggest a global field). Then you can use a couple of global counter fields to count which record the information belongs in and which line you are at in the global text field. Using the Middle Values function you can extract each line one at a time.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.