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
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.
Thankyou @vamsiyeluri If single car name is not available
Only 2 or 3 cars available means how to do that.