Replace Placeholders by column Header


I have 2 sheets in a excel, one is a data table having around 7 columns as given below

In Other sheet, I have configuration where i need to replace place holders with column header

For Example:

Here <> need to be replaced with column name,

Any regular expression for this?


If you want to replace <> use replace like vaar1.toString.Replace("<>",header)
no need to use REGEX


If you observe << GEID >> - row(“GEID”),
so << replace with row(" and >> replace with "). If i use replace, this is coming as string in the output like row(“GEID”) and not getting value from the Data Table

then do one thing use assign activity inside that you fill the data and pass that variable inside your data and then use replace method simple

I hope you will get to know what am try to say

Chethan P

I hope now you cleared

I hope the above post will help You

If you get the solution mark solution and close the topic

Chethan P

1 Like

I haven’t tried your solution yet, I will check.
Thanks for your help

1 Like

sure check if you got the solution let me know

Happy Automation
Chethan P