Guest User

Untitled

a guest
Jan 16th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. (d*-d*)*
  2.  
  3. (d*-(d*-d*-d*-d*))
  4.  
  5. ([0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3})
  6.  
  7. NETWORK-1-1-1-1
  8. ACCESS-1-1-1-1
  9. FA0/1
  10. GE-0/2/3
  11. XE-2/1/10
  12. GI0/0/1
  13. GIGABIT ETHERNET 1-1-2
  14. 1-1-2-100
  15. 1-1-2-10.943
  16.  
  17. 1-1-1-1
  18. 1-1-1-1
  19. excluded
  20. excluded
  21. excluded
  22. excluded
  23. 1-1-2
  24. 1-1-2-100
  25. 1-1-2-10
  26.  
  27. IF REGEXP_MATCH([Port Access Less VLAN],'(d{0,3}/d{0,3}/d{0,3})')
  28. THEN REGEXP_EXTRACT([Port Access Less VLAN],'(d{0,3}/d{0,3}/d{0,3})')
  29.  
  30. ELSEIF REGEXP_MATCH([Port Access Less VLAN],'(d{0,3}/d{0,3})')
  31. THEN REGEXP_EXTRACT([Port Access Less VLAN],'(d{0,3}/d{0,3})')
  32.  
  33. ELSEIF REGEXP_MATCH([Port Access Less VLAN],'([0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3})')
  34. THEN REGEXP_EXTRACT([Port Access Less VLAN],'([0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3}-[0-9]{0,3})')
  35.  
  36. ELSE NULL
  37. END
  38.  
  39. 1-1-1-1
  40. 1-1-1-1
  41. 0/1
  42. 0/2/3
  43. 2/1/10
  44. 0/0/1
  45. 1-1-2
  46. 1-1-2-100
  47. 1-1-2-10
Add Comment
Please, Sign In to add comment