Replace value in column with another column if #

[christian.bendtsen]

Hallo

If Column e = # then i need to replace # with the data from F

i tried som invoke code lige this:

dtTemp.AsEnumerable.ToList.ForEach(Sub(row)
If row(“e”).ToString.StartsWith(“#”) Then
row(“e”)=row(“f”)
End If
End Sub
)

But cant figure it out, any good advices?

[lrtetala (Lakshman Reddy)]

Hi @christian.bendtsen

Try this

Code:

dtTemp.AsEnumerable().ToList().ForEach(Sub(row)
    If row("e").ToString().Equals("#") Then
        row("e") = row("f").ToString()
    End If
End Sub)

Input:

Output:

Regards,

[christian.bendtsen]

@lrtetala

dtTemp.AsEnumerable().ToList().ForEach(Sub(row)
    If row("e").ToString().Equals("#") Then
        row("e") = row("f").ToString()
    End If
End Sub)

I got this Error: Invoke code exception has been thrown by the target of an invocation

[lrtetala (Lakshman Reddy)]

@christian.bendtsen

Did you passed variables correctly? Can you please share xaml file

Regards,