Replacing character " by _

Moderator: LordOfTheRings

User avatar
daniel
Site Admin
Posts: 217
Joined: Tue Jan 09, 2007 9:54 pm
Contact:

Replacing character " by _

Postby daniel » Wed Feb 20, 2008 3:06 pm

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

User avatar
Ega
Posts: 24
Joined: Sun Feb 10, 2008 8:36 am

Postby Ega » Wed Feb 20, 2008 3:50 pm

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.
8)

Darco
Site Admin
Posts: 80
Joined: Tue Jan 09, 2007 10:03 pm

Postby Darco » Wed Feb 20, 2008 6:57 pm

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.


:arrow:


Return to “Service Desk”

Who is online

Users browsing this forum: No registered users and 1 guest