This topic is 2595 days old. Please don't post here. Open a new topic instead.
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,
By Maker of Files
So I want to export a text field to a website. The text field has many, many tab characters to set up alignment of lists, indented paragraphs, etc. However, it appears as though GetAsCSS() completely ignores them. However, I know GetAsCSS() sees them, because when I tried to Substitute() them with an html entity, the text becomes full of "&tab;" or " ..." or whatever. Does anyone have any solutions about how to handle this? I haven't been able to find anything. Any ideas are appreciated.
I have a tab control with two tabs. Each tab has a portal in it. It displays properly in edit layout mode, but when I re-enter browse mode, all of the portals get superimposed on top of each other. The portals are well within the margins of the tabs, so I'm not sure what's up.
I am trying to update our database and create more space. When it was originally developed, the bottom half of the screen was split into two separate tab panels and information has been stored that way for years. I would like to merge all tabs into one large tab panel. Is this possible?
Who Viewed the Topic