Consulting

Results 1 to 2 of 2

Thread: VBA code to extract strings

  1. #1

    VBA code to extract strings

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

  2. #2
    This should be doable with the ISTR function. Look it up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •