Uipath read from excel

[TyraS (Tyra)]

Bot read from excel with the following symbols.
≤
≤
≥
But after read, bot only returns = for all of them. how to make sure bot includes the greater or equal and lesser than or equal symbols?

[pravin_calvin (pravin kumar)]

Hi @TyraS

Use the Read Range properties and Check the Option Preserved Format!

Regards

[TyraS (Tyra)]

Hi , the preservedFormat is already checked. Oh I think its when inserting into the database, it becomes =

[pravin_calvin (pravin kumar)]

Hi @TyraS

Which database are you Using to insert the value?

Regards

[TyraS (Tyra)]

Hi, sql server

[Priyanka_Ramesh]

Hi @TyraS ,

This symbols are unicode , so Try with the following

“insert into temp1 values(N’”+row(“a1”).toString+“')”

[Lakshay_Verma]

N indicates Unicode constant string in MSSQL