Not able to convert unicode character coming in orchestrator queue from uipath

[Sailesh_Tiwari]

I have added arabic invoice data from Abby to orchestrator queue using export script in abbyy.It getting added but instead of arabic it coming in unicode character in orchestrator queue.Now it is very difficult for me to convert unicode character in english .because in orchestrator queue it appears in json format with"/" everywhere…below is the data coming in orchestrator queue

[{"Key":"fc_Predefined:EmailSubject","Value":"Fwd: PFA Arabic"},{"Key":"fc_Predefined:EmailSender","Value":"Satyendra Goswami satyendra.goswami95@gmail.com"},{"Key":"fc_Predefined:EmailAddressee","Value":"trubotimpl@gmail.com"},{"Key":"fc_Predefined:EmailDate","Value":"Thu, 27 Aug 2020 11:00:00 +0530"}]
Fields: [{"Key":"InvoiceNumber","Value":"2201523"},{"Key":"InvoiceDate","Value":"12/7/2020"},{"Key":"PoNumber","Value":"PO3O714"},{"Key":"GLcode","Value":"40101000"},{"Key":"CostCenter","Value":"4100008"},{"Key":"TaxId","Value":"9727713428"},{"Key":"VendorNumber","Value":"3004217"},{"Key":"VendorName","Value":"\u062f\u064a\u0643\u0646\u0632 \u062a\u0627\u064a\u0644\u0648\u0631"},{"Key":"Address","Value":"\u0645\u064a\u062f\u0627\u0646 \u0645\u0643\u062a\u0628 \u0628\u0631\u064a\u062f \u0648\u0627\u062d\u062f\n02109 \u0645\u0627\u062c\u0633\u062a\u064a\u0631 \u0628\u0648\u0633\u0637\u0646 3600 \u062c\u0646\u0627\u062d"},{"Key":"SubTotal","Value":"300750.00"},{"Key":"AmountInWord","Value":".\u062d\u0638 \u0623\u0644\u0641\u0639\u0634\u0631 \u0627\u062b\u0646\u0627 \u062b\u0644\u0627\u062b\u0629"},{"Key":"TransactionTable\\Quantity","Value":"\u0636\u0631\u064a\u0628\u0647"},{"Key":"TransactionTable\\UnitRate","Value":"\u0627\u0644\u0648\u062d\u062f\u0629 \u0633\u0639\u0631"},{"Key":"TransactionTable\\Tax","Value":"\u0643\u0645\u064a\u0647"},{"Key":"TransactionTable\\GrandTotal","Value":"\u0627\u0644\u0623\u0648\u0635\u0627\u0641"},{"Key":"TransactionTable\\Descrition","Value":"\u0645\u062c\u0645\u0648\u0639"},{"Key":"TransactionTable\\Quantity","Value":"4000.00"},{"Key":"TransactionTable\\UnitRate","Value":"30000.00"},{"Key":"TransactionTable\\Tax","Value":"10"},{"Key":"TransactionTable\\GrandTotal","Value":"\u0644\u064a\u0646\u0648\u0641\u0648 \u062a\u0648\u0628 \u0644\u0627\u0628"},{"Key":"TransactionTable\\Descrition","Value":"300000.00"},{"Key":"TransactionTable\\Quantity","Value":"50.00"},{"Key":"TransactionTable\\UnitRate","Value":"150.00"},{"Key":"TransactionTable\\Tax","Value":"5"},{"Key":"TransactionTable\\GrandTotal","Value":"\u0627\u0644\u0641\u0623\u0631"},{"Key":"TransactionTable\\Descrition","Value":"750.00"}]

please request your help as soon as possible.

[ppr (Peter Preuss)]

@Sailesh_Tiwari

System.Text.RegularExpressions.Regex.Unescape(unicodeString)

have a look here, maybe this helps for the cleansing

Bulk import changes encoding of data

@martinN playing / adopting the encoding set would be the first option for checking / adopting the encoding set e.g. notepad++ can help in case of the issue is not get under control, maybe a correction job is helpfully: converting all cols: Removal of Trailing Spaces from Datatable - #11 by ppr unescaping unicode: System.Text.RegularExpressions.Regex.Unescape(unicodeString) Decode_UnicodeString.xaml (4.7 KB)

[Sailesh_Tiwari]

thanks it works for me