Filter text until -

[bens]

Hi

 

How can i filter a txt from this "2100-619903.psd" to this "619903".

It should always remove the .psd and all the characters until "-" if there are a "2100-" there could also be txt without "2100-".

 

The 4 numbers before the "-" could be all kind of characters, and there could be "-" in other places 2100-619903-8.psd

 

Regards

Frank

[eos]

Try:

Let ( [
  ~s = Substitute ( yourValue ; ".psd" ; "" ) ; // assuming the suffix will always be ".psd"
  posD = Position ( ~s ; "-" ; 1 ; 1 )
  ] ;
  Replace ( ~s ; 1 ; posD ; "" )
)

[Lee Smith]

Left (yourField ; 4)

[bens]

Perfekt, thanks