Posted: Mon Aug 17, 2009 8:53 am
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
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