Subfiled with Different Position

[Prabhu1204]

Hello

I need to fetch the String CAI and ITA_SES from the below file names(The string before _ SRAv) I tired the subfiled using delimiter . As the below Files names have different position I am unable to extract.

CAI_SRAv07_2020_08_v2.xlsx
ITA_SES_SRAv05_2020_09.xlsx

Thanks in Advance

[Vegar · Accepted solution]

What if you use '_SRAv' as delimiter in your subfield? Like this:

SubField(Filename,'_SRAv',1)

[Prabhu1204]

Thank you.