Newbies zackfc Posted October 6, 2000 Newbies Posted October 6, 2000 I'm trying to eliminate the quotes " (double) in a text field by writing a formula that searches for them and does a substitute. Here's the problem: Substitute(short_description, "*"*", "") Obviously that won't work. Any clues? TIA!! -zack
Chuck Posted October 6, 2000 Posted October 6, 2000 What if you created a global text field an placed a double-quote in it in browse mode. Say it's called gDouble_Quote. Then the substitution would be Substitute(short_description, gDouble_Quote, "") Chuck
Kurt Knippel Posted October 7, 2000 Posted October 7, 2000 quote: Originally posted by zackfc: I'm trying to eliminate the quotes " (double) in a text field by writing a formula that searches for them and does a substitute. Here's the problem: Substitute(short_description, "*"*", "") HMM, unless anyone knows how to insert a " into a formula without FMP thinking it is the closing delimiter, I am not sure this can be done. This is one of those problems like trying to find a way to use reserved words in a programming language. You could try using a field reference instead. Put the " into a global text field, then structure your substitute with that field. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-=
Newbies zackfc Posted October 9, 2000 Author Newbies Posted October 9, 2000 Hey thanks! . . . it worked . . . mostly . . . It removed the first pair of quotes, but if the field contained more than 2, the extras remain: Example: 8 x 8
Recommended Posts
This topic is 8811 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 accountSign in
Already have an account? Sign in here.
Sign In Now