PhilipColtharp
PhilipColtharp
/ gist:be5e4d2cb8c31741835b8c9659f9f56e
Created
August 6, 2021 13:34
Excel_document.sas
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*New EG Node*/ | |
| ODS document name=excel(write); | |
| ODS document close; | |
| title;footnote; | |
| /*New EG Node*/ | |
PhilipColtharp
/ RegexExtract.vba
Last active
December 4, 2020 18:14
— forked from neblish/RegexExtract.vba
MS Excel - VBA function to extract text using Regex
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Private RE As Object | |
| Option Base 1 | |
| ' Shamelessly leeched from StackOverflow: https://stackoverflow.com/questions/7086270/how-to-extract-text-within-a-string-of-text | |
| ' then copied notoriously from https://gist.github.com/neblish/b328bc373669d13bec5b3f04ec02d2a3 | |
| ' Altered code from gist.github.com/neblish to send output to Excel as an array | |
| ' function producing a 1xN "array" of strings. Function outputs to Excel | |
| ' columns based on sub matches present in Regex. See Excel support[1] for array | |
| ' formulas. At the time of this post, the programmer certifies that this |