Linq Query: Need Query to replace the string in DT

Help Studio
, ,
1

This is my Excel Data with two columns

Name Score
john fail
rony pass
helium pass
ruby fail

I need linq query to replace the “fail” as “0” and “pass” as “1” in score column, but i want to write into the another column,

Expected Output:

Name Score New Score
john fail 0
rony pass 1
helium pass 1
ruby fail 0
2

have a look at this Blog elaborating on different options:

as discussed in the Blog, maybe the Datacolumn.Expression approach maybe is a better fit

3

Thanks for your help :slight_smile:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.