Simple Importing?

[_henry_]

Hello all,

I need help with my problem. Here is the condition. I want to import records from text file (txt). I gave the simple sample of text file with the filemaker solution.

Basically, I want to import all the records in there. However, the unique thing was happened. It could not read word after "," and if there is quotation mark in the word, it would make the same line.

I just want to see the importing did the same exactly as Notepad do. Is it possible?

If this thread has been discussed before, please let me know the link.

Thank you in advance for your help... :smile2:

Import.zip

test.txt

[Lee Smith]

This typic comes up from time to time. It usually has the words Parse or Extract and Text in the Subject of Body.

Your sample text isn't very helpful, is it exactly the same as your import?

Do you really want each line in a separate record?

Do a search of the Forum for [color:blue]+Parse +Text, or [color:blue]+Extract +Text and to narrow it down, you could also include [color:blue]+Import (use the plus sign with the words as shown).

You can help your effort by attaching a copy of the real test.

HTH

Lee

[_henry_]

Hello Lee,

Thank you for your response. I attached the test.txt is the similar format of information that I would be using for. It contains comma (,) and quotation ("xxx")

You can save test.txt in the Desktop and you can set the location of Import function to the test.txt (Desktop). The "test.txt" file is the file that I want to Import the records from. Then I parsed it to the FM sample. The result can be seen directly in the FM sample file.

I am asking if the FM can read txt for every single line and it would parse every single line to the solution.

I read in the FM help that sentences in Quotation would make it become a single line?

[Lee Smith]

As it is now, you have parsed the text into separate records (5). If you click in the 5th Record, you will see that you have two lines, could this be what you were looking for?

I looked at the text, and there isn't much there. Usually, the text that we want to import has thing that you don't see in a small sniplet. Hence the reason I wanted to see the Actual text.

I usually prepare text in a Text Editor for import, as for me it is the easiest way because, the one I use has the ability find and replace using regular expressions, and Grep Patterns. Once it is setup, it is a snap for importing.

Lee

[sbg2]

When you tell it to import as a .csv then combinations of comma's and quotes indicate field seperation. Try a .tab import (of course any tabs in the text would indicate a new field).

Edited November 30, 2007 by Guest

[Lee Smith]

There are no tabs in the sample text.

[_henry_]

Hello Sbg9,

Thank you for your input. Firstly, I chose the csv, so it just make my text gone. After I changed to your suggestion. It works perfectly =) Thank you for your help...

Also, thank you Lee for your help..

[sbg2]

Right, just trying to make the original poster understand what would happen if there were tabs in the text they wish to import.

[Lee Smith]

My remark wasn't aimed at you, it was meant for the OP.

The OP has responded that they have the answer they needed, however, I trying to figure out how the returns became tabs?

Lee