naming PDF

[Ian Slater]

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

[comment]

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.

 

 

[Ian Slater]

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 ; "" ))