rmstar Posted October 9, 2017 Posted October 9, 2017 Basic question.... Where do I find help on partial word searches? I've been ...searching.... for a good writeup on FMP search operators that cover this to little avail. I need a expression that will search, get to a character, and then ignore/wildcard from there. So a search on "Chicago" will return: Chicago Chicago-IL Chicago-001 and so forth.....
LaRetta Posted October 9, 2017 Posted October 9, 2017 Hi, FM Help covers it quite well here: Finding records To find in this example ... enter just chicago The dash is a word separator but even without a word separator, searching for chicago will also find chicagoian. What are we missing in understanding your request? If the example wasn't quite right, and you want to find a word which is WITHIN other text, then you can use the wildcard character as: *chicago*
rmstar Posted October 9, 2017 Author Posted October 9, 2017 Nope, you have it correct; I didn't find anything stating that a dash qualified as a word separator.
LaRetta Posted October 9, 2017 Posted October 9, 2017 I'm afraid that your response didn't help us solve the issue here. The dash makes no difference - ANY word starting with 'chicago' will have been found. Are you searching a related table? We need more information then to help you because searching would work fine in your examples.
rmstar Posted October 9, 2017 Author Posted October 9, 2017 I don't know more; I'm the sysadm not the FMP programmer. As it's set up now, there's a script that finds duplicate nouns. I need it widened beyond exact duplicates to exact+suffix cases. I wanted to first understand the search before going to the programmer.
LaRetta Posted October 9, 2017 Posted October 9, 2017 If the script is searching for EXACT, then it probably begins with == but we can't say for sure without seeing the script. Find the script, print it to PDF or save as PDF and post it here for us. However, I would caution about considering a change without speaking with the developer. There may be good reasons it is finding exact in this instance. Still, we are happy to take a look for you to help you understand it. :-)
rmstar Posted October 9, 2017 Author Posted October 9, 2017 Don't plan on changing things behind her back..... Just wanted to know what we were getting into.....
LaRetta Posted October 9, 2017 Posted October 9, 2017 I wasn't implying you would do anything 'behind her back' ... I was only properly cautioning you. We still need to see the script if you wish to know how it would be changed to meet your request, which still isn't quite clear. :-)
Lee Smith Posted October 9, 2017 Posted October 9, 2017 3 hours ago, rmstar said: I don't know more; I'm the sysadm not the FMP programmer. Shouldn't you be sitting down with your FMP programmer and discussing what changes you would like them to make?
Recommended Posts
This topic is 2855 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now