filemaker 8 user

Sorry the returns cannot be cleared, this is what makes this so difficult for me.

Anyone with any help on this would be great:)

1. yes the returns are there, this is how the file is given to us from our supplier. 2. yes the first two lines are always the ISA and GS segments. 3. Yes the SE line is not needed. 4. Yes the ( GE and IEA ) are always the last two lines 5. the ST number is a unique serial number. Thanks

Attached is the file Im trying to create from an import of the 810.txt. 810.fp7.zip

Thanks, I did not make my question detailed enough. I know what the field definitions are for the 810 but Im looking for a way to import this info FMP. Right now its just one line with "~" breaking each line. How can I import each of the the lines into the database in some meaningful way so that each person in the 810 will have a record. Next post is the example of the 810 in FMP.

I have an 810 edi format file that I need to import into filemker pro 8. I have no idea how to do this. I have looked this up everywhere I can think of, but to no avail. Can anyone help. A sample is attached of the 810 file. The filemaker database im importing it into will be built from scratch for this once I know a bit more about the import. Any help would be grand! INVOICE.810.TXT

I have two databases 1. customer_database.fp7 that has multiple records per customer. ie: Name,email,date ordered,product name record1: joe blogs, joe@aol.com,11/4/2008,product1 record2: joe blogs, joe@aol.com,8/2/2007,product4 2.email_database.fp7 is a database for customer service to answer emails. The two databases are joined by email address. The problem I am having is that when I come across an email from joe@aol.com in the email_database.fp7 it shows his old order from 8/2/07 instead of the one from 11/04/08. Is there a way to sort by newest record or something in the customer_database.fp7 so that the related record from customer_database.fp7 will be the newest. Im newbie to FMP and Im using FMP8. Any help would be great!

Its in word, lee.

Thanks for the reply. I downloaded your image but IM still lost? I dont see how I can add a drop down list of the 5 scripts?

I have a basic field layout that I want to put a drop down box that shows certain scripts in it. I have say 30 scripts in the scriptmaker but only 5 that i use alot. So I would like these 5 scripts in this drop down box. So when I want to perform script 1 on record 99 I can pull down script 1 from the list of 5 scripts. I do not know how to set up a button/edit box to do this. Any help would be great/ Thanks

That is true, I could make the same find from the message table. Let me explain, the subjects from the table repository are added as new junk mail comes in. I add a few new terms to this every day so that the next time a message comes in with this phrase it deletes it. This is why I need to keep these records the same, and have the table structure I have. If anyone can think of a better way to do this im all ears.

Im struggling with a junk mail filter. 3 tables -repository holds subject text that is known junk. -intermediate holds subject and message id -message holds subject, body, message id. I perform a find in table intermediate to delete all messages that match subjects with table repository. Once it deletes the messages in table intermediate it also deletes the corresponding messages based on message id in table message. The problem with this is that some subjects may say “Viagra now” so the match with the single word Viagra wont match and wont delete this message. The solution I can think of is to use pattern count from table intermediate to repository to get rid of terms like Viagra, ect. I have attached the database so you can see what I mean. A script has been added to get rid of the junk messages but as you can see when it runs it does not delete the Viagra ones. Im stumped on this one! junkmail.fp7.zip

Thanks a bunch, great answer!!

I have a field that has some non english characters in some of the records, eg: V�stervik Café StraÌ°åÄe Månzfa Sérgio ZÌ’rich Fürstenfeld What I need to do is if the record has a non-english character in it to do a calculation that finds all those records, so I can manually replace the non english "é", with "e". My original idea was to make a list of all the non english characters and do a pattern match but there are too many non english characters and no real way to know them all. Does anyone know how to do a pattern match or some other way to find all the non english character in this field? Thanks for your help

Thanks again Fitch, Ok I have the check box set up as a button but setting it up so that a click without shift sets a starting point is beyond my knowledge. What do I need to set this up, set the checkbox as a variable to record the record id? Hows doe sthe shift click initiate the script? I have attached a new example that has the script and the check box setup. I know Im close but just missing some details. Please take a look at the new example. Thanks mail.fp7.zip

