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!
case2:
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 !
adding the . or , is not possible i mean we can add but exactly at what position that need to add we canβt so when ever string contains the special characters remove .
for case 1 we can use this expression
if
str_input = ADC Telecommunications, Inc.
the str_output = str_input.Replace(β,β,ββ).Replace(β.β,ββ).ToString
which will delete the . and ,
while for case 2
if str_input = Alcoa Inc
then str_output = Split(str_input," β)(0)+β.,β+Split(str_input,β ")(1)