Change value to "CAC \(E\) WorkFlow" from "CAC (E) WorkFlow"

[Jyobtech]

Hi Experts,
Can you any one please help me to get the value "CAC \(E\) WorkFlow
" from the value "CAC (E) WorkFlow".
how to write pogram to append "\" for the value "CAC (E) WorkFlow"

Out put value should be"CAC \(E\) WorkFlow"

[supputuri]

Hi Jyo,

use the simple method Replace, below is the snippet.

Code:

strReplaceOpenParnth = Replace("CAC (E) WorKFlow","(","\(")
strUpdatedString = Replace(strReplaceOpenParnth,")","\)")
msgbox strUpdatedString

Let me know if you need any further help.

[basanth27]

Wouldnt this be a optimized approach?

Code:

oModStrVal = Replace(Replace("CAC (E) WorKFlow","(","\("),")","\)")
msgbox oModStrVal