Text to Number

[Protour Travel]

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)

 

[David Jondreau]

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)

[brian rich]

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)