need help with the serial numbers
I am facing this problem of dealing with the embeded spaces in the serial numbers of the meters.
The standard MIGO transaction doesnot allow the use of spaces in the serial number entries. Even if some one puts a space in the field the system totally ignores the space and accepts the serial number without the space.I tried to convince the client for the use of the hyphen instead of the space. The client is ok with it but wants that the system should automatically pick up hyphen instead of the space. Which actually means that the agents will enter the serial number with the space and then then system will pick up serial numbers and replace it with the hyphen all the time.
Can any one suggest me a solution to this problem.
I will definately award points if the right solutions is given.
Thanks all of you in advance.