How to remove "PC-F50A" or "|PC-F50A" or "PC-F50A|" in input excel

Help Activities
, ,
1

Hi Team,
I have oone excel
In that excel column “L” I have a data
So I want remove “PC-F50A” or “|PC-F50A” or “PC-F50A|”. values in each row

Please suggest.

Please find the Input attachment for your reference
input (2).xlsx (12.0 KB)

I want to remove “PC-F50A” or “|PC-F50A” or “PC-F50A|” this data only in each row .

Thanks in advance,
Baby.

2

Hello @Baby123 ,
Just use str.Replace(“the string you want to replace”,“”)

3

Hi @Shubham_Dutta ,
After replacing I want paste the remaining data in a same row.
Thanks

4

@Baby123 , You can use LINQ to replace the values

dt = dt.AsEnumerable().Where(Function(a) a.Field(of string)("yourcolumnname").ToString.Replace("your old value"," your new value").ToString).CopyToDatatable()

EX :

dt = dt.AsEnumerable().Where(Function(a) a.Field(of string)("ColumnL").ToString.Replace("PC-F50A","").ToString or  a.Field(of string)("ColumnL").ToString.Replace("PC-F50A|","").ToString or  a.Field(of string)("ColumnL").ToString.Replace("|PC-F50A","").ToString).CopyToDatatable()
1 Like
5

Hi @Baby123 ,
I have created a workflow for your reference please go through it. You can see the output in excel file.
FC.zip (13.3 KB)

Thanks & Regards,
Shubham Dutta

6

Hi @Shubham_Dutta ,

It’s working fine
Thanks for quick response.

Hi @pavithra_pavi ,
Thankyou for response
But in my prjct linq queries not using
Thank you for your help and support

1 Like
7

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