Hi
In the transformer i'm replacing the New Line with "
" but in the
dataset i'm seeing the output as just "&", is there anyway to get the value as it is
Input
-------
value1( New Line)
value2
present output
-----------------
value&value2
expected output
--------------------
value
value2
i'm using the syntax
Convert(Char(10),"
",lk_orac.line1)
any help is appreciated
FYI- this output is finally going to an XML output stage
thanks
MJ
Stopping transformer from interpreting
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
Stopping transformer from interpreting
Last edited by Maximus_Jack on Wed Apr 09, 2014 9:32 pm, edited 1 time in total.
For that you'd need the parallel version of EReplace, posted here as pxEReplace by (most recently) the user PhilHibbs. However, I seem to recall it being... leaky.
There's an official IBM version but from what I recall, you'd have to upgrade into the 9.x world to get it.
There's an official IBM version but from what I recall, you'd have to upgrade into the 9.x world to get it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers