Reading Text File + PRXCHANGE

[Tom]

---

@hernan_AR wrote:

this is the regex

s/(^.*)(SomeAlphaNumPrefix)([\d]+)(\.sas7bdat)$/$3/

with this, I get the digits between the prefix and the extension to the end

because I just need the digits, discarding the rest

do you see anything wrong here ?

---

Yes. The pattern is NOT accounting for the trailing spaces that will be padded onto a fixed length variable so that its length matches the defined length of the variable.  You could for example do something like:

s/(^.*)(SomeAlphaNumPrefix)([\d]+)(\.sas7bdat\ *)$/$3/

[ChrisNZ]

$ means end of string. If you don't trim you have spaces at the end as I said, so you can't match this expression.

[Tom]

Note if you want the last word in a line use the SCAN() function with -1 as the index.  Much easier (and faster) then REGEX.

extension = scan(row,-1,'.');

[hernan_AR]

oh, good to know it

that's why communities llike this are great!

thanks