How to populate first 2Chars into new field in report

37 Views

Hi All,

I have report requirement like to populate the first 2chars of a characteristic in the report.

Eg: I have ASM code with characteristic values A1200,B2300........now i need to populate only first 2chars like A1,B2...in the new object (name it as Region.)

So finally my report will be

ASM Region Kf1

A1200 A1 100

B2300 B2 200

Thanks in advance.