Skip to Content
0
Former Member
Jun 15, 2011 at 09:41 AM

How to handle random item number format?

16 Views

Hi,

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?

thanks

Rene