Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4792 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Greets from Ceti Alpha 5 (otherwise known as Texas):

I'm trying to create a calculation that counts the number of characters in a field, but am having trouble inserting a thousands separator for the text output. Here's what I have so far:

Case( IsEmpty( JobDescription__lxt ) ; "Count: 0" ; "Count: " & Length( JobDescription__lxt ) )

The only addition I could come up with injecting into the calc is:

Left (JobDescription__lxt;1) & "," & Right(JobDescription__lxt;3);

Left (JobDescription__lxt;2) & "," & Right(JobDescription__lxt;3);

Left (JobDescription__lxt;3) & "," & Right(JobDescription__lxt;3)

...but I think I'm on the wrong track. How would I code the calc so the output would be:

Count: 1,540

...instead of:

Count: 1540

TIA for your help!

Rich

Posted

Well, I thought of that and tried it, but when I set the output of the calc to "Calculation result is a Number", the word, Count, no longer appears; setting the result as Text brings it back, but then I don't have access to the Inspector's Date Formatting choices where I'd set the it for Decimal. :S

Posted

when I set the output of the calc to "Calculation result is a Number", the word, Count, no longer appears

Some context would be useful here. If you need this for display only, you could type the word "Count: " directly onto the layout, and append a merged calculation field (or a variable) to it.

Posted

Very clever, Raybaudi! I _never_ would've thought of using NumToJText--thanks for a nice addition to my FMP toolbox. :)

Indeed, Comment, your suggestion would've worked just as well, too. Thank you both!

Posted

I see there is a need for clarification here :)

I didn't steal this but took a license at Agnès Inc.

I was born holding 3 passports (British, French, Swiss). I have lived in these 3 countries as well as in Germany, Poland, and now Belgium.

This makes me a natural born European, completely ignorant of the concept of nation :)

Posted

Hi Fabrice,

did you really take a license for a FileMaker function ? Or for its particular use ?

And, speaking of your born, which was the city ? ( Cambridge, Cambridgeshire, England, UK ??? )

Posted

I was just kidding. Agnès invented this technique.

And because this matters above all and everyone wants to know:

http://g.co/maps/re928

And now I'm moved to tears because of you! :cry:

(that is another stupid joke)

This topic is 4792 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.