SoftadminUtil.Email_ValidateEmailAddresses

 Show all Hide all

This function can be used to check whether a given email address, or a separated list of email addresses, is formally valid.

If no separation should be done (i.e. when supplying only a single address) set the @separator parameter to null.

The function returns a resultset containing the parsed email addresses and their corresponding error codes together with descriptive error messages in both swedish and english.

Type: Table-valued function
Area of use: General use

Parameters:

@txt mandatory varchar(max)
Either a single email address or a separated list of email addresses.
@separator mandatory varchar(300)
The separator between email addresses.

Resultsets:

Resultset: @ReturnTable

Every element in the separated list is individually validated and returned on its own row in the return table.
Repeat mode: repeated exactly once
Row count: zero or more rows

Columns:

id mandatory int
An id representing the position of the parsed email address in the separated list.
EmailAddress mandatory string
The email address parsed from the separated list.
ErrorCode mandatory int
A formally valid email address has a return code of 0.
ErrorMessageSwe mandatory string
A descriptive error message in Swedish.
ErrorMessageEng mandatory string
A descriptive error message in English.