NewString := DELCHR(String[, Where][, Which])

Parameters

String

Type: Text constant or code

The input string.

Where

Type: Text constant or code

Specifies where to delete characters.

You can include one or more of the following characters in the Where string:

• =   To delete any character in String that matches a character in Which (default)
  
• <   To delete any leading character in String that matches a character in Which
  
• >   To delete any trailing character in String that matches a character in Which
  

Which

Type: Text or code

Specifies the characters that you want to delete.

The default is a space character.

Type: Text constant or code

The resulting string.

The DELCHR function is case-sensitive.

If you omit the Which parameter, then the function deletes spaces from String based on the contents of the Where parameter as follows:

• If Where contains =, then all the spaces are deleted from String.
  
• If Where contains <, then all the spaces at the start of String are deleted.
  
• If Where contains >, then all the spaces at the end of String are deleted.
  
• If Where contains any other character, then an error is returned.
  
• If Where is empty, then String is returned unchanged.
  

If you use the Where and the Which parameters, then the function deletes from String the characters that are contained in the Which parameter based on the contents of the Where parameter as follows:

• If Where contains =, then every occurrence of the characters in Which are deleted from String.
  
• If Where contains <, then the characters in Which are only deleted if they occur at the start of String.
  
• If Where contains >, then the characters in Which are deleted only if they occur at the end of String.
  
• If Where contains any other character, then an error is returned.
  
• If Where is empty, then String is returned unchanged.
  
• If Which is empty, then String is returned unchanged.
  

The Which parameter contains an array of the characters that you want to delete. The order of the characters is of no significance. If String contains a character that is specified in Which, it is deleted from String.

This example requires that you create the following variables and text constants in the C/AL Globals window.

	Copy Code
String := Text000; Where := '<>'; Which := 'Ws'; NewString := DELCHR(String, Where, Which); MESSAGE(Text001, String,NewString);

The message window displays the following:

>Windy West Solutions< is transformed to >indy West Solution<

The function deletes every W and s that is either the first or last character in String.

This example requires that you create the following variables and text constants in the C/AL Globals window.

	Copy Code
String := Text000; Where := '='; Which := 'sx'; NewString := DELCHR(String, Where, Which); MESSAGE(Text001, String,NewString);

The message window displays the following:

>This is an example< is transformed to >Thi i an eample<

The function deletes every s and x from String.

This example requires that you create the following variables and text constants in the C/AL Globals window.

	Copy Code
String := Text000; Where := '>'; Which := 'Tely'; NewString := DELCHR(String, Where, Which); MESSAGE(Text001, String,NewString);

The message window displays the following:

>This is an example< is transformed to >This is an examp<

If T, e, l, or y is the last character in String, the function deletes them.

This example requires that you create the following variables and text constants in the C/AL Globals window.

	Copy Code
String := Text000; Where := '<'; Which := 'This'; NewString := DELCHR(String, Where, Which); MESSAGE(Text001, String,NewString);

The message window displays the following:

>This is an example< is transformed to >an example<

If T, h, s, i, or space is the first character in String, the function deletes them.

This example requires that you create the following variables and text constants in the C/AL Globals window.

	Copy Code
String := Text000; Where := '<'; NewString := DELCHR(String, Where); MESSAGE(Text001, String,NewString);

The message window displays the following:

> This is an example< is transformed to >This is an example<

The function removes any spaces from the start of String.

Reference