Bookshelf Home | Contents | Index | PDF     

Siebel VB Language Reference > Using Siebel VB > About Formatting Strings >

Other Formatting Options

This topic describes other formatting options that you can use with the Set String Format method.

Changing Formatting Sequence

Siebel VB formats characters from left to right, by default. To format characters from right to left, you can include an exclamation point (!) in the format argument.

Changing Case

Siebel VB does not modify the case of characters that it formats, by default. To instruct Siebel VB to modify the case of a character, you can use the following characters:

  • < (Less than). Converts output characters to lowercase.
  • > (Greater than). Converts output characters to uppercase.

Handling Spaces That Occur in the Input String

Table 22 describes characters that you can use to handle spaces that occur in the input string.

Table 22. Characters You Can Use to Handle Spaces That Occur in the Input String
Character
Description

@

Siebel VB displays a character or a space according to the following logic:

  • If a character resides in the string in the position where the @ occurs in the format string, then it displays this character in this position
  • If no character resides in the string in the position where the @ occurs in the format string, then it displays a space in this position

&

Siebel VB displays a character or nothing according to the following logic:

  • If a character resides in the string in the position where the & occurs in the format string, then it displays this character in this position
  • If no character resides in the string in the position where the & occurs in the format string, then it displays nothing
      
Siebel VB Language Reference Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.