replace | with |"

kiran0435 · Post by **kiran0435** » Wed Nov 02, 2011 12:01 am

Hi,

My requirement is to replace | with |"

i tried with convert('|','|"', inputcolumn). But this doesn't solve the requirement.

Please suggest me how to solve this. My output is one shared container for which i have to send the data in this format.

SURA · Post by **SURA** » Wed Nov 02, 2011 12:32 am

Create a stage variable and give |" as a value for that. Then use that in the function

DS User

kiran0435 · Post by **kiran0435** » Wed Nov 02, 2011 2:40 am

No Sura... this is not working...

BI-RMA · Post by **BI-RMA** » Wed Nov 02, 2011 3:24 am

This is a job for PXEReplace().

Take a look at this post:

viewtopic.php?t=106358&highlight=PXEReplace

chulett · Post by **chulett** » Wed Nov 02, 2011 6:16 am

Convert replaces a single character with another single charater. As noted, you need the parallel version of the Server EReplace function.

mobashshar · Post by **mobashshar** » Wed Nov 02, 2011 10:45 am

Or..
You can use Before Job Subroutine and use SED or AWK to replace the | with |"

SURA · Post by **SURA** » Wed Nov 02, 2011 1:59 pm

In the stage variable copy and paste this "|'''" and use that SV, you will get that result.

DS User

DSXchange

replace | with |"

replace | with |"

Re: replace | with |"