How to update a value to NOTHING if the length of string is more than 200 using LINQ

Help Studio
, ,
1

Hello All.

I need to update all the cell values of a particular column to Nothing if the length of that particular string is greater than 200

I need to achieve this using LINQ. Since the excel data has more than 15000 records in it.

Any helps or leads are much appreciated.

2

@Sirimalla_Karthik_Chandra

Let’s say your input DataTable is InputDT

Try below expression in Invoke Code activity to do that.

InputDT.AsEnumerable().ToList().ForEach(Sub(row) row(“ColumnName”) = If(row("ColumnName").ToString.Trim.Length > 200, "Nothing", row("ColumnName").ToString.Trim)

Note: Create one argument for Invoke Code activity and mention properties as below.

Name - InputDT
Direction - In
Type - DataTable
Value - InputDT

1 Like
4

Hi @lakshman , Thank you for replying to my post.

Your expression is working.

1 Like
5

Hi @lakshman, I tried your expression in my local machine and it is working fine. And when I tried the same expression in my development environment. I get the following error
invoke code: Exception has been thrown by the target of an invocation.

Do you have any clues what the possible cause of this error.

6

@Sirimalla_Karthik_Chandra

This error usually occurs when trying to pass null value to the argument. Can you print the DataTable row count before Invoke code activity to check whether it contains any value or not.

7

the row count is 10082, even though I get the same error.

8

@Sirimalla_Karthik_Chandra

Is there an empty values in that column ?

9

it is working fine now. I have placed the invoke code activity at the wrong place.

Thank you so much @lakshman for the help.

1 Like
10

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