I want to import a txt file that has BOTH tabs (for delimiting) and commas (in fields); but FM imports using the comma as the delimiter. I want to use the tabs, NOT the commas for delimiters. Does anyone know how to do this?

When importing a window opens asking you which file to open. At the bottom of the file is a drop down menu that initially reads "Show: All Available". Check out the options in the menu as both tab and comma delimited are listed.

quote:

---

Originally posted by sevaka:

I want to import a txt file that has BOTH tabs (for delimiting) and commas (in fields); but FM imports using the comma as the delimiter. I want to use the tabs, NOT the commas for delimiters. Does anyone know how to do this?

---

We've been here before. We've grabbed raw data from a medical product that had tabs, but addresses and names had commas in their fields. We solved this by importing the data into Excel (tabs only), then exporting the data to a DBF file, then importing into File Maker Pro.