DataTable select with substring

[Paul Fallows]

Hi


I have a datatable with data like:


col1 col2 col3 col4

test test data 50 true

test test result - master 100 true

test test result - number1 75 true

test test result - number2 100 true

test test test 100 true

test not test 100 false


How can I select rows which col 4 is true and distinct col2 where if it contains '-' only take the text before the '-' e.g. I would be left with:


col1 col2

test test data

test test result

test test test

Thanks

Paul

Continue reading...