Convert Single char to multiple chars

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mrvsr
Premium Member
Premium Member
Posts: 40
Joined: Fri Aug 03, 2007 8:33 am

Convert Single char to multiple chars

Post by mrvsr »

Hi

Please help me in handling this conversion I would like to convert single char to 3 or 4 character in a string.
Ex: if I have string like below
'test convertion from and symbol to may&be or & and percentage to may%be or % '

That Should be converted to
'test convertion from and symbol to may'&and'be or '&and' and percentage to may'%pct'be or '%pct' '.

I have already tried with basic transformer but its giving some problems while executing. Please let me know how to achieve this using combination of functions or is there any function or routine available in DS8.0
Thanks
MRVSR
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The BASIC function "EREPLACE()" will do this, but it does not exist in PX. What problems do you have with the BASIC transform stage at V8 - I have seen that it works quite well and no longer shows sporadic comms issues as it has in the past.
mrvsr
Premium Member
Premium Member
Posts: 40
Joined: Fri Aug 03, 2007 8:33 am

Post by mrvsr »

ArndW wrote:The BASIC function "EREPLACE()" will do this, but it does not exist in PX. What problems do you have with the BASIC transform stage at V8 - I have seen that it works quite well and no longer shows sporadic comms issues as it has in the past.
I have tried Ereplace function its working fine. But we are running this job in online mode. The job has five transformers and one basic transformer.
will execute continuously. 2 sequence file output stage with overwrite.
after 2 or 3 iterations Basic tranformer not initiating.
If I run individually any no of times its running properly
but in loop with same input its not initializing in the second or third iteration.
Errors:

BASIC_Tfm_Formated.Ins_Jn_formatedDerived-Output) - No such file or directory
The runLocally() of the operator failed.
BASIC_Tfm_Formated,1: Operator terminated abnormally: runLocally did not return APT_StatusOk
BASIC_Tfm_Formated.Ins_Jn_formatedDerived-Output) - No such file or directory
The runLocally() of the operator failed.
APT_PMsectionLeader(1, node1), player 17 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 16 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 18 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 19 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 20 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 21 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 22 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 23 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 19 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 20 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 21 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 22 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 25 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 23 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 24 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 25 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 36 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 37 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 38 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 39 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 40 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 41 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 42 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 43 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 44 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 45 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 46 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 47 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 48 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 49 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 50 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 51 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 52 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 53 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 54 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 55 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 56 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 57 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 58 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 59 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 60 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 61 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 62 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 63 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 64 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 65 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 66 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 67 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 68 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 69 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 70 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 71 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 72 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 73 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 74 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 75 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 76 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 77 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 78 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 79 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 80 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 81 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 82 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 83 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 84 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 85 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 86 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 87 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 88 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 89 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 90 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 91 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 92 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 93 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 94 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 95 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 96 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 97 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 98 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 99 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 100 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 101 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 102 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 103 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 104 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 105 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 106 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 107 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 108 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 109 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 110 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 111 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 112 - Unexpected exit status 1.
APT_PMsectionLeader(2, node2), player 114 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 36 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 37 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 38 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 39 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 40 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 41 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 42 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 43 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 44 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 45 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 46 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 47 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 48 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 49 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 50 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 51 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 52 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 53 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 54 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 55 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 56 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 57 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 58 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 59 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 60 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 61 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 62 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 63 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 64 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 65 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 66 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 67 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 68 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 69 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 70 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 71 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 72 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 73 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 74 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 75 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 76 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 77 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 78 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 79 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 80 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 81 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 82 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 83 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 84 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 85 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 86 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 87 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 88 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 89 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 90 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 91 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 92 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 93 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 94 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 95 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 96 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 97 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 98 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 99 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 100 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 101 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 102 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 103 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 104 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 105 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 106 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 107 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 108 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 109 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 110 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 111 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 112 - Unexpected exit status 1.
APT_PMsectionLeader(1, node1), player 115 - Unexpected exit status 1.

So I dont want to use basic transformer since its online job and dont want to use more transformers So could you tell me how to achive this using
normal transformer functions.
Thanks
MRVSR
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

You cannot do this simply in a PX transform stage. You can write a BuildOP to do this, or perhaps use a UNIX program such as "sed" to do the conversion for you.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is a PX version of Ereplace() which a Search of the forum should find for you.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Ray, I used the search system but couldn't find a reference to a PX "ereplace" type function amongst the threads returned.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This is the one I had in mind.

DSGuru2B still owes the promised FAQ.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
krisna
Participant
Posts: 77
Joined: Tue Apr 08, 2008 11:33 pm

Post by krisna »

Ereplace() function is working fine, but didn't find similar function in PX.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Ray - thanks; after I saw the post I realized that I snarfed a copy when he posted it. I thought you were referring to a built-in EReplace() call in PX.

We really should get a DSXchange toolbox put together.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

VERY soon now the new version of DSXchange will be announced/launched.

They are just getting the server hosting organized.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply