Hello, I want to count length in column Create ID by use if condition If CurrentRow(“Create ID”).Tostring.Length<7 remark But error : Object reference not set to an instance of an object. I debug run output as below. [image] Please guide me for solve it.

@fairymemay String.IsNullOrWhiteSpace(row("Create ID").ToString) OrElse row("Create ID").ToString.Length < 7 OrElse row("Create ID").ToString.Equals("espgadmin", StringComparison.OrdinalIgnoreCase) Hope this works for you

Count length string

Help Activities

Topic		Replies	Views
Matching Number in Number Variable Activities excel , activities , question	3	837	December 31, 2021
Question read cell value Activities excel , question	4	738	March 7, 2022
Counting row data length Help datatable , excel , activities , question	5	4405	December 7, 2019
Check for number of characters in a excel row Activities excel , activities , question	7	1763	July 22, 2021
I have to validate each row in particular column(Display Id) with length Studio studio , question , activities_panel	15	490	September 30, 2023

Count length string

Related topics