Removing quotation marks

[Chalkster]

I am trying to find a way to check if a field has a quotation mark either as first and/or last character

I cant seem to find a way of asking because FMP sees the quotation mark as a special character when writing a calculation

Is there any way of doing this ... to check if a quotation mark is in a specific position

I dont have much choice in this since the quotations are in imported files from another application and I need to identify and remove them

[Lee Smith]

Maybe this is what you want.

Create a Calculation using the Pattern Count.

PatternCount ( Insert quotes ; """ )

HTH

Lee

:cool:

[LaRetta]

... has a quotation mark either as first and/or last character ... to check if a quotation mark is in a specific position ... need to identify and remove them.

Maybe this, Chalkster?

Let(

[

start = If ( Left( text ; 1 ) = """ ; 2 ; 1 ) ;

end = If ( Right ( text ; 1 ) = """ ; 0; 1 )

]

; Middle ( text ; start ; Length ( text ) - start + end )

)

Note that if your field starts or ends with double quotes, it will only remove the first on either side. I believe this calc will hold true in all text combinations. Since it sounds like a one-time situation, you can place your cursor in this text field and Records > Replace Field Contents > with this calculation (when not multi-user). BACK UP first. In fact when testing results, I sometimes create the calculation and just take a look before applying it.

LaRetta