Usage of Convert function

josemathew · Post by **josemathew** » Fri May 16, 2008 2:34 am

Hi All,
When we used the Convert function, the job gives complation error. Within the Convert function, we gave all the alphabets so that all the alphabets are replaced by blank space.That is :
Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmno
pqrstuvwxyz","", ToXfmCaseStudy.CHAR_CD)

I think there is a limitation in the length for the list string.

Please give your thoughts on this

Regards
Jose

ArndW · Post by **ArndW** » Fri May 16, 2008 2:52 am

There is no limit to string constant lengths close to what you have. If you cut-and-pasted the derivation then I would guess that your "ToXfmCaseStudy.CHAR_CD" is invalid. What is your compile time error?

josemathew · Post by **josemathew** » Fri May 16, 2008 3:09 am

The input string is valid( string is A123-6A). From this i need to get only numeric values,like 1236. For this we gave all the characters in the list part of Convert function. There we get the complie error: "Error Compliling Transformer and Transformer name".
In More details it is given: ##I TUTL 000031 03:58:52(001) <main_program> The open files limit is 2048; raising to 4096."

Pls explain

Thnks
JM

ArndW · Post by **ArndW** » Fri May 16, 2008 3:31 am

The open files warning can be ignored. Try changing your input derivation from a column value to the string "A123-6A". Do you still get a compiler error? Is the line-break in your derivation or was it just the display and cut-and-paste?

Leopold7933 · Post by **Leopold7933** » Fri May 16, 2008 3:34 am

try this
X = Oconv("John Smith 1-234", "MCN") X = "1234"

josemathew · Post by **josemathew** » Fri May 16, 2008 5:07 am

This is in Parallel edition and so we cant use the IConv/OConv functions here

JM

josemathew · Post by **josemathew** » Fri May 16, 2008 5:10 am

Hi ArndW,

I think the problem was with the line break in the derivation and its working fine now.

Thanks a million for the advice

Jm