Conversion Codes

Kourier Integrator Online Help

Import Conversion and Validation

Import Conversion and Validation codes can be used to convert a data value, such as a date or time into the internal U2 representation of the data value or to validate that a data value meets a specified import edit. If the data value does not conform to the import edit, an application error will be returned.

You may specify one or more conversion codes by separating each conversion code by the pipe (|) character. If you use multiple conversion codes, the codes are applied from left to right, so that the leftmost code is applied to the original value, then the next conversion code to the right is applied to the result of the first conversion, and so on. Generally, conversion codes are identical to those used in the ICONV functions of UniBASIC.

Conversion Type

Description - Usage - Notes

Conversion

These conversions are used to convert incoming data to other format. See the example data below and the result of applying the conversion code.

Conversion	Example	Result	Comment
D	11-17-1956	4092	Converts a date into the internal U2 representation of a date
MCU	HelloWorld	HELLOWORLD	Converts the data value to uppercase.
MR[n[m] or MD[n[m]	See Below		Converts a number into the internal U2 representation of the number. n indicates the number of implied decimal places. m indicates the power of 10 to scale the number.
MR2	123.4567	12346	The number was rounded to two decimal places and the excess digits were truncated.
MR24	123.45678	1234568	Then decimal place was moved 4 positions to the right and the last required decimal place was rounded off and excess digits were truncated.
MT	10:15:32	36932	Converts a time into the internal U2 representation of a time.
UBOOLEAN			Converts a value like "Y" or "N" to the string "true" or "false".
UCHANGE;str1;str2			Change str1 to str2. Change strings may contain one or more printable characters. Non-printable characters may be entered using "0x" notation.
UTRIM	●HI●●JOE●	HI●JOE	Removes all leading, trailing and redundant spaces (shown as ●) in the data value.
UTRIMB	●HI●●JOE●	●HI●●JOE	Removes all trailing spaces (shown as ●) in the data value.
UTRIMF	●HI●●JOE●	HI●●JOE●	Removes all leading spaces (shown as ●) in the data value.
UVLIST	1” “2” “3”	1]2]3	Converts a U2 value list expression into a multivalued string.

Validation

These conversions are used to validate that the incoming data is of the correct type or format. See the example data below and the result of applying the validation code.

Conversion	Example	Result	Comment
UALPHA	Main Street	Main Street	Verifies that the data value contains only alpha characters or a space.
UALPHANUMERIC	10 Main Street	13:53:20	Verifies that the data value contains only alpha characters, the numbers 0 thru 9 or a space.
UDATE			Verifies that the data value is a valid date.
UEDIT	KMK.Z92(VALUE, XACTION, ERR.TXT)		Used to create user-defined edits that can be specified in the "Edits" field for query parameters and import fields.
UFILE;filename[;amc;oper;value]	CUSTOMER	01:53pm	Verifies the data value exists in the filename specified. If the optional amc, oper, and value parameters are specified, then the contents of the amc are compare to the value using the oper and if that expression evaluates to true the data value is considered valid.
UFILELOOKUP;filename;controlID,amc	UFILELOOKUP;KT_INTEGRATION_XREF;DEMO*LOG_ERR_TYPE;1		Verifies that the data value exists in the amc of the controlID in the filename specified.
UITRANS;lookup_key	MASTERCARD	M/C	Integration translate replaces the current data value with the value found in the lookup table referenced by the lookup_key. This edit only executes if the current data value is a non-null string. The lookup_key is the item-id of the record in the KT_INTEGRATION_XREF file.
UOPEN,filename			This verifies that the file specified in filename can be opened.
UNOSPACE	●HI●●JOE●	●HI●●JOE●	Verifies that the data value does not contain a space (shown as ●). For the example data shown this would have generated an error.
UMATCH;val1;val2			Verifies that the data value matches the value specified in val1 - valn.
UNUMERIC	123456	123456	Verifies that the data value is numeric.
UTIME			Verifies that the data value is a valid time.
UURL			Verifies that the data entered only contains legal URL characters.