How to remove text from the excel cell

Help Activities
1

Duplic.xlsx (8.5 KB)I
I want to delete “JNTU” text from the column “College”.That text needs to be deleted everywhere.Can anyone suggest me any method to do that or upload any workflow if you have

2

Hi @Kavyasri :wave:

Iterate the DT and use replace() to replace the required text with empty space.

row("College").ToString.Replace("JNTU","")

3

Screenshot (670) , I used For each loop to iterate and I used the if condition and took Replace activity(Regex) here,But its not giving correct result…As you gave the suggestion, can you please provide me any workflow of that so I can understand how to use it in my process.

4

@Kavyasri, try this workflow:

Main.xaml (5.9 KB)

Let me know if you are facing any issues!

6

It is working Now…Thank you :slightly_smiling_face:

1 Like
7

No issues @Kavyasri :slight_smile:

I can see that you are new to the community! Welcome! Kindly mark my response as solution so, it can benefit others! Cheers!

8

Yeah Done :+1:

1 Like
9

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