Jump to content

Remove Quotation marks from non alpha characters

This topic is 2957 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm struggling to remove quotation marks from a symbol/operator such as this:


I have tried Substitute (Text; "\""; ""), as well as Brian Dunning's custom function RemoveSmartQuotes (text). Both works in the field of question perfectly with normal text, such as {hello "world"} ends up being {hello world}, but ho matter what I run "<" through, the quotation marks remain untouched.

Any ideas?

Edited by artvault
Link to comment
Share on other sites

Believe it or not, this is actually it:    "<"    From that I need to remove quotation marks, so that I simply wind up with   <   in the field. Seems simple...

Link to comment
Share on other sites

Just now, doughemi said:

In your original post, you used a forward slash / instead of a backslash \


Sorry, my bad, should be a backslash (FM automatically converts """" to "\""). I'll fix it.

I don't think I should be working that late... I created a new file, same technique (supposedly), and it works! 

Sorry for taking up your time.

I'm posting the sample file. Maybe this will be helpful to someone.


Just FYI: I'm not going totally crazy. Luckily! 

Where it FAILS is in Find Mode. In Browse Mode it works like charm. So that might very well be impossible to solve. I'm am curious to why this is the case though...

Link to comment
Share on other sites

The > is an operator and needs to be escaped using the backslashed.

This find work with your sample file 

Enter Find Mode


perform find

BTW this was the replace calculation I used

Substitute (   YourField ;  "\">\""; ">")

Link to comment
Share on other sites

Thank you all for trying to help! I have taken the time today to separate all of the functionality that's related to this question and put it in a (new) sample file. I realize that the solution might consist of a work-around of sorts, so it's important to have the context.

In the file attached you can see an attempt to emulate FileMaker "native" find mode within a user's UI (does not require visibility of status bar). 

A crucial part of this workflow is the insertion of search operators. Most search operators are not problematic. You can insert them by means of script without any issues. The problem exists with > or < operators. Filemaker immediately complains about "invalid find criteria". When wrapped in quotation marks, these are inserted into the field without any error messages. The challenge then is (that's what this thread was originally about) to remove the quotes.

Unless there is a better way.... altogether?


PS: use the "Enter Find Mode" button to get started - the rest should be obvious.

Edited by artvault
Link to comment
Share on other sites

This topic is 2957 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

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