replacing a string

rickrambo · Post by **rickrambo** » Wed Sep 13, 2006 4:54 pm

Hi,
I have an input string 'fantacy', I would like to covert this string to 'faxyzcy' in the TRANSFORMER Stage. That is 'nta' in the input string should be replaced by 'xyz' in the output. Only the occurrance of 'nta' need to be replaced but not the individual chars...so CONVERT function won't work.
What function I will use to achieve this.

Using 7.5.1 (PX) on UNIX.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 5:34 pm

Give us your thoughts.

In a server job you would have looked at Ereplace() but this is not available in parallel jobs. Clearly an approach that uses substrings and concatenation, plus If..Then..Else, seems to be indicated.

Can you guarantee that the string-to-be-replaced occurs not more than once in the field? If not, you're probably up for a different approach - perhaps an External Filter stage using (perhaps) awk.

kumar_s · Post by **kumar_s** » Wed Sep 13, 2006 7:19 pm

Or Index() in transformer to find the and replace with the given string. If not sure about the number of occurance, you can make use of Dcount().

rickrambo · Post by **rickrambo** » Mon Sep 25, 2006 12:49 am

anybody has thoughts on this. Little more info, the part of the string I am trying to replace 'nta' can appear any where in the input string 'fantacy'.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 25, 2006 1:10 am

Awaiting YOUR answer to my question that will guide my answer.

c_cri · Post by **c_cri** » Tue Sep 26, 2006 5:33 am

Hi, try the Ereplace function in the transformer:

Example

Ereplace('abcd.doc','.doc','.txt') returns abcd.txt

Hope this helps

Chris

ray.wurlod · Post by **ray.wurlod** » Tue Sep 26, 2006 6:34 am

Ereplace() is not available in the parallel Transformer stage.

samsuf2002 · Post by **samsuf2002** » Tue Sep 26, 2006 8:02 am

i am not sure what is the job scenario but u can develop a small server job and use Ereplace() out put to a file and use that file as input to ur parallel job..............

kumar_s · Post by **kumar_s** » Tue Sep 26, 2006 8:13 am

Not a job for each transformation.

ArndW · Post by **ArndW** » Tue Sep 26, 2006 8:18 am

StageVar "AntLoc" set to "INDEX(In.Column,'nta',1)"
StageVar "NewString" set to "IF AntLoc=0 THEN In.Column ELSE In.Column[1,AntLoc-1]:'xyz':In.Column[AntLoc+2,9999]"

this will replace the first instance of "ant" with "xyz" in the string in a PX job.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 26, 2006 3:05 pm

Still awaiting an answer to "Can you guarantee that the string-to-be-replaced occurs not more than once in the field?". Arnd's answer is sufficient if the answer is "yes", but not if the answer is "no".

clshore · Post by **clshore** » Tue Sep 26, 2006 4:40 pm

Since it's EE, why not a function or buildop based on C regcmp and regex?
Build it generically enough for re-use, and voila, you have a new arrow in your quiver.

Carter

ray.wurlod · Post by **ray.wurlod** » Tue Sep 26, 2006 7:34 pm

Good point, but original question required "in Transformer stage".

clshore · Post by **clshore** » Thu Sep 28, 2006 7:37 am

True for the buildop, but don't Custom Functions become available to choose via the expression editor menus in Parallel Transformer?
ISTR adding one (it's been a year or so back).

Carter

ray.wurlod · Post by **ray.wurlod** » Thu Sep 28, 2006 3:02 pm

Good point - though a parallel Routine is not a BuildOp (which is a stage).

DSXchange

replacing a string

replacing a string

Re: replacing a string