Replace Placeholders by column Header

Help Activities
,
1

Hi,

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

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

For Example:

image
image866Ă—85 3.43 KB

Here <> need to be replaced with column name,

Any regular expression for this?

Regards,
Deeipauk

2

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

3

Hi

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

4

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

Thanks
Chethan P

5

image
image603Ă—523 8.02 KB

image
image1050Ă—571 22.6 KB

image
image1186Ă—475 19.1 KB

image
image1015Ă—285 12.9 KB

image
image1124Ă—652 36.8 KB

I hope now you cleared

6

I hope the above post will help You

If you get the solution mark solution and close the topic

Thanks
Chethan P

1 Like
7

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

1 Like
8

sure check if you got the solution let me know

Happy Automation
Chethan P