KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q189847: INFO: New String and Format Functions in Visual Basic 6.0

Article: Q189847
Product(s): Microsoft Visual Basic for Windows
Version(s): 
Operating System(s): 
Keyword(s): kbGrpDSVB
Last Modified: 11-JAN-2001

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual Basic Learning Edition for Windows, version 6.0 
- Microsoft Visual Basic Professional Edition for Windows, version 6.0 
- Microsoft Visual Basic Enterprise Edition for Windows, version 6.0 
-------------------------------------------------------------------------------

SUMMARY
=======

This article is a summary of the new string and format functions available in
Visual Basic version 6.0.

MORE INFORMATION
================

New Array Functions
-------------------

Join Function - concatenates a one-dimensional array into a delimited string.

Split Function - separates a delimited string into a zero-based, one- dimensional
array.

Replace Function - replaces a specified substring within a specified string with
a new substring a specified number of times.

Filter Function - returns a zero-based array containing a subset of a string
array based on a specified filter criteria.

New String Functions
--------------------

InStrRev Function - returns the position of a specified string within a string,
from the end of the string.

StrReverse - returns a string that has the character order of a specified string
reversed.

New Formatting Functions
------------------------

FormatCurrency - returns an expression formatted as a currency value using the
currency symbol defined in the system control panel.

FormateDateTime - returns an expression formatted as a date or time.

FormatNumber - returns an expression in a specified number format. You can use
this function to display negative numbers in parenthesis, the number of digits
after a decimal point, or to display leading zeros for fractional numbers.

FormatPercent - returns an expression formatted as a percentage (multiplied by
100) with a trailing % character.

Other New Functions
-------------------

WeekDayName Function - returns a string indicating the specified day of the
week.

MonthName Function - returns a string indicating the specified month of the
year.

CallByName Function - executes a specified method, sets a property, or returns a
property of a specified object.

Round Function - rounds a number to a specified number of digits after the
decimal place. This function uses business rather than arithmetic rounding
rules.

REFERENCES
==========

For more information about using these functions and the required parameters,
see the appropriate topics in the Visual Basic documentation.

Additional query words: kbDSupport kbDSD kbbeta kbVBp600 kbVBp kbUsage

======================================================================
Keywords          : kbGrpDSVB 
Technology        : kbVBSearch kbAudDeveloper kbZNotKeyword6 kbZNotKeyword2 kbVB600Search kbVBA600 kbVB600
Issue type        : kbinfo

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1986-2002.