bdsii
12-04-2009, 09:08 AM
Any help would be appreciated. I am uploading a sample file to help explain the data. The data is in Column A and for the first set of data, the results are shown in Column B.
All data is in one column on one sheet. I want to pull data from between apostrophes from specific rows. Those specific rows are based on the text at the beginning of the cell and seems to remain constant throughout the sheet.
The data for the first line I want appears like the following complete with preceeding spaces:
this.number = '1';
I want to pull the Number 1 and put that data in Column B
The next line appears as below:
this.name = 'TIDECLEAN #7';
I want to pull TIDECLEAN #7 and put that is Column B.
There are several lines that I would like to pull data as demonstrated from above. The spaces and the text preceeding the apostrophes repeat in the list with different data that needs to be extracted.
this.number = '1'; this.name = 'TIDECLEAN #7'; this.address = '6651 WALL TRIANA'; this.city = 'MADISON'; this.county = 'MADISON'; this.stateProvince = 'AL'; this.postalCode = '35757-7402'; this.country = 'US'; this.recordId = '208240'; this.latitude = '34.777110'; this.longitude = '-86.749300';
These lines are always in this order. I was thinking of a loop through the rows of the spreadsheet checking for this.number = '
and then someway pulling the text into column B and then repeating that for each line above all the way to the end of the spreadsheet. Once it is in this format I can then put the data into a format that can be used.
The number of characters between the apostrophes will vary.
Anyone know of a quick and easy way to handle this ? I suppose it would require a loop searching for specific text but I do not know the code to get data from between the two apostrophes. Actually they may be helpfu since it will signify the beginning and ending of the text to be captured.
Any advice or help would be appreciated :think:
Thanks!
All data is in one column on one sheet. I want to pull data from between apostrophes from specific rows. Those specific rows are based on the text at the beginning of the cell and seems to remain constant throughout the sheet.
The data for the first line I want appears like the following complete with preceeding spaces:
this.number = '1';
I want to pull the Number 1 and put that data in Column B
The next line appears as below:
this.name = 'TIDECLEAN #7';
I want to pull TIDECLEAN #7 and put that is Column B.
There are several lines that I would like to pull data as demonstrated from above. The spaces and the text preceeding the apostrophes repeat in the list with different data that needs to be extracted.
this.number = '1'; this.name = 'TIDECLEAN #7'; this.address = '6651 WALL TRIANA'; this.city = 'MADISON'; this.county = 'MADISON'; this.stateProvince = 'AL'; this.postalCode = '35757-7402'; this.country = 'US'; this.recordId = '208240'; this.latitude = '34.777110'; this.longitude = '-86.749300';
These lines are always in this order. I was thinking of a loop through the rows of the spreadsheet checking for this.number = '
and then someway pulling the text into column B and then repeating that for each line above all the way to the end of the spreadsheet. Once it is in this format I can then put the data into a format that can be used.
The number of characters between the apostrophes will vary.
Anyone know of a quick and easy way to handle this ? I suppose it would require a loop searching for specific text but I do not know the code to get data from between the two apostrophes. Actually they may be helpfu since it will signify the beginning and ending of the text to be captured.
Any advice or help would be appreciated :think:
Thanks!