Main page /  Useful info about ShapeSheet™  / Visio ShapeSheet reference / ShapeSheet™. List of functions by category

ShapeSheet. Category String functions

Note

This table contain only functions which included in table for similar category in the book MS Visio 2003 Developer’s Survival Pack by Graham Wideman (see chapter 37).

The version information in which the function was added is taken from John's Goldsmith article Visio ShapeSheet Functions by Version

Name

Details

BLOB

Version Added: 2003

Decodes a base64 string and stores it as binary data.

Syntax

BLOB (bintext)

Read more about function BLOB

CHAR

Version Added: Pre 2003

Returns the ANSI character for a number.

Syntax

CHAR(number)

Read more about function CHAR

DECIMALSEP

Version Added: Pre 2003

Returns the decimal separator string for the current user locale.

Syntax

DECIMALSEP( )

Read more about function DECIMALSEP

EVALTEXT

Version Added: Pre 2003

Evaluates the text in shapename as if it were a formula and returns the result.

Syntax

EVALTEXT(shapename!theText)

Read more about function EVALTEXT

FIELDPICTURE

Version Added: Pre 2003

Returns a format-picture string that matches the Microsoft Visio internal text field format code.

Syntax

FIELDPICTURE(code)

Read more about function FIELDPICTURE

FIND

Version Added: 2003

Finds one text string contained within another text string, and returns the starting position of the text string you are seeking relative to its position in the text string that contains it.

Syntax

FIND (find_text, within_text ,[start_num], [ignore_case])

Read more about function FIND

FORMAT

Version Added: Pre 2003

Returns the result of expression as a string formatted according to formatpicture.

Syntax

FORMAT(expression,"formatpicture")

Read more about function FORMAT

FORMATEX

Version Added: Pre 2003

Returns the result of expression evaluated in srcUnit as a string formatted according to format expressed in dstUnit.

Syntax

FORMATEX(expression,"format",[srcUnit],[dstUnit],[langID][,calID])

Read more about function FORMATEX

INDEX

Version Added: Pre 2003

Returns the substring at the zero-based location index in the list delimited by delimiter. Or, if the index is out of range, returns an empty string or the optional token provided as the errorvalue argument.

Syntax

INDEX(index,"list"[,[delimiter][,[errorvalue]]])

Read more about function INDEX

LEFT

Version Added: 2003

Returns the left-most character or characters in a text string, based on the number of characters you specify.

Syntax

LEFT(text, [,num_chars_opt])

Read more about function LEFT

LEN

Version Added: 2003

Returns the number of characters in a text string.

Syntax

LEN (text)

Read more about function LEN

LISTSEP

Version Added: Pre 2003

Returns the list-separator string for the current user locale.

Syntax

LISTSEP ()

Read more about function LISTSEP

LOOKUP

Version Added: Pre 2003

Returns a zero-based index that indicates the location of the substring key in a list, or returns -1 if the target string contains the delimiter.

Syntax

LOOKUP("key","list"[,"delimiter,")

Read more about function LOOKUP

LOWER

Version Added: Pre 2003

Returns a string converted to lowercase.

Syntax

LOWER(expression)

Read more about function LOWER

MID

Version Added: 2003

Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

Syntax

MID (text, start_num, num_chars)

Read more about function MID

REPLACE

Version Added: 2003

Replaces part of a text string, based on the number of characters you specify, with a different text string.

Syntax

REPLACE (old_text, start_num, num_chars, new_text)

Read more about function REPLACE

REPT

Version Added: 2003

Repeats text a given number of times.

Syntax

REPT (text, number_times)

Read more about function REPT

REWIDEN

Version Added: 2003

Converts a formula that produces 16-bit character codes that are widened single-byte or multibyte character-set codes into a string of 16-bit Unicode character codes, using the specified character sets.

Syntax

REWIDEN(srcCharSet, dstCharSet, text)

Read more about function REWIDEN

RIGHT

Version Added: 2003

Returns the last character or characters in a text string, based on the number of characters you specify.

Syntax

RIGHT(text [,num_chars_opt])

Read more about function RIGHT

STRSAME

Version Added: Pre 2003

Determines whether strings are the same. It returns TRUE if they are the same and FALSE if they aren't.

Syntax

STRSAME ("string1", "string2", ignoreCase)

Read more about function STRSAME

STRSAMEEX

Version Added: Pre 2003

Determines whether two strings are the same.

Syntax

STRSAMEEX ("string1", "string2", localeID, flag)

Read more about function STRSAMEEX

SUBSTITUTE

Version Added: 2003

Replaces part of a text string with a different text string.

Syntax

SUBSTITUTE (text, old_text, new_text[, start_num][,ignore_case_opt)

Read more about function SUBSTITUTE

TRIM

Version Added: 2003

Removes all space from text, except for single spaces between words.

Syntax

TRIM (text)

Read more about function TRIM

UNICHAR

Version Added: 2003

Returns the Unicode character from a number.

Syntax

UNICHAR (number)

Read more about function UNICHAR

UPPER

Version Added: Pre 2003

Returns a string converted to uppercase.

Syntax

UPPER(expression)

Read more about function UPPER