Replacing character " by _

[daniel]

Hello,

I've create a report which takes several fields into an excel sheet.
Recently have I added summary. This works well except for call in which into the summary the double quote (") are used.

Is there a way inside SQL to quickly to change this.

D

[Ega]

I do this as follow:

- Open 'SQL Query Analyser'
- Goto the correct database (usally mdb)
- Enter the following query:

update call_req
set summary = replace(summary,'"','_')
where summary like '%"%'

- Execute it with pressing F5
- As you will notice everything is ok into the database by Service desk is still responding like before. Therefor restart the 'Unicenter Service Desk' services.

[Darco]

Should be possible by pdm_extract and pdm_load.
But then of course you need to use something like wordpad to change the character into a correct one.

Perhaps the best way of doing. Involve SQL to do the job.