KEEPBEFORE using variable

1

Hi all,
I’m trying to use RIGHT ( KEEPBEFORE( [VAR_Namo_of_file], ‘.’) , 2) to find the 2 last number of file name that are representing the year without success. What am I wronging ??
Thanks
For istance files like these ones.

Nome_file15.xlsx
Nome_file16.xlsx
Nome_file16.xlsx
Nome_file17.xlsx

2

Hi @giovannino,

I tried your expression and it worked perfectly. I only removed the space between RIGHT and the left parenthesis.
What error are you getting?

2017-05-23 11_32_58-Untitled - EasyMorph Professional.png887×273 11.7 KB

3

OK Thanks !!! I will try again tomorrow ;-))