getivan

Ivan's Scrapebox Regular Expression or Regex

Sep 12th, 2021 (edited)
750
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Email:
  2. (\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}\b)
  3.  
  4. USA Address:
  5. \b(?:\d[\d-]{0,5} +)?(?:[a-zA-Z-]{2,15}[., ]+)+\d{5}\b
  6. Lighter version, if the one above freezes (preferred):
  7. \d{2}[\d-]{0,4} +(?:[a-zA-Z-]{2,15}[., ]+){2,9}\d{5}\b
  8. See the complete history, here, if you click the version dropdown:
  9. https://regex101.com/r/D6HGL8/15
  10.  
  11. Find first comma per line, for Notepad++ find/replace:
  12. ^[^,\n]*\K,
  13.  
  14. USA Phone Numbers:
  15. 1-888-888-8888
  16. \d{1}-\d{3}-\d{3}-\d{4}
  17. 888-888-8888
  18. \d{3}-\d{3}-\d{4}
  19. (888) 888 888
  20. \(\d{3}\) \d{3} \d{4}
  21. (888) 888-8888
  22. \(\d{3}\) \d{3}-\d{4}
  23.  
  24. UK Phone Numbers:
  25. 07911 123456
  26. \d{5} \d{6}
  27. 07911-123456
  28. \d{5}-\d{6}
  29. 01355 221 113
  30. \d{5} \d{3} \d{3}
  31. 01355-221-113
  32. \d{5}-\d{3}-\d{3}
  33. 0191 488 7288
  34. \d{4} \d{3} \d{4}
  35. 0191-488-7288
  36. \d{4}-\d{3}-\d{4}
  37. 020 8088 3278
  38. \d{3} \d{4} \d{4}
  39. 020-8088-3278
  40. \d{3}-\d{4}-\d{4}
  41. 01914 88 7288
  42. \d{5} \d{2} \d{4}
  43. 01914-88-7288
  44. \d{5}-\d{2}-\d{4}
  45. 01914 8 87 288
  46. \d{5} \d{1} \d{2} \d{3}
  47. 01914-8-87-288
  48. \d{5}-\d{1}-\d{2}-\d{3}
  49. 01914 8 7288
  50. \d{5} \d{1} \d{4}
  51. 01914 8 7288
  52. \d{5} \d{1} \d{4}
RAW Paste Data