DSXchange

Hi All,

I have a column that contains data such as

notes=dsadssa, sdsaddsa, dsaddfdfd, fdfdfdsfdsfds

whereever there is comma(followed by single space) I have to write a semi colon.

expected output:

notes=dsadssa;sdsaddsa;dsaddfdfd;fdfdfdsfdsfds

can someone please let me know how can I do this datastage

Thanks
pavan

If always you will get the single space after comma?

Trim (col,' ',':')

Or

You can use convert function too.

DS User

Search DSXchange for the pxEreplace function, which will handle your requirement even if there are spaces and commas in your data.

Otherwise do what SURA was attempting to suggest - Trim() to get rid of the spaces and Convert() to change the commas to semi-colons.

I Apologize, actualy it is other way around..

where ever there are semi-colons, I have to replace them with , (followed by single space)

notes=dsadssa;sdsaddsa;dsaddfdfd;fdfdfdsfdsfds

desired output:

notes=dsadssa, sdsaddsa, dsaddfdfd, fdfdfdsfdsfds

how can I do it using convert function

Thanks

Try this, but i am not sure whether you will get any space after the comma.

Try this and let us know!

Convert() replaces single character by another single charcter.
I dont think it will work in your case.
Yu can search PXEReplace() or use sed or awk in before/after job subroutine for this purpose.

Thanks

Convert() replaces single character by another single charcter.

I have seen this posted on DSXChange before, but I have not found it to be true. I ran a quick test, using the "Convert" solution and found it worked per the o/p's requirement. Is it possible this is how Convert worked in earlier versions? I am using 8.1.

Convert() will not work here. As Pandeesh mentioned, it replaces single characters with other single characters--";" with ",". It will not replace a single character with a string of characters--";" with ", ".

As mentioned already, pxEreplace() for parallel is available for installation and will serve the purpose...also you can write your own parallel routine if you wish, use a Basic Transformer instead or even an external filter (awk or sed for example).

Regards,

jwiles wrote:use a Basic Transformer instead or even an external filter (awk or sed for example).

Regards,

James,

why BASIC transformer?

BASIC Transformer has in-built Ereplace() function.

Thanks Ray!! I forgot!!