Page 1 of 1
replace | with |"
Posted: Wed Nov 02, 2011 12:01 am
by kiran0435
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.
Re: replace | with |"
Posted: Wed Nov 02, 2011 12:32 am
by SURA
Create a stage variable and give |" as a value for that. Then use that in the function
DS User
Posted: Wed Nov 02, 2011 2:40 am
by kiran0435
No Sura... this is not working...
Posted: Wed Nov 02, 2011 3:24 am
by BI-RMA
This is a job for PXEReplace().
Take a look at this post:
viewtopic.php?t=106358&highlight=PXEReplace
Posted: Wed Nov 02, 2011 6:16 am
by chulett
Convert replaces a single character with another single charater. As noted, you need the parallel version of the Server EReplace function.
Posted: Wed Nov 02, 2011 10:45 am
by mobashshar
Or..
You can use Before Job Subroutine and use SED or AWK to replace the | with |"
Posted: Wed Nov 02, 2011 1:59 pm
by SURA
In the stage variable copy and paste this "|'''" and use that SV, you will get that result.
DS User