Search the Community
Showing results for tags 'text file'.
Found 2 results
Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that. Thanks in advance, Mike
gczychi posted a topic in Remote Container FieldsHi, it's probably very easy, but I don't know how to access the data inside of a container field. I have a script that inserts a small text file (insert, no reference) into a container and all I can see is a file icon with the filename. When I use «GetAsText(ContainerField)», I only get the filename. But how can I access the data inside of this container/file? I need to perform a couple of text manipulations and store the results in another field of this record. Thanks so much for any help. Gary