Replacing & character
Moderators: chulett, rschirm, roy
Replacing & character
Hi all,
My Job generate xml files from csv files.
As xml file will not recognize '&' char ,I need to repalce it with '&'
Now I am using change Function which is there in Basic Transformer.
But this is causing lot of troubles while running .The processs are getting locked very frequently.
Is there any function in Normal Transformer to replace this '&' character.
Thanks.
My Job generate xml files from csv files.
As xml file will not recognize '&' char ,I need to repalce it with '&'
Now I am using change Function which is there in Basic Transformer.
But this is causing lot of troubles while running .The processs are getting locked very frequently.
Is there any function in Normal Transformer to replace this '&' character.
Thanks.
The Change and Ereplace functions are the same (except when
evaluating an emptyr string).
You might write a normal Server job to read you source file, parse it and write it back out to another sequential file, which your PX job then reads. It will make maintenance and debugging easier and might even make it faster if your XML files are small (due to the overhead involved in starting PX jobs).
evaluating an emptyr string).
You might write a normal Server job to read you source file, parse it and write it back out to another sequential file, which your PX job then reads. It will make maintenance and debugging easier and might even make it faster if your XML files are small (due to the overhead involved in starting PX jobs).
Anna,
no, the CONVERT function is useless in this case since the poster wants to convert one character into a sequence of 4 characters.
CONVERT('&','&',In.Column) will not do any changes at all to the value, It will replace "&" with "&" and the rest of the resulting to-conversion string won't even be used.
no, the CONVERT function is useless in this case since the poster wants to convert one character into a sequence of 4 characters.
CONVERT('&','&',In.Column) will not do any changes at all to the value, It will replace "&" with "&" and the rest of the resulting to-conversion string won't even be used.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The original statement of the problem specified that a BASIC Transformer stage was being used, where both Change() and Ereplace() might legally be used. This is not the problem.
The problem is that something, somewhere, is locking.
Can you please explain exactly what you mean by "the processes are getting locked" and what symptom that you observe leads to this particular diagnosis?
The Change() function can not cause any kind of locking.
However, the interface between a parallel job and a BASIC Transformer stage may - I repeat, may - be the culprit. We need to eliminate all other possibilities before we can be any more certain than that.
The problem is that something, somewhere, is locking.
Can you please explain exactly what you mean by "the processes are getting locked" and what symptom that you observe leads to this particular diagnosis?
The Change() function can not cause any kind of locking.
However, the interface between a parallel job and a BASIC Transformer stage may - I repeat, may - be the culprit. We need to eliminate all other possibilities before we can be any more certain than that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.