fork download
  1. txn_add <- data.frame(NARRATION=c("$ $ $ +YBL PATAUDI CHOWK \ $",
  2. "$ $ -ATM CASH 83181 + MAIN BHAWANA ROAD NEW DELHI $",
  3. "$ $ [5839/P1TNDE06/+RAGHUBARPURA $",
  4. "$ MAXIMUMOUTFITS PRIVATE LIMITED } $ ATDELHIIN- $ $ /5631 $",
  5. "$ ATM CASH-N4077800-+SPRINGFIELDCOLONYFFAR IDABADHRIN-04/06/18 $ /5631 ( $ $ VERIFICATION $",
  6. "$ USHAHIGHWAYFILLINGSFARIDABADIN-23/08 /18 $ /5631 (Ref# $ VERIFICATION $"
  7. ))
  8.  
  9. sub(".*?(?|(?:[+@:]| AT(?!M\\b))\\s*([A-Z]+(?:\\s+[A-Z]+)*)|\\b([A-Z]+(?:\\s+[A-Z]+)*)-\\d).*", "\\1", txn_add$NARRATION, perl=TRUE)
  10.  
Success #stdin #stdout 0.24s 39556KB
stdin
Standard input is empty
stdout
[1] "YBL PATAUDI CHOWK"                "MAIN BHAWANA ROAD NEW DELHI"     
[3] "RAGHUBARPURA"                     "DELHIIN"                         
[5] "SPRINGFIELDCOLONYFFAR IDABADHRIN" "USHAHIGHWAYFILLINGSFARIDABADIN"