DSXchange

Hi,
I've a requirement where i need to convert Semicolon to '**' value within braces present in a column. I might also have Semicolon which is not included within braces and it should be retained the same. The number of Semicolons within braces are dynamic.

For Ex:

London University; Harvard University(1947; Masters; Distinction); Stanford University(1948, Masters; Distinction); Cambridge University(1949; Graduation, First class)

Which needs to be transformed as

London University; Harvard University(1947** Masters** Distinction); Stanford University(1948, Masters** Distinction); Cambridge University(1949** Graduation, First class)


Thanks in Advance.

Hi balu536,

have a look at this post:
viewtopic.php?t=106358&postdays=0&posto ... e&start=30

pxEreplace is what You are looking for.

You may have to refine it to replace only occurences of substr within brackets.