![]() This means that results will be compatible for use in combination with other zero-based functions, such as Mid(), for example.įind(John LenNon, N, 0, 0) A case insensitive search for N, from the start, where "J" is counted as zero. When a match is found, the result returned is 'zero-based', meaning that if the result is zero, that points to the first character in "Search". Regardless of where in "Search" "Start" is initiated, the result is always zero-based, counting from the first character in "Search". If no match is found, the function returns a value of -1 These can be combined, so, a "Flags" value of 3 would perform a case sensitive search from the end of the string. 0 performs a case-insensitive search from the start of the string, 1 performs a case sensitive search from the start of the string and 2 performs a case insensitive search from the end of the string. This is ignored if searching from the end of the string. "Start" specifies numerically, where in the string the function should begin working. "Find" is the character or string you wish to locate within the "Search" value. "Search" is the string to be searched and can be a literal given string, library field, or nested expression result. Argument Flags is optional (defaults to 0).Argument Start is optional (defaults to 0).( Back to top) ( Function index) Find(…) Finds a string or character in another string, returning its zero-based position in that string. Mode 104 - "Everything after, but not including, with case-sensitivity" Vivace and is Bach, this returns:īach\Flac\Concertos for Orchestra\Concerto for 2 Harpsichords - BWV 1062: I. Where is \\NAS\Share1\Music\CD\Bach\Flac\Concertos for Orchestra\Concerto for 2 Harpsichords - BWV 1062: I. Mode 3 - "Everything after, and including" Mode 6 - "Everything between, but not including" Ouverture, this returns: Orchestral Suite No. Mode 2 - "Everything up to, but not including" String2 is only required when using modes 5, 6, 105 or 106, and can be a library field, an expression result, or a literally given string. String1, like Mode, is always required, and can be a library field, an expression result, or a literally given string. SourceString can be a library field, an expression result, or a literally given string. If case sensitivity is desired, add 100 to the chosen mode value. Returns everything between, but not including, String1 and String2Īll of the modes above are case-insensitive. Returns everything between, and including, String1 and String2 Returns everything after, but not including, String1 Returns everything after, and including, String1 Returns everything up to, but not including, String1 Returns everything up to, and including, String1 This example would produce the filesystem-safe value of AC_DC_ Back In Black.Ĭlean(\//:*?"|, 3) This trivial example demonstrates how all filesystem-illegal characters are converted to underscores, producing the nine-character output _ which consists entirely of underscores. Clean() in mode 3 will convert such characters into safe underscores. Clean() in mode 1 provides a convenient solution, and in this example produces Beatles.Ĭlean(AC//DC: Back In Black, 3) When an expression is to be used to produce a filename, filesystem-illegal characters must be removed or converted to legal characters. Clean() in the default mode removes this dangling string.Ĭlean(The Beatles, 1) For sorting or grouping purposes, it is often desirable to remove the leading article The from a string. Standardises quotes, replacing “ and ” with " and also, ‘ and ’ with 'Ĭlean( - ) The concatenation of - may leave a dangling - string when date is empty. Replaces each filesystem-illegal character, allowing backslashes, / : * ? " with an underscore _, and replaces each unprintable character with a space. Replaces each filesystem-illegal character \ / : * ? " with an underscore _, and replaces each unprintable character with a space. ![]() Removes any article (a, an, the, etc.) from the beginning and end. Removes the article 'the' from the beginning and ', the' from the end. Removes empty () and, superfluous dash (-) and whitespace characters and sometimes comma (be careful). However, It may be used for a variety of purposes. It is typically employed before some operation such as Rename to clean the product of joining various fields, some of which may be empty, or to produce filesystem-safe filenames. The Clean() function is generally used to sanitize a string by stripping empty brackets, remove superfluous dash characters, eliminate leading or trailing articles, or replace filesystem-illegal characters. Argument mode is optional (defaults to 0).Clean(…) Clean a string to be used for various operations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |