[RESOLVED] searcing between two word

[luca90]

I have in a txt file a line similar:
...
AAAAA a12312312 BBBBBB
....

I need to get only this part: a12312312

in effect i need to get value between to other string part, how to?

note:

the postion in string of AAAAA and BBBBBB is variable

[B61Nuke]

I need to get only this part: a12312312
the postion in string of AAAAA and BBBBBB is variable

Is the string you want to get ALWAYS the same string?

[luca90]

Is the string you want to get ALWAYS the same string?

If your dubt is about that "a12312312", no!
Is only an example...

i can have a variable string with a variable lenght from AAAAAAA and BBBBBBBB

[DataMiser]

You may want to try Split() with space as the seperator which will break the string into an array. From your example element 1 of the array will hold the data you want.

Or you can use a combination of Instr() and Mid() to get the data.

[jcis]

Assuming there are blank spaces before and after the string like in your example:

Private Function getString(s As String, a As String, b As String)
Dim s_start As Long, s_end As Long
    
    s_start = InStr(1, s, a) + Len(a) + 1
    s_end = InStr(1, s, b) - 2
    
    getString = Mid(s, s_start, s_end + 1 - s_start)
End Function

Usage:

    MsgBox getString("222 AAAAA a12312312 BBBBBB 333", "AAAAA", "BBBBBB")

Instr() returns the a String position inside another string
Mid() returns an String inside another, given the start position and its lengh

[luca90]

Assuming there are blank spaces before and after the string like in your example:

Private Function getString(s As String, a As String, b As String)
Dim s_start As Long, s_end As Long
    
    s_start = InStr(1, s, a) + Len(a) + 1
    s_end = InStr(1, s, b) - 2
    
    getString = Mid(s, s_start, s_end + 1 - s_start)
End Function

Usage:

    MsgBox getString("222 AAAAA a12312312 BBBBBB 333", "AAAAA", "BBBBBB")

Instr() returns the a String position inside another string
Mid() returns an String inside another, given the start position and its lengh

IS PERFECT!

Sorry me, in other case, for my bad english

ops... note:

I have 2 friends argentinos, but they live in Italy from 40 years

[B61Nuke]

If your dubt is about that "a12312312", no!
Is only an example...

i can have a variable string with a variable lenght from AAAAAAA and BBBBBBBB

I was only asking and used your example you posted. I know your string was not the same as the example. Your answer about the variable string and the length was critical info to get you the correct answer. thats why I had asked.