Quoting html code in FileMaker (and getting around the special characters)

[apathyisafad]

Maybe this is an easy one but I'm trying my darndest to pull in some source code from a website into my FileMaker database. I think I've found a way to get just the code I need but I'm running into a quoting issue. I want search the source code for this particular text:

As you can imagine, Quote(

) just gives me a bunch of errors. I'm not exactly a pro at using the Quote function, and if there's a way around it that would be fine too. But I'm pulling my hair out. I need to find a way to use that code as my search criteria in a Position function, such as

Position(getlayoutobjectattribute("HDSupplyViewer"; "content"); "

"; 1; 1)

Obviously the above example does not work. Can anyone help me out?

Thanks in advance.

[comment]

Try:

Position ( text ; "" ; 1 ; 1 )

[apathyisafad]

Thank you. It worked like a charm. So I guess in that example it is only the " that need to be escaped. I was escaping everything that wasn't alphanumeric. I am a bit of an escapist I suppose.

[comment]

You cannot use Quote() to escape literal text; Quote ( "text that needs escaping" ) will result in error because the text literal cannot be resolved. You can, however, put the text in a field and use Quote ( field ).

Another option is:

Position ( Substitute ( text ; """ ; "'" ) ; "" ; 1 ; 1 )