How to read only number in cell excel

Hi everyone,

I need to read a value in excel and i know i have to use excel application scope and read cell activities but i would read only a number, for example i have a cell —> “23May” and i would read only “23”. How can i do that?

thanks in advance

Input=“23May”
Output=Input.substring(0,2).Tostring
This Example will help you.If you still facing issues.Let me know.
replace.xaml (5.2 KB)

@salvatore.quimi You are at the right path. After Read Cell just use assign activity System.Text.RegularExpressions.Regex.Match(Read Cell output,"\d").Value.Trim

@Reddy_Paluri, thanks your initial expression was enough for my goal

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.