DOCUMENT:Q189847  13-AUG-1998  [vbwin]
TITLE   :INFO: New String and Format Functions in Visual Basic 6.0
PRODUCT :Microsoft Visual Basic for Windows
PROD/VER:
OPER/SYS:WINDOWS
KEYWORDS:

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

 - Microsoft Visual Basic Learning, Professional, and Enterprise Editions
   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
======================================================================
Platform          : WINDOWS
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 1998.