topic Subfiled with Different Position in App Development

Subfiled with Different Position

Prabhu1204 — Sat, 16 Nov 2024 18:02:28 GMT

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

Re: Subfiled with Different Position

Vegar — Tue, 29 Sep 2020 19:22:58 GMT

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

SubField(Filename,'_SRAv',1)

Re: Subfiled with Different Position

Prabhu1204 — Wed, 30 Sep 2020 04:37:23 GMT

Thank you.