Hi Gowsaliyan,
There are multiple ways we can proceed with.
Method 1 :
> Use MS Excel VBO's to get the corresponding cell Value and store in a data item.
> Use MS Word VBO modify the code stage to include "Find and replace" action. if you want to include the retrieved data from excel and insert it in the document you can use this action to find the word and replace with existing word + retrieved value.
Ex. Excel Value (114) = NEW
Document Page 2 paragraph sentence contain = Hello! This is a wonderful world.
And you want to insert next to the word "wonderful"
you can use find and replace action where you will find the word "wonderful" and replace with "wonderful"+"New"
Result = Hello! This is a wonderful NEW world.
Method 2 :
>Read the word document MS Word VBO - Get Body
> Output will be stored in data item, you can use that and proceed with string manipulation techniques.
Method 3:
>Read the word document MS Word VBO - Get Body
> Output will be stored in data item, you can use that and proceed with regex.
Thanks,
------------------------------
Gerald J
Automation Engineer
10xds
Kerala/Kochi
+91-9159842805
------------------------------