Search the Community
Showing results for tags 'parsing'.
Found 7 results
-
Pardon my brute force learning methods I'm using this from another thread here since it's pretty much what I'm trying to learn. My intention here is more to verify what I've got already in my database against the book(s) in my possession. But if there's something missing may as well grab it....
-
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...
-
Hello Am trying to clean up the email field on a filemaker database. At the moment there are many records that contain more than one email address or an email address and text. what I want to do is delete everything in the field apart from the first email address In the vast majority... -
Hi All, I am trying to parse text from a Job Card Items table into the related Job Card and not getting the correct result.. as the Items in the Job Card are completed any anomalies have to be reported on the Job Card and with up to 50 items in the Job Card Items there may be more than one anom... -
Hello, I am a FM newbie and have been scouring the web for an answer to this problem: I want to eliminate the text within parentheses in a string, but I want to eliminate all instances: ORIGINAL STRING: This is a test of the (emergency) broadcast system. (It is only a test). Remain calm... -
Hello All, This is probably one of those easy ones that I cannot get past. I have imported time data in the form of "01h:09m". I need to parse the two digit hours into one field and minutes into another. I can isolate the right three values, in this case "09m" but how do I remove the "m"...
-
mac How to parse 1 field into 6 separate fields
BAW posted a topic in Calculation Engine (Define Fields)
I have been given responsibility for making sense out of between 750-1000 records that contain the legal description of land parcels containing oil & gas mineral leases. The listings currently all have a single field containing that information. I need to parse that single field into 6 new fields....
