I used translate(trim(BillingCity),’àáâãäåāăąÀÁÂÃÄÅĀĂĄèéêëēĕėęěÈÉÊËĒĔĖĘĚìíîïìĩīĭÌÍÎÏÌĨĪĬòóôõöøōŏőÒÓÔÕÖØŌŎŐùúûüũūŭůÙÚÛÜŨŪŬŮçćĉċčÇĆĈĊČñńņňÑŃŅŇ’,
‘aaaaaaaaaAAAAAAAAAeeeeeeeeeEEEEEEEEEiiiiiiiiiiiiiiiiiooooooooOOOOOOOOOuuuuuuuuUUUUUUUUcccccCCCCCnnnnNNNN’)
there is a data which contain ‘ņ’ it should replace with ‘n’ but the output was ‘?’. Why it happens? and Any better solution for this issue?
I tried regex_replace and replace but this get increases the line of code but also same result
20R212 – DINESH KUMAR P is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.