Extracting string content to generate new variables

Hi Statalist Wizs,

I am currenrtly working with one dataset that has the following string observations:

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str115 id
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
"/Users/dinardorodriguez/Box Sync/PublicCharge/Data/Raw/SNAP/TX/Raw TX/snap-enrollment-february-2016.xls"
end

I am trying to extract content to generate two new variables: one for month and one for year. As you can see each observation has a filename where this information can be extracted from. Although the dataex only shows for February 2016, there are several more dates that follow.

Does anyone have any ideas how I can go about doing this to get what I need? Any help will be greatly appreciated!

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Extracting string content to generate new variables
Extracting string content to generate new variables

0 Response to Extracting string content to generate new variables

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Extracting string content to generate new variables Extracting string content to generate new variables

Related Posts with Extracting string content to generate new variables

0 Response to Extracting string content to generate new variables

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Extracting string content to generate new variables
Extracting string content to generate new variables