Hey Fitch "You can simulate a shift-click with scripts. You'd want your checkbox to be a button that stores the record ID when selecting the checkbox. When shift-clicking, the script would loop from the current record back until it reaches the record ID, selecting all the checkboxes." I know with the above quote that you spelled out what to do but im still a bit lost. By shift-clicking do you mean: 1. click on the first record(say record 4) you want it to loop back 2.click on the last record (say record 13) 3. initiate script to loop backwards starting with record 13 deleting until it hits the first record #4 then exit the script. Is this what you are talking about? The spam issue is something I do not have the ability to change. Your options are great but due to things out of my control I cannot make any changes. Thanks

Got you on the script, thats no big deal. The real question im trying to answer is how to say check 25 records in a row without checking 25 boxes? This email account gets about 250 messages a day with say 25% spam so on monday I have to delete about 170+ spam messages. Clicking on a check box 170 times is no joke on the wrist. I was hoping someone would know how to rig a table so that you could just hilight the records you wanted deleted and then just delete them. I thought if you could drag over a few records and for them be hilighted or checked by just draging the mouse over a selection of say record 22-34, rather then clicking on each record of 22-34. Does that make sense. Thanks

I am setting up a database for my emails but the junk mail is killing me. I have set up elaborate rules to get rid of the junk but some always comes through. What I am trying to figure out is how to select multiple records at once in a table layout and delete them. I want to be able to check records 1-3, record 6, and reocrds 11-30 for example as they are all junk mail. The problem is that hitting delete for each one is tedious. Does anyone know a way to just click on a grouping of records in the table layout so that they can be deleted together once Im done picking through all the records? I have attached some samples of what im dealing with. Thanks mail.fp7.zip

Thanks, that got it. Did not think to set up each number with a #. Good one!

I have a text field called subject that I want to use the contents of this field to perform a find. Right now I do it this find and delete manually but I need to have it scripted. Here is the manual process: Go to record request 1st Copy contents of field subject Perform find in field subject paste the contents into the Criteria section and hit enter Delete retuned records Show all records Go to record request 1st I need for this above manual operation to be scripted but since you cannot paste into a criteria field for a find the script will not work. Has anyone ran into this before or has any ideas on how to work around this problem. Thanks

Sorry but im using FMP 8 v3 so the function ExtractNumber is not available to me. Is there a work around to this?

I have a text field that has an order number in it that is a 13 digit number. This number is in each record but the text is always different and the order number can be different. The only constant is that the order number is 13 characters long and is numeric. I cannot know what the order number or text will be so I cant do a portal or loop though to find the order number. Best if explained by example: record 1 qwreouh arw1226213456998eouaw awreohou arouw awgou record 2 agw24 erh43'pwr|gw4uon w4gpnhp5216813050354w4gh What im looking for is to make a calculation field that will trim off all the text and numbers that are not this particular 13 digit number order number. so for the above two records it would output each order number: record 1 1226213456998 record 2 5216813050354 Thanks

Thanks for the reply. That got it!

Im new to Filemaker and trying to make a calculation to calculate sales price of my database of books. I have attached my database of pricing for you to look though to see my logic. What im trying to do is set my sales price for each item in the database to be a set amount above cost. There are two variables that I have to contend with, one is a merchant fee of 14% of the sales price. The other variable is a credit card fee of 4% of the sales price. I have each item cost but im not sure how to set up the calculation field to set the sales price so that I make my desired profit margin. Im sure this is really basic but Im new to this, any help would be great! example.fp7.zip

I still dont understand. I am looking in the FMP book trying to figure out how to do a value list. I saw that it was a way to figure this out but I have not done one before, so Im still a bit lost. I have created a table with 1000 records with auto enter serial validated in the range from 1-1000. I have a unique id for each student so now I need to marry each unique student to their number? I just cant seem to wrap my mind though this?? Arrrgggg