Jump to content

Answer: Importing data that doesn't have a format!


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

Recommended Posts

First of all, I have to give the credit to a fellow forum member, amccallum who came up with this particular solution. This idea is helpful to those that would like to import information from documents without any kind of real formatting.(Example: Simpletext and Notepad).

First create a parsing database. Just open up a new database and create a text field that the info from the document that you want parsed into a database will be pasted into. Copy the document and paste it into the text box of the parsing database. Once you have descided what info you want from that document into a formal database, create calculation fields that will contain the desired data. Use the Trim(Middle(Parsing field text box name, Position(...)))in conjuction with other text functions as it applies to islolate the data in the document. Then the data can be imported into other databases if required.

This was helpful to me in the case that I regularly receive documents in a standard stationary pads like simpletext and the address of the person who sent it is always in the same spot though it is not comma nor tab delimited.

Link to comment
Share on other sites

This topic is 7702 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.