Remove the extension from a file name
How can i extract the numbers/text without the .pdf
Field one : 2346H177389.pdf
Field two : 2346H177389
the file name is never the same length.
a CustomFunction would solve this:
Before ("2346H177389.pdf" ; ".pdf" ; 1 )
would show result = 2346H177389
Yes, but you really don't need a custom function--which requires FileMaker Advanced in order to add to a solution.
Left ( field one ; Position ( Field one ; "." ; Length ( field one ) ; - 1 ) -1 )
returns all text to the left of the last "." found in field one.
Retrieving data ...