extracting a string between 2 characters

Some time ago I was able to write the below line of code.

Please Login or Register  to view this content.

which helped me pull the "XXXXXXXXXXXXXXXXXXXXX" from the below line of text (located in a text file)
3) GS1 : (XXXXXXXXXXXXXXXXXXXXX)

now I have a different text file, with similar data, but with a different text structure that I need to pull the same string from.

the line of text I need to pull from is below:

04:06:57.450| SendIOS |XXXXXXXXXXXXXXXXXXXXX| 00000| X134| | 077| | | 07| 1| 4| | Del_Day_Ind| 3

I need to modify the line of code above, to still give me the XXXXXXXXXXXXXXXXXXXXX as the result. keeping in mind the rest of the macro is already setup to run through the entire text file and uses the line of code above to extract the XXXXXXXXXXXXXXXXXXXXX each time and enter it in a cell.

I'm no excel genius, but I've dabbled many times, and can usually modify the macro to fit my needs...but this one is making a fool of me.

here is the entire macro, in case that would be of assistance

Please Login or Register  to view this content.

Originally Posted by tefuzz

... 3) GS1 : (XXXXXXXXXXXXXXXXXXXXX) ...

Has anything changed in relation to this previous topic (?):

https://www.excelforum.com/excel-pro...-document.html

or is it the same topic ?

Attaching a simple text file can help us help you better. As I understand it:

Please Login or Register  to view this content.