Jump to content

Problem importing a huge text file


cmteng
 Share

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

Recommended Posts

  • Newbies

Hi all,

I'm new to FileMaker. I need to import a huge student database (currently in text file) into a database which contain 3 fields, Name, particular and date motified.

The format of the text file is in following

Name<return>

<return>

<tab>particular<return>

<tab>particular<return>

<tab>particular<return>

<return>

<tab>particular<return>

<tab>particular<return>

<tab>particular<return>

<return>

<tab>(Date format in yyyy-mm-dd)<return>

<return>

Name<return>

<return>

<tab>particular<return>

<tab>particular<return>

<tab>particular<return>

<return>

<tab>particular<return>

<tab>particular<return>

<tab>particular<return>

<return>

<tab>(Date format in yyyy-mm-dd)<return>

<return>

................

The information in 'particular' contain line break and I need to remove the line break after importing the information into FM. The tab is front of each line have to be removed as well. The 'particular' contain several sentences and each sentences is not just limit to 3 lines.

As for the date motified a ( is added in front of the date and a ) is added at the end of the date. Certain student particular in the text file doesn't have information on date motified.

I really need to import the information into the database as soon as possible. I appriciate any help your guy, the expert can offer. A million thanks!

Link to comment
Share on other sites

Open the file on your favorite word processing program and use its find/replace commands to masage the text. Save the resulting file as text only (important!) and import this into the database.

Alternatively, go back to the source and get the data in a less zaney and outrageous format.

  • Like 1
Link to comment
Share on other sites

This topic is 7197 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
 Share

×
×
  • Create New...

Important Information

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