September 7, 200619 yr 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.
September 7, 200619 yr 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