Forum Discussion

Azeddin_Margani's avatar
Azeddin_Margani
Contributor
8 years ago
Solved

Using variables within text

Hi,   Could someone please help - I want to use variables fed from spread sheet within piece of text.   The part of text i need to replace as variables is highlighted in red: .ClickItem ("Produc...
  • shankar_r's avatar
    shankar_r
    8 years ago

    Here you go, this function will replace the things you want.

shankar_r's avatar
shankar_r
Community Hero
8 years ago

Maybe we have to write a function that can differentiate the String and and Project variable.

 

Something like this,

 

Excel cell value = "String1<projectvariablename1>String2<projectvariablename2>"

 

then you can write a function which will get the name of the project and returns the project variable value.

 

 

  • shankar_r's avatar
    shankar_r
    Community Hero
    8 years ago

    Here you go, this function will replace the things you want.