Jump to content

Data sorting after flat text file import help


This topic is 6465 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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