GENERATE_SNOW_FIELD_NAME Function

This function is intended for use when migrating tables and fields from one Service Now instance to another, particularly where the source field names do not conform to the naming conventions for Service Now Table migrations.

Parameters (fieldName String);

Returns: String;

Characters in the string entered as a paramater are changed as follows:

• German characters (ä ö ü ß) are replaced with their ASCII equivelents (a o u s)
• Any other characters other than a-z, A-Z or 0-9 are replaced with an underscore
• Double underscores are replaced with a single underscore
• Terminaring underscores are removed
• upper case characters are changed to lower case

The resulting string is returned, this string will conform with Service Now naming conventions.

Examples

GENERATE_SNOW_FIELD_NAME('Hello World!') = hello_world

GENERATE_SNOW_FIELD_NAME('Hello!! World!!') = hello_world

GENERATE_SNOW_FIELD_NAME('Straße') = strase