Data Table column validation

i have a datatable with a column name Brand
Brand

FORD,SWIFT
INDICA
BMW,BENZ,INDIGO
AUDI,SUZUKI,DESIRE

Now i want to fetch the row which is having single car name eg:INDICA

How can i achieve this

Hi…
@RachelN divide the row’s with delimiter “,” then you will able to separate the not having of “,” rows those rows having only singe value… Monthly.xlsx (8.1 KB) test.xaml (5.9 KB) rows.

1 Like

Thankyou @vamsiyeluri If single car name is not available
Only 2 or 3 cars available means how to do that.

Go through this you will able to understand… test.xaml (7.4 KB) Monthly.xlsx (8.2 KB)

1 Like