* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *
This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
Description
Return the count of delimited (sub) fields in a string expression.
Syntax
n = PARSECOUNT(MainString, [ANY] StringSelimiter)
Returns
Number
Parameters
Name |
Type |
Optional |
Meaning |
MainString |
String |
No |
The string to be parsed. If StringExpression is empty or contains no delimiter character(s), the string is considered to contain exactly one field. In this case, PARSECOUNT returns 1. |
StringDelimiter |
String |
No |
Contains delimiter character(s). A delimiter is a character, list of characters, or string, that is used to mark the end of a field in MainString.
If the ANY is used, StringDelimiter contains a set of characters, any of which may act as a delimiter character. If the ANY keyword is omitted, the entire StringDelimiter string acts as a single delimiter. Delimiters are case-sensitive.
If StringDelimiter is an empty string, special rules apply. The delimiter is assumed to be a comma. Fields may optionally be enclosed in quotes. Such quotes are considered as special field delimiters and are not returned as part of the result string. Any characters that appear between a quote mark and the next comma delimiter character are discarded. If no leading quote is found, any leading or trailing spaces are trimmed before the result string is returned. |
Remarks
Restrictions
See also
Examples
