LEADING SPACES(GRAPHICAL MAPPING)

[Former Member]

hi all,

i hav an reqirement such that" IF THE BATCH CODE HAS AN NUMBER 1234567 OR 4455667, THEN THE EMP CODE(TARGET) IS COPIED FROM EMP NUM(SOURCE) WITH LEADING ZERO'S,ELSE THE EMP CODE(TARGET) IS COPIED FROM EMP NUM(SOURCE) LEFT ALLIGNED WITH TRAILING SPACES.

am trying to do this using graphical mapping , r there any standard functions or do i need to use UDF'S,if so please send me the UDF code...the requirement is very urgent.

thx in advance

regards,

keerthi

[Former Member · Accepted solution]

Standard graphical tools should be suffiecient. U can concatenate zeros in begining or end using concatenate wid ur Emp Num field with IFELSE in condition based on value in Batch num as mentioned by you.

Regards

Sushil

[Former Member]

Hi,

You can use standard functions.

1. Use if else function.

2. If the number is 1234567 or 4455667 concatenate the source with zeros and copy to target.

3. if the number is other num then above use Function MULTIPY to source and copy to target.

Regards,

S.RamNarender

[Former Member]

thankz a lot friends

[Former Member]

Hi keerthi

There is a simple solution for this.... try the arithmetic standard function 'mul' and multiply the numeric value with leading zeroes by 1.

Vaibhav

[Former Member]

What is your source and target??