In Message-Mapping I map item number to item no.
The source item number format are random, sometime in char, i.e., ABC123, ABC-23-A... sometime in digit, i.e. 123, 425...
The target system is sap and accepts just C(18) with captial characters.
I think, i need a UDF.
1. tell whether source field is digit or characters.
2. if digit then FormatNum into 0000000000000000
3. if characters then toUpperCase.
Is it correct? how to make it?