find / replace script - help request

[pryjda]

I could really use some help trying to complete a script. Manh thanks to all who may help.

I am trying to write a script tha honestly i'm not sure how to start.

What i would like to do is first of all is copy the contents of one field (large blocks of text)into another field.

After duplicating the infomation i would like to do a find and replace on all bullet points "•" and replace them with "+" then find all the hard returns "¶" adn relace them with a comma ",".

If there was any way do this with a calculated field, tht would be even better. That way i would not have to run the script over and over. but how whould i know.

That is why i ask the experts.

Thank you everyone who might want to help.

I'm sure it's a lot easier than i think.

[Razumovsky]

substitute(yourtext; "•"; "+")

Works in calculations in both script steps (look up the Set Field step - much better than copy/paste) and calculation fields. You could keep all yourtext in one field, and just write a calc field that will display the new result.

-Raz

[pryjda]

Thank you Raz!,

I see where this is going. and it sems to be working for me too. But how can i modify the code to replace both sets of charicter at the same time. eithe rmy calculatin will not work or i am doubling everything.

I appreciate your help

[John Mark Osborne]

Substitute(MYTABLE::myfield; ["•"; "+"]; ["¶"; ","])

[pryjda]

Raz, Mark and forum gurus.

Thank you all for your help.

It WAS easier than i thought. Someday i'll get this scripting down.

THANKS AGAIN!

[Lee Smith]

Hi pryjda, and Welcome to the Forum.

The Substitute Function is a Text Function, and can be use it in a calculation field also.

It might be helpful to you to see the calculation in the format used in versions prior to 7, in order to see the logic of the one presented by John Mark.

Substitute(Substitute( Text ;

"•"; "+");

"¶"; ",")

This was called ganging the substitute function, and can still be use in the newer versions, but I don't know why you would want to.

HTH

Lee