Jump to content

FM Newbie

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About FM Newbie

  • Rank
  1. @Lee Smith: Outstanding Solution. Thanks!
  2. OK ... I changed the file suffix to csv, and now the quotes are gone, but all the data is stuffed into one field (like what Excel did). Any more suggestions?
  3. Is there a function that works the opposite of Filter? (e.g. exclude/remove the Filter list items rather than include-only the Filter list items)
  4. Thank you for you rapid reply. 1 question: I am letting FMP decide when I drag & drop the file onto FMP. How do I tell it to try csv? 1 comment: when I tell Excel to use csv, it imports the whole record into a single cell ... that's why I was thinking it was not csv.
  5. Greetings, I have an extremely large tab delimited file. When I drag & drop it onto Filemaker, it loads fine, but all the data shows up after import with quotes in each field, like: "John" "Smith" "1234 Mainstreet" "Yourtown" "NY" "10234" How can I either: 1) reimport so the quotes vanish 2) strip out quotes after the import (note: If I open one of these txt files in Excel, and use the import wizard, selecting 'tab delimited", it goes into Excel perfectly) Thanks in advance for any help you can provide.
  6. Fantastic, Thanks! It Worked. (where would I find that level of detailed documentation about the various functions and their specifics?)
  7. Greetings, I am using FMP10adv on Windows Server 2003. I have a field containing one or more of the following characters: SMFOICVPHX (but only one of each), so a particular field could contain S or SM or MS or FM or FMSO or any combination. I am writing a script fed by checkboxes on a layout to search for all fields containing a character selected by the user. If I manually go into Find Mode and enter *M* it will find all the correct records. ... but trying to script it as follows (after entering find mode): Set Field[Table::Field;"*" & LeftValues($values;1)
  8. I have FMP 10Adv newly loaded on a Windows Server 2003 with 4 cores, 4 GB, and 1.8 GHz per core. I access the system with Remote Desktop. I am running a table migration script against a table of 160,000 rows and 79 fields, migrating to 7 different tables with a variety of rules and calculated conversions. FMP seems to be only using about 50MB with a total of 800 MB in use (nothing else really going on, except a couple of IE windows open, but not used). It looks like this will run about 16 hours (note: after 40,000 records and 8 hours, I figured out to turn on Freeze Window ...
  9. Wow, such great information. This will be immensely helpful. It will be nice when FM supports RegEx searches. Does anyone know if they have a plan for that?
  10. Thanks to both of you. You have given this newbie a lot to study. A couple of things: 1) I fixed it, purely by stumbling around. The answer is based on a piece of information I didn't give you. The ContactID field is the email address. Apparently, the @ in the email address causes FIND to do funny things (I did not know this). I was trying various things, and tried adding the "==" operator to the Set Field before the Perform Find. Apparently that causes the @ to be performed literally, and it all started to work: Set Field [ IM_Contacts::ContactID; "==" & $CN_ContactID
  11. I am very new to Filemaker. I am using FMP 10 Adv. I have setup a staging table to receive data from a flat file csv import. I am building a script to migrate the various fields from the import staging table into a appropriate application tables, but I am running into a problem the *next* time I run the script if there are duplicate entries in the second file (which is a valid use case) The first time I run the script with all new data, it works fine. The second time I run it (with duplicate data [the script *should* detect and bypass duplicate data]), I get the following Error:
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.