error in custom function

[dysong3]

I am trying to install a custom function from http://www.briandunning.com and can't see why I am getting an error message.  

The message is "An operator (e.g. +,-, *, …) is expected here."

 

The function is :

Let(

[NumbersOnly = Filter(Phone; "0123456789");
NewNumber = Right(NumbersOnly; Length(NumbersOnly) - 1);
NewFormat = Right(Format; Length(Format) - 1)];

Case(

not IsEmpty(Format);

Case(
Left(Format; 1) = "#";
Left(NumbersOnly; 1) & PhoneFormat(NewNumber; NewFormat);
Left(Format; 1) & PhoneFormat(NumbersOnly; NewFormat)
)

)

)

The error occurs on the opening parentheses here "PhoneFormat(NewNumber;)"

 

I have this same function working perfectly on another file and can't see why I getting this error on the file I'm working on.

 

Can someone point me in the right direction?

[Kris M]

The setup works.. make sure the Function Name is right. this is recursive function that calls itself so the name has to match

 

here is the recursive call... Left(NumbersOnly; 1) & PhoneFormat(NewNumber; NewFormat);

 

The Function Name match the bold underline italic

[Lee Smith]

 

I have this same function working perfectly on another file and can't see why I getting this error on the file I'm working on.

 

Can someone point me in the right direction?

You do know that with FileMake Pro Advance, you can Copy a Custom Function in one file and Paste it into another, right?

[dysong3]

Thanks very much for you replies.  When I saw "make sure the Function Name is right. this is recursive function that calls itself so the name has to match", I thought of course.  But then I went and tested it again and this time it worked with a different Function Name than in the function.  So I resolved the problem but not my understanding of it.

I also realised after posting that in Advanced not only can you copy and paste functions but you can import them directly from another file. 

Thanks for all that.

[comment]

But then I went and tested it again and this time it worked with a different Function Name than in the function.  So I resolved the problem but not my understanding of it.

 

Yes, I think by now you have increased the overall level of confusion considerably. Would it be possible to see a screenshot of your original attempt, with the error message?

[Lee Smith]

 

I also realised after posting that in Advanced not only can you copy and paste functions but you can import them directly from another file. 

 

and a Utility such as Clip Manager 4