one other question, I have a file name say 40.10.pdf or 40A.10.pdf

How can I pad and show the value to the left of the decimal?

The result I am looking for is:

00040

and

0040A

Tried functions right and left and but can't figure it out

First, extract the value to the left of the first period. Then, since that value is not always a number, you cannot use the SerialIncrement() function to pad it; you need to revert to the old method:

Let (
value = Left ( fileName ; Position ( fileName ; "." , 1 ; 1 ) - 1 )
;
Right ( "000000" & value ; 5 )
)

 

--
P.S.  This has nothing to do with your original question. Please post such questions separately.

 

 

Thanks I will post in a different thread going forward.

I did get it working using brute force...

"0"&(Replace ( PageNumCalc for sort of decimal ;5 ; 5 ; "" ))