PDA

View Full Version : VBA code to extract strings



twozedz
05-15-2016, 02:12 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


kjlkhkashdkahskdhaskdhaskdhkasdhkashdkashdkashdkashdkashdkashdkashdkashdkas hdkash
naksdhaskjdhkashdkashdkashdkashdkjashdkjashdkjashdkjashdkasjhdkajshdkas


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!!!!!!

jvbeaupre
01-04-2019, 04:08 AM
This should be doable with the ISTR function. Look it up.