HELP need to calc txt

[MacB]

I't s a nooby question but can't figure it out.

I need to extract the text between the "_":

example:

A0110001_2draw1_.ai

D1111_detail1_.tif

30821_1fx1_.tif

ANY help is appreciated!

thx. MacB, Netherlands

[comment]

Try:

GetValue ( Substitute ( text ; "_" ; ¶ ) ; 2 )

Note that this assumes that text always comes in the format of "a_b_c" and that it doesn't contain any carriage returns.

[MacB]

Extremely awesome!!! Thx...now i need to figure out why it works!!! LOL Gee.... a lot to learn!

Thank you very much!

MacB