I was wondering if there is an easy way of removing/replacing all single quotes in the fields in my Monarch models. They mess up my program when it attempts to interact with SQL.
I realize I can create calculated fields for each field replacing the single quote. What I'll likely do is handle it in the program itself. However, I was just wondering if anyone has an elegant way of solving this issue in Monarch? I would greatly appreciate any information that anyone can provide.[/QUOTE]
You can clean these up with the Monarch String Replacement Program, msrp.exe. This is on the Downloads section of the Datawatch web site. It's automatable, so you can call it using a post process script in DataPump, for example.