Skip to main content
Version: 10.1

USFormat.CharRemoveIOFormat

note

This article is about the CharRemoveIOFormat method of the USFormat internal component.

USFormat.CharRemoveIOFormat​

Removes a string format, using the string IO format pattern for the format to be removed.

Returns the result of the operation as a string.

Syntax

SELECT USFormat.CharRemoveIOFormat(
    *string*
,   *string-io-format-pattern*
)

Both string and string-io-format-pattern are required. String-io-format-pattern must be one of the USoft IO formats for string values.

Example

SELECT USFormat.CharRemoveIOFormat(
         '12-MAR-2019'
,        '99-XXX-9999'
)

The return value of this statement is:

12MAR2019