DSXchange

Hi,

We have requirement that in one of the field we will get double quotes we need to convert each double quote into two double quotes.

Ex:
Input value: raj"esh"ran"ja

Output should be: raj""esh""ran""ja

Is there any possibility to convert single double quote into two double quotes for n number of occurances please.

Thanks,
skp.

Did you try using the EReplace function?

Also if you are writing to a text file, then you could use a Sequential File stage in a Server job or Server Shared Container within a Parallel job. It should do the double quote handling you described.

Hi qt_ky,

Thanks for your quick responce. I am not able to see option Ereplace in transformer and also how sequential file can convert single double quote into two double quotes please explain me.

Thanks,
skp

EReplace was added to the Parallel world in the 9.1 release, I do believe. So you could use a Server job (is it doing anything that requires PX?) or perhaps use a BASIC Transformer. Or you could find the C++ version called pxEReplace that users put together and posted here, give that one a shot although from what I recall reading it may have some... issues.

Or you could use a loop in a Transformer stage, WHILE Index(InLink.TheField, '"', 1) > 0
Within the loop replace the double quote using substring techniques.
Perhaps make use of the LastRecordInGroup() function to constrain the output.

Refer to my solution :

viewtopic.php?t=152746

you can try my solution explained in the post -
viewtopic.php?t=152903