- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 08-06-2021 08:02 PM
(626 views)
Hi,
I have to replace PQR and -00(basically the number after hyphen , - 00 should alsoconsider if any spaces after hyphen and before 00) to space.
address= "7 12-00 ABC XYZ RD PQR BEACH QLD 1234".
I have used the below expression to replace PQR with space.
prxchange('s/\b(PQR)\b//i',-1,address).
Neeed help with how to replace -00(should alsoconsider any spaces between hyphen and 00)
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Your need is unclear. Like this?
prxchange('s/\b(PQR|-\s*\d*)\b/ /i', -1, ADDRESS).