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

Substitute(FieldName;""";"")

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

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

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

Zero's calc works. Is your calc unstored?

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?

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?

8.0v2 advanced...

take a look at the file I've attached.

test.zip

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.

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

That did it -- Thanks!