Solved Identifying the Alpha, Numeric and both by reading from an excel sheet

[Rakesh Reddy]

How to Identify the Alpha, Numeric and both by reading from an excel sheet and paste it to the second cell in Automation Anywhere?

 

[krrish9199]

1.Get cell value from Excel
2. Use "Find" command Under "String Operation".Give Regular expression for Alpha or Numeric or what ever format you need in "Find String" and Source in "Source String" field.
3.If the Output Value is >0,Specified pattern in present in Source String,based on requirements you can copy that in second cell using set cell command.(Make sure you select Regular Expression Check box in Find Command)

 

[Rakesh Reddy]

1.Get cell value from Excel
2. Use "Find" command Under "String Operation".Give Regular expression for Alpha or Numeric or what ever format you need in "Find String" and Source in "Source String" field.
3.If the Output Value is >0,Specified pattern in present in Source String,based on requirements you can copy that in second cell using set cell command.(Make sure you select Regular Expression Check box in Find Command)

Thanks you so much, I got it!