Escaping quotes in a calculated field

[picnichouse]

Hi,

I need to add a slash to all double quotes in a text field so that when exported, it can be properly interpreted by the program we are sending the flat file to.

So, for example,

this: he said "hello, how are you?"

becomes this: he said "hello, how are you?"

It seems like a pretty simple fix by using the substitute function, but I'm having problems getting the syntax right, i.e. this doesn't seem to work:

Substitute(FieldName;""";"")

Any idea how to do this?

Thanks,

Andrew

[Zero Tolerence]

Substitute(FieldName;""";"")

Substitute(FieldName; """; """)

I think that sright, the point here is, that filemaker needs the escape in front of quotes also.

[picnichouse]

hmm, doesn't seem to work. In fact, it doesn't seem to effect the output at all.

[LaRetta]

Zero's calc works. Is your calc unstored?

[picnichouse]

hmm... no, it isn't being stored... this is my calculation

Substitute(ItemName; """; """)

ItemName = "hello"

and the calculation is "hello" too, instead of "hello"

what else could i be missing?

[LaRetta]

You must specifically specify unstored in Storage Options. Copying your calc and pasting into my definition, it works and produces:

he said "hello, how are you?"

I tested it both in 7.0v3 and 8.0v2.

What version of 7 are you running?

[picnichouse]

8.0v2 advanced...

take a look at the file I've attached.

test.zip

[LaRetta]

Strange. Yep, it's breaking alright.

Well, it said I didn't have the right font so I changed it to Verdana. Then your calc field produced smart quotes. This may be why it's breaking.

[LaRetta]

Yep, you had smart quotes on - see File Options Text tab. It works now. ^)

I NEVER use smart quotes - it messes many things up.

L

[picnichouse]

That did it -- Thanks!