Dear All I have values from excel sheet to be read and inserted to an application
the values I have are
AED1,579.00
$210,890.00
EGP1,579.00
I need to make regular expression to convert all the above to be
1,579.00
210,890.00
1,579.00
Dear All I have values from excel sheet to be read and inserted to an application
the values I have are
AED1,579.00
$210,890.00
EGP1,579.00
I need to make regular expression to convert all the above to be
1,579.00
210,890.00
1,579.00
sure
if the input is stored in a variable before taking it to a application named str_input then
use this expression
system.Text.RegularExpressions.Regex.Replace(str_input,“(\d).*”,“”)
Cheers @Dina.abdelhakam
Dear thanks for your help
but this returned the AED and EGP not the number
fine
try with this pls type mistake instead of Match typed as Replace
system.Text.RegularExpressions.Regex.Match(str_input,“(\d).*”).ToString
it worked buddy @Dina.abdelhakam
Cheers @Dina.abdelhakam
Hi @Dina.abdelhakam
Use System.text.regularexpression.regex.match("InputString","\d+").Tostring
and store this in String variable.
Dear Could you please tell me how to remove the qomma → “,”
but the output mentioned has comma
fine
to remove that as well same expression but with a replace at last
system.Text.RegularExpressions.Regex.Match(str_input,“(\d).*”).ToString.Replace(“,”,“”)
Cheers @Dina.abdelhakam
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.