Hi all , i am processing the invoice from that i extracted the vendor name to enter into an respective site, thing is i need to remove or add special characters on it , as per the pre-defined dumped value so that i can pick the respective vendor to go ahead!
eg . case 1:
from the invoice i got a vendor name like ADC Telecommunications, Inc. but in dumped value(say for an example excel data) am having like ADC Telecommunications Inc in this case i need to remove comma(,)&dot(.) from the value where i extracted!
extracted value from the invoice is Alcoa Inc but i in dumped value(say for an example excel data) am having like Alcoa.,Inc
in this case i want to adddot(.)&comma(,)
so how should i do this!
sometimes i need to add a spl char on it , sometimes i want to remove can anyone share me the work flow to work on this !