How To Convert String To Integer

To change a String into an Integer, the Int32 C# library must used, for example,

Int32.Parse([#MyString#])

Note that if the string is not a number, the process will error.  Int32.TryParse is not available in functions to check that the string parses to a number.

This is handy for ordering lookups without changing advanced settings by entering the order of a lookup in the Description field. Multiple levels of ordering can be easily combined.  For example, details with and order could be sorted with a grouping characteristic:

(100*Int32.Parse([#GroupOrder#]))+Int32.Parse([#DetailOrder#])
Like 1

Like

Share

0 comments
Show all comments