can some on explain: prxchange('s/^\x00+ +$/ /', -1,my_column) as chan... - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

can some on explain: prxchange('s/^\x00+ +$/ /', -1,my_column) as changed_column

Posted 09-19-2014 10:48 AM (1050 views)

prxhange('s/^\x00+ +$/ /', -1,my_column) as changed_column

I understand it as prxchange('substitute/pattern,/replacement/',until end of source, my_column) as changed_column, am I right?

can some one explain the pattern /^\x00+ +$/ ?

1 REPLY 1

Barite | Level 11

Barite | Level 11

Re: can some on explain: prxchange('s/^\x00+ +$/ /', -1,my_column) as changed_column

Posted 09-19-2014 12:58 PM (1000 views) | In reply to venka

did you google for the perl regular expressions?

---->-- ja karman --<-----

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!