Hi Folks - Having a bit of trouble !

I have the following script which works perfectly to remove comma's and full stops from a text field which I need to export:-

Left(Substitute(Substitute(Item name, ",", ""), ".", "") & spaces,100)

You will also notice that I'm setting the exported .mer file to a fixed length of 100 characters !

Thats all fine - works 100 %

The problem is that some of these text field records have entries of " dipicting inches - e.g. 1 1/2" pipe .......... If I try to substitute " with a space it simply won't allow it !

I have no idea how to get round this but there is bound to be a way..... Hopefully !

Look forward to hearing any suggestions....Thanks in advance folks !

Dermot

You need to use four double quotes to symbolize one double quote.

Left( Substitute( Substitute( Substitute( Item name, ",", "" ), ".", "" ), """", " " ) & spaces, 100 )

Thanks man !

That works great !

I wouldn't have got that in a million years !

You wouldn't believe how much time you've just saved me....Thanks again !

Dermot

Hi Dermot,

I posted an explanation by Jimmy Jones (FileMaker Inc.) on this subject that might be of help to you in trying to figure out why your substitute isn't working. Adding or removing quotes takes a little experimenting some times.

Click here to go to link.

HTH

Lee

Geeze, while I was off looking up the old posts, JT beat me to the punch again.

Cheers Anyway Lee,

Nice to see the explanation of why mine wasn't working !

Dermot