Difference between revisions of "Excel to Analytica Mappings/Text and Data Functions"
| Line 1: | Line 1: | ||
This page show how Excel Text and Data functions map to Analytica equivalents | This page show how Excel Text and Data functions map to Analytica equivalents | ||
| − | = ASC = | + | = ASC(text) = |
| − | = BAHTTEXT = | + | |
| − | = CHAR = | + | Analytica's [[Asc]] function is ''not'' an equivalent to Excel's ASC function. Excel's ASC function converts double-byte character sets to single-byte character sets. Analytica has no support for double-byte character sets. |
| − | = CLEAN = | + | |
| − | = CODE = | + | = BAHTTEXT(number) = |
| − | = CONCATENATE = | + | |
| − | = | + | Analytica does not contain support the Thai (Baht) language. |
| − | = EXACT = | + | |
| − | = | + | = CHAR(number) = |
| − | = FINDB = | + | |
| − | = FIXED = | + | Analytica equivalent: |
| − | = JIS = | + | [[Chr]](number) |
| − | = LEFT = | + | |
| − | + | = CLEAN(x) = | |
| − | = LEN = | + | |
| − | + | = CODE(text) = | |
| − | = LOWER = | + | |
| − | = MID = | + | Analytica equivalent: |
| − | + | [[Asc]](text) | |
| + | |||
| + | = CONCATENATE(text1,text2,...) = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | text1 & text2 & ... | ||
| + | |||
| + | Also: | ||
| + | [[Join]](A,I) | ||
| + | |||
| + | = DOLLAR(number'',decimals'') = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | "" & number | ||
| + | where the number format for the variable where this expression appears is set to currency with the indicated number of digits. | ||
| + | |||
| + | = EXACT(text1,text2) = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | text1 = text2 | ||
| + | |||
| + | = FIND(find_text,within_text'',start_num''), FINDB(find_text,within_text'',start_num'') = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | [[FindInText]](find_text,within_text'',start_num'') | ||
| + | |||
| + | = FIXED(number'',decimals,no_commas'') = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | "" & number | ||
| + | where the number format for the current variable is set to fixed format with the indicated number of decimals, and thousands separators checked or unchecked as desired. | ||
| + | |||
| + | = JIS(text) = | ||
| + | |||
| + | No Analytica equivalent, since Analytica does not support double-byte characters. | ||
| + | |||
| + | = LEFT(text'',num_chars''), LEFTB(text'',num_chars'') = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | [[SelectText]](text,1,num_chars) | ||
| + | |||
| + | = LEN(text), LENB(text) = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | [[TextLength]](text) | ||
| + | |||
| + | = LOWER(text) = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | [[TextLowerCase]](text) | ||
| + | |||
| + | = MID(text,start_num,num_chars), MIDB(text,start_num,num_chars) = | ||
| + | |||
| + | Analytica equivalent: | ||
| + | [[SelectText]](text,start_num,start_num + num_chars - 1) | ||
| + | |||
= PHONETIC = | = PHONETIC = | ||
= PROPER = | = PROPER = | ||
| Line 33: | Line 88: | ||
= TEXT = | = TEXT = | ||
= TRIM = | = TRIM = | ||
| − | = UPPER = | + | = UPPER(text) = |
| + | |||
| + | Analytica equivalent: | ||
| + | [[TextUpperCase]](text) | ||
| + | |||
= VALUE = | = VALUE = | ||
Revision as of 00:06, 12 January 2008
This page show how Excel Text and Data functions map to Analytica equivalents
ASC(text)
Analytica's Asc function is not an equivalent to Excel's ASC function. Excel's ASC function converts double-byte character sets to single-byte character sets. Analytica has no support for double-byte character sets.
BAHTTEXT(number)
Analytica does not contain support the Thai (Baht) language.
CHAR(number)
Analytica equivalent:
Chr(number)
CLEAN(x)
CODE(text)
Analytica equivalent:
Asc(text)
CONCATENATE(text1,text2,...)
Analytica equivalent:
text1 & text2 & ...
Also:
Join(A,I)
DOLLAR(number,decimals)
Analytica equivalent:
"" & number
where the number format for the variable where this expression appears is set to currency with the indicated number of digits.
EXACT(text1,text2)
Analytica equivalent:
text1 = text2
FIND(find_text,within_text,start_num), FINDB(find_text,within_text,start_num)
Analytica equivalent:
FindInText(find_text,within_text,start_num)
FIXED(number,decimals,no_commas)
Analytica equivalent:
"" & number
where the number format for the current variable is set to fixed format with the indicated number of decimals, and thousands separators checked or unchecked as desired.
JIS(text)
No Analytica equivalent, since Analytica does not support double-byte characters.
LEFT(text,num_chars), LEFTB(text,num_chars)
Analytica equivalent:
SelectText(text,1,num_chars)
LEN(text), LENB(text)
Analytica equivalent:
TextLength(text)
LOWER(text)
Analytica equivalent:
TextLowerCase(text)
MID(text,start_num,num_chars), MIDB(text,start_num,num_chars)
Analytica equivalent:
SelectText(text,start_num,start_num + num_chars - 1)
PHONETIC
PROPER
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TRIM
UPPER(text)
Analytica equivalent:
TextUpperCase(text)
Enable comment auto-refresher