Search on imported Txt Files

[nemak]

I need help please.I have file maker pro 9.I am tryig to import txt files into the database and search by GMON (like employe id) or by name.But everytime i import don't match with field.Can everyone help me please.it can be php or asp script also.I just want to search stuff on txt files.I am attaching file with this post.Thank You.

SAMPLE.txt

[RalphL]

Looking at your text file in a word processor will help you see some of the problems. In FileMaker you want either a tab or comma delimited file, with a Paragraph Maker (¶) at the end of the record. There are no tabs and many Paragraph Makers in your file.

I would use a word processor to fix the file before importing.

[Lee Smith]

Hi nemak, and Welcome to the Forum.

Let me start by saying that Ralph has suggested exactly what I was going to say. I would only add, If you have any ability to change the export file format from the originating source, you might find one that matches your needs better. File Formats are also available in your Online help.

This Topic comes up from time to time, and if you do a search of the Forum for Parse, Parsing or Extracting data from text files, you should fine several treads on this subject.

BTW, FileMaker is one word, not two "file maker".

HTH

Lee

Edited March 10, 2009 by Guest