1 Reply Latest reply: Jan 10, 2013 1:44 AM by Ben Rogers RSS

    Text Substitution in Excel

    887112
      Can you use attribute substitution in determining an Excel text attribute as you can in Word?

      Word substitution usage:

      text attribute = "blah blah blah" & attribute to be included & "blah blah blah"


      Is there a way to do this in an excel table?
        • 1. Re: Text Substitution in Excel
          Ben Rogers
          Hi,

          This is similar to the following post:
          Re: OPM 10.3: Text Attributes Interpreted as Literal Strings in Excel

          Basically if you use parenthesis you should be able to achieve this. Unless you put parenthesis around the attribute name, the compiler will interpret it as literal text.

          So :
          text attribute = "blah blah blah" & attribute to be included & "blah blah blah"

          Should be written as:
          text attribute = "blah blah blah" & (attribute to be included) & "blah blah blah"

          However this only seems to work as a condition in the Excel table (im testing in 10.3 at the moment). If you want to use text attribute = "blah blah blah" & attribute to be included & "blah blah blah" as a CONDITION then this is the solution to your problem.


          If you want to set a conclusion "the attribute to set" , the following doesnt seem to work:
          (the other attribute to set) & "blah blah"

          Only (the other attribute to set) will work when assigning the value to the conclusion "the attribute to set"...it doesnt look like you can mix literal strings like "blah" and actual attribute values like (the other attribute) in a conclusion style. An easy workaround would be to declare an intermediate in Word to then use in Excel.

          Hope this helps!
          Ben