Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

StrValue

Use this function to retrieve a string value from a data intersection and store it to another data intersection, or a string variable. This function will only return a string value for a DataArea if the user has access to that DataArea.

Note: This function will only return string data. If the intersection contains a numeric value, then the function will return an empty string ("").

Syntax

STRVALUE ("DataAreaName1", "SymName1", "SymName2", …, "SymNameN")

where:

  • DataAreaName is the name of the DataArea in which the symbols are found, and must be used in a procedure, enclosed in double quotation marks.
  • SymName is the name of a symbol, enclosed in double quotation marks.

Code example

SALEST### = STRVALUE ("DataArea1", "CASHT###", "Dim2Set", …, "Dim7Set")

SALEST### = STRVALUE ("", "CASHT###", "Dim2Set", …, "Dim7Set")

SET VARIABLE myString = STRVALUE ("DataArea1", "CASHT", "Dim2Set", …, "Dim7Set")
Published:

StrValue

Use this function to retrieve a string value from a data intersection and store it to another data intersection, or a string variable. This function will only return a string value for a DataArea if the user has access to that DataArea.

Note: This function will only return string data. If the intersection contains a numeric value, then the function will return an empty string ("").

Syntax

STRVALUE ("DataAreaName1", "SymName1", "SymName2", …, "SymNameN")

where:

  • DataAreaName is the name of the DataArea in which the symbols are found, and must be used in a procedure, enclosed in double quotation marks.
  • SymName is the name of a symbol, enclosed in double quotation marks.

Code example

SALEST### = STRVALUE ("DataArea1", "CASHT###", "Dim2Set", …, "Dim7Set")

SALEST### = STRVALUE ("", "CASHT###", "Dim2Set", …, "Dim7Set")

SET VARIABLE myString = STRVALUE ("DataArea1", "CASHT", "Dim2Set", …, "Dim7Set")
For an optimal Community experience, Please view on Desktop