Trim Column

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hello,

I have this excel where the code column has values in the format of “IPxxxx”. I just want the numbers, that is, remove the “IP” in front of it.

However, in some excels, the “IP” has already been removed. So how can we implement this? Like, check if there is “IP” then remove or else continue.

Before:

After:

Thanks!

[Palaniyappan (Forum Leader)]

Hi

Hope the below expression would help you resolve this

Use a Invoke activity like this

dt.AsEnumerable.ToList.ForEach(Sub(row) row(“Code”)= row(“Code”).ToString.Replace(“IP”, ””))

Cheers @Yudhisteer_Chintaram1

[ppr (Peter Preuss)]

in general we can trim:

A flow could look like this:

row("Code").toString.TrimStart(" IP".ToCharArray)

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

I get this however:

[ppr (Peter Preuss)]

The mentioned LINQ statement cannot be used within an Assign activity, due it has no return to the left side.

You can use it within an invoke code activity. But we would recomment to do the update within a for each row and an assignment as shown above

[Palaniyappan (Forum Leader)]

Thanks for the mention
My bad @ppr