How to find whether string contains any number in it or not

[sshitol (sush)]

Hi,

I want to find whether string contain number or not.

eg…“Batch2” just check whether this contains any number in it or not

[Anil_G (Anil Gorthi)]

@sshitol

You can use this

System.Text.RegularExpressions.Regex.IsMatch("YourString","\d")

This would give true if the given string contains number else false

Cheers

[Yoichi]

Hi,

FYI, another approach

yourString.Any(Function(c) Char.IsDigit(c))

Regards,

[sshitol (sush)]

@Yoichi and @Anil_G

also could you please let me know how to find last column of excel…
eg. A,B,C,D are the column and D will be the last column in the sheet which is having data in it.

How to identify that?

[Anil_G (Anil Gorthi)]

@sshitol

identify

@sshitol

If you read the data into datatable using read range and give the first cell value only…it will read data till end…Now do dt.Columns.Count which will give you how many column are there and

uipath.excel.helpers.excelutilities.convertcolumnindextocolumnLetter(dt.Columns.Count) Will give you the excel column name

cheers