BookmarkSubscribeRSS Feed
nickb
Calcite | Level 5
I'm trying to find the best to extract a string value that is after the 2nd "/"?

An example:
/explore/hospitality/index.cfm

I want to just have hospitality as the value.

Thanks
2 REPLIES 2
Reeza
Super User
Look up the scan () function.

scan ('/explore/hospitality/index.cfm', 2, '/');
ballardw
Super User
If this string may have varying "/" characters then you may want to look at the modifier B option to search backwards for the last one instead of a specific numbered position.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1024 views
  • 0 likes
  • 3 in conversation