How to change specific portion of a paragraph stored in excel file?

Help Studio
, ,
1

I have been tasked to manipulate specific words in a paragraph which is being stored in an excel file, I tried to use the Modify Text inside that I used Find and Replace option but instead of changing that specific portion of the text, it is changing the entire text.
How can I do that?
For reference here’s the current used snippet:
image

2

Hi @shreesh.bhardwaj_6

Can you try the below

This is a flowchart diagram representing a process of reading data from an Excel workbook, iterating through each row, making assignments to a certain column, and then writing the modified data back to the same or another Excel workbook. (Captioned by AI)
This is a flowchart diagram representing a process of reading data from an Excel workbook, iterating through each row, making assignments to a certain column, and then writing the modified data back to the same or another Excel workbook. (Captioned by AI)818×913 38.7 KB

CurrentRow("Message") = CurrentRow("Message").ToString.Replace("Name",CurrentRow("Name").ToString)

Regards,

3

@shreesh.bhardwaj_6

Here is your approach

The image depicts a UiPath workflow sequence that reads data from an Excel sheet, modifies text within each row by replacing occurrences of a word with another value from the same row, and writes the updated data back to the Excel sheet. (Captioned by AI)
The image depicts a UiPath workflow sequence that reads data from an Excel sheet, modifies text within each row by replacing occurrences of a word with another value from the same row, and writes the updated data back to the Excel sheet. (Captioned by AI)818×1038 52.8 KB

Regards,

4

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