Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sun, Mar 4 2012 7:15 AM	Permanent Link
Dennis Allsopp	I have a recieved a set of data and the client requires that all commas and colons contained in one of the fields be replaced by a semicolon. I have tried the escape clause but no luck. Any suggestions?
Sun, Mar 4 2012 8:39 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Dennis I've just tried update banda SET _boxname = REPLACE(',' with ';' in REPLACE(':' with ';' in _boxname)) where _boxname like '%,%' or _boxname like '%:%' in 4.25b5 and its fine Roy Lambert
Sun, Mar 4 2012 7:40 PM	Permanent Link
Dennis Allsopp	Thanks Roy. DBSYS runs but is not visible on my system (Win 7 x64) and I had been trying using the last released version of dbiManager. Was able to try again using DBSYS when I got into the office and all works as it should. Dennis Roy Lambert wrote: Dennis I've just tried update banda SET _boxname = REPLACE(',' with ';' in REPLACE(':' with ';' in _boxname)) where _boxname like '%,%' or _boxname like '%:%' in 4.25b5 and its fine Roy Lambert