I have a pressing deadline but I have no PERL skill and need this attribute trimmed - Lot/Plan(separators).
an example of an attribute:
1/AB842550
I am duplicating the column Lot/Plan(separators) into two columns - Lot and Plan
All characters to the left of this symbol "/" are the Lot numbers required in the Lot column
and
All the characters to the right of this symbol "/" are the Plan numbers required in the Plan column.
Any and all help would be greatly appreciated.
Thanks
peter