Have one in particular in mind?Text functionsText can be used to analyze, rearrange, extract, and build text strings. For example, you could use the MiddleWords function to extract specific words from supplied text.•having a text result
I am using the List Function which includes number fields, and would like the number fields to display with a comma.
If a number is all that you are extracting, specify number as your calculation's return type and use the inspector's data tab to specify dataformatting with a thousands separator.
I apologize for not explaining my situation clearer. I have a group of numbered type fields (ex:
Field 1, Field 2, Field 3, etc...). I am
creating a list – using the List Function which includes each of the number
fields. Unfortunately a List Function results
in a Text. Therefore, the number fields
displayed do not include the thousand comma separator. I need a way to add the comma separator.
Let ( [ N = YourNumberField ;
i = Int ( N ) ;
Ge1000 = Floor ( i / 1000 ) ;
Lt1000 = i - Ge1000 * 1000
If ( Ge1000 ; Ge1000 & "," & Right ( "00" & Lt1000 ; 3 ) ; Lt1000 ) & If ( N ≠ i ; N - i )