https://communities.sas.com/t5/SAS-Procedures/Scanning-a-character/m-p/17087#M3217 I'm trying to find the best to extract a string value that is after the 2nd "/"?<BR /> <BR /> An example:<BR /> /explore/hospitality/index.cfm<BR /> <BR /> I want to just have hospitality as the value.<BR /> <BR /> Thanks Thu, 24 Feb 2011 17:55:37 GMT nickb 2011-02-24T17:55:37Z https://communities.sas.com/t5/SAS-Procedures/Scanning-a-character/m-p/17087#M3217 I'm trying to find the best to extract a string value that is after the 2nd "/"?<BR /> <BR /> An example:<BR /> /explore/hospitality/index.cfm<BR /> <BR /> I want to just have hospitality as the value.<BR /> <BR /> Thanks Thu, 24 Feb 2011 17:55:37 GMT https://communities.sas.com/t5/SAS-Procedures/Scanning-a-character/m-p/17087#M3217 nickb 2011-02-24T17:55:37Z https://communities.sas.com/t5/SAS-Procedures/Scanning-a-character/m-p/17088#M3218 Look up the scan () function. <BR /> <BR /> scan ('/explore/hospitality/index.cfm', 2, '/'); Thu, 24 Feb 2011 18:36:42 GMT https://communities.sas.com/t5/SAS-Procedures/Scanning-a-character/m-p/17088#M3218 Reeza 2011-02-24T18:36:42Z https://communities.sas.com/t5/SAS-Procedures/Scanning-a-character/m-p/17089#M3219 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. Thu, 24 Feb 2011 19:08:38 GMT https://communities.sas.com/t5/SAS-Procedures/Scanning-a-character/m-p/17089#M3219 ballardw 2011-02-24T19:08:38Z