Text to Number

June 20, 201312 yr

Is there a way to place a comma in the Capacity line? Thanks!

Â

TextSize (TextStyleAdd ( Clients::Name; Uppercase + Bold); 18 ) & TextSize ( TextStyleAdd (" ("& TypeDay &")"; Uppercase); 18) & Â¶ &
TextSize ( TextStyleAdd ( Print_CityCSState;Uppercase ); 14) &Â¶ &
TextSize ( TextStyleAdd ( Venue; Uppercase); 14) & Â¶ &
TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & GetAsNumber ( Capacity );If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12)

Â

June 20, 201312 yr

Replace

TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & GetAsNumber ( Capacity );If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12)

with

TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & GetAsNumber ( Capacity ) & "," ;If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12)

June 20, 201312 yr

You could add a custom function such as formattedNumber() to do this for you. This custom function can be found at

http://www.briandunning.com/cf/451

Then your calculation becomes:

TextSize (TextStyleAdd ( Clients::Name; Uppercase + Bold); 18 ) & TextSize ( TextStyleAdd (" ("& TypeDay &")"; Uppercase); 18) & ¶ &
TextSize ( TextStyleAdd ( Print_CityCSState;Uppercase ); 14) &¶ &
TextSize ( TextStyleAdd ( Venue; Uppercase); 14) & ¶ &
TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & formattedNumber(Capacity;",";""); If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12)