Find/Replace

[osiris612mb]

This is my script::

Go to Record/Request/page [first]

Loop

Go to Field[select/Perform; Time::Description]

Perform Find/Replace[ """; "'' ;Replace all]

Goto Record/request/page [next; exit after last]

end Loop

What it is supposed to do is go to the description field and find all quotation marks and make them a single apostrophe. Because when exporting we can't have quotation marks in the comma-seperated file.

So instead of seeing Last night I read the book, "The Perfect Storm".

it would read, Last night I read the book, 'The Perfect Storm'.

BUT it doesn't work!!!

Can a field be changed like this or should we just have a second field that uses the Substitute[] and export that field instead???

Thanks in advance.

[RalphL]

Should the script step read:

Perform Find/Replace[ """; "''' ;Replace all]

[Rob 7 Collins]

If [ IsEmpty ( Get ( ScriptParameter ) ) ]

  Go to Record/Request [ first ]

  Perform Script [ "this_script" ; Parameter: Substitute ( Time::Description ; """ ; "'" ) ]

Else

  Loop

    Set Field [ Time::Description ; Get ( ScriptParameter ) ]

    Commit Record/Request

    Go to Record/Request [ next ; Exit After Last ]

  End Loop

End If

*edit: i forgot the commit record/request : likely what your script is missing too.

[osiris612mb]

Ralph: That didn't seem to work either. In a calulation it does but not within a find/replace.

Rob: That worked althought I left out the If[]

Thanks for the help!

[Rob 7 Collins]

Rob: That worked althought I left out the If[]

I'm getting so used to ScriptParameters that right now I don't touch anything without them.

Its very useful in cases where you want to do the same thing, but drop to Find mode before setting fields.