QQ - What is the difference between ICAST and WILDICAST?

This question is relevant for the following functions:

• Engineering | Functions | String | ICAST
• Engineering | Functions | String | WildICast
• Engineering | Functions | String | DCAST
• Engineering | Functions | String | WildDCAST

The ICAST and DCAST functions require that the source string data contains data that is only numeric - if there are any non-numeric characters in the source data then the function will return null for each record.

The WildICast and WildDCast functions are able to strip out numeric data from alphanumeric source data.    So for example, WildDCast could be used to turn Alphanumeric Geo-Coordinates into decimal coordinates ready for use in calculations:

Likewise, WildICast can be used to filter out any non-numeric data from a field: