Jump to content

Quotes on imported records


This topic is 7559 days old. Please don't post here. Open a new topic instead.

Recommended Posts

You can get rid of them by using one of the two following methods (you can also script this):

Use the New Find and Replace feature in version 6 (i.e. put your cursor in the offending field, go to the Menu - Edit - Find and Replace, put a " (quotient) in the Find box and nothing in the Replace, and then hit the Replace all).

Since earlier version did *not* have this function, the old fashion way is to use the Replace function (i.e. put your cursor in the offending field, go to the Menu - Records - Replace (Cmd = on a Mac). Select the option Replace by calculated result, in the calculation box, choose the Substitute Function, the calculation should look like this Substitute(yourfield, """, "")

Note One: (") are considered operators by FileMaker, so it takes more than two or three, so you may have to use four """" in the first set, the second set of just two is correct.

Note: replace yourfield with the field that is your offending field.

HTH

Lee

Link to comment
Share on other sites

Hello Dave,

Attached is a sample file that I happened to have created recently for a client. It shows an example of a procedure for applying a scripted application of the 'Replace( )' command to remove quotes from imported data.

Since it uses the Replace command rather than the 'Find and Replace' feature, it will work in versions of FileMaker from 5.0 and up (and could be replicated in .fp3 format if required).

RemovingQuotes.zip

Link to comment
Share on other sites

This topic is 7559 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.