VBA code to extract strings

twozedz · #1 05-15-2016, 02:05 AM

Hi I have the text below in a notepad file. I would like to extract strings that start with "TKT-" and end with ".xml"

TEXT IN NOTEPAD FILE:

TKT-YHDIDOSOOSD.XML hwew asdajsdasdh asdasdasdas TKT-PYD-JHJHJSDSDSD.XML
 
UDkhaishdkashdhasdas* asdjasldjlasdasjdlasjdl jasldjlasjdlasjdlasjdlasjdaslkdjlasjdlasjdlasjdlas
 
kjlkhkashdkahskdhaskdhaskdhkasdhkashdkashdkashdkas hdkashdkashdkashdkashdkashdkash
naksdhaskjdhkashdkashdkashdkashdkjashdkjashdkjashd kjashdkasjhdkajshdkas
 
ahkjsdhaksj
 
aslasdjalsjdask TKT-JKSJDKSDJKSJD.XML asdkaskdhaskdhasjhdkashdash TKT-89823483hkshdfkhsd.XML

SO the vba code will paste the following in the cells of a spreadsheet
TKT-YHDIDOSOOSD.XML
TKT-PYD-JHJHJSDSDSD.XML
TKT-JKSJDKSDJKSJD.XML
TKT-89823483hkshdfkhsd.XML

Can someone please help and point me in the right direction? Thanks heaps!!!!!!

NoSparks · #2 05-15-2016, 06:00 AM

'tis very unfortunate the OP is incapable of reading or following any of the forums rules and/or has no respect for those rules nor the time of the very people from which they seek assistance.

Should have a read of this for some kind of understanding.

So no one here wastes their time.

https://www.msofficeforums.com/excel...t-strings.html
http://www.excelguru.ca/forums/showt...xtract-strings
http://www.mrexcel.com/forum/excel-q...t-strings.html
http://chandoo.org/forum/threads/vba...-string.29464/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to login a web site and extract data to excel	edneco	Excel Programming	4	07-07-2015 02:05 PM
Extract VBA code to save in Word document	Dave T	Word VBA	4	01-26-2015 08:41 PM
VBA code to extract specific bookmarks from multiple word files	Rattykins	Word VBA	4	06-27-2012 10:02 PM
Extract Numbers from Zip Code	Karen615	Excel	3	09-21-2011 06:54 AM
update style of all strings available between two specific strings	vikrantkale	Word	1	03-28-2011 06:13 PM