Save regex capturing group for use later

mdale9mdale9 Member Posts: 5 Contributor I
I'm reading in multiple sheets from an excel file and the first element contains an identifier for the data rather than an attribute name.  I'm using "Rename by Replacing" to change the attribute name to something more appropriate but I'd like to keep the regex capture response for later use when I create an new attribute and start to append all the sheet processing results together.
I've looked at logging and extracting to macro but the logging only logs the regular expression, not the result of the regex operation.

Any ideas?

Best Answer


  • Options
    mdale9mdale9 Member Posts: 5 Contributor I

    Thanks for that, finally got it to work.

Sign In or Register to comment.