XML Input Stage : Not able to read £ sign

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
krishna81
Premium Member
Premium Member
Posts: 78
Joined: Tue May 16, 2006 8:01 am
Location: USA

Post by krishna81 »

you have to ridoff special characters prior to read XML file by creating Before/After subroutine.


Ans = ''
if len(ARG1) > 0 then

for i = 1 to len(ARG1)
if ( 033 <= (seq(substrings(ARG1, i, 1)))) & ((seq(substrings(ARG1,i,1))) <= 125) then
Ans = Ans:(substrings(ARG1,i,1))
end else
Ans = Ans:' '
end
next i
end
Datastage User
Post Reply