Support > Repository > Function > String function
ja | en

We introduce 50 functions on string processing.

A1FORMAR7.1.3 |  ACCOUNTKANANORM |  ANORMPART |  ASC |  CONCATENATE |  COUNT |  EXACT |  FIND |  FINDTAIL |  FINDRE |  ISBLANK |  ISINCLUDE |  JIS |  JOIN |  JPKANANORM |  LEFT |  LEN |  LOWER |  LPAD |  LTRIM |  MAILADDRESS |  MATCHRE |  MATCHRE1 |  MID |  NUMTOJTEXT |  PADDING |  PATTERN |  PROPER |  RANDSTR |  REMOVEHTMLTAG |  REPLACE |  REPT |  RIGHT |  RPAD |  RTRIM |  SLICE |  SPLIR7.8 |  SUBSTITUTE |  TEXT |  TOBYTE |  TOSHORT |  TOINT |  TOLONG |  TOFLOAT |  TODOUBLE |  TOSTR |  TOSTR_ARRAY |  TRIM |  UPPER |  VALUE |  VALUE_ARRAY

A1 FORMAT (number)

Converts the number of the argument to Excel "A1 format" character string.The return value is a string type.

Input value Converted character string
0"" (Empty string)
1A
25Y
26Z
27AA
28AB
701ZY
702ZZ
703AAA
704AAB

ACCOUNTKANANORM (character string containing half-width kana characters)

We will normalize the account holder's name expressed in half-width kana.Search It can be applied to fluctuations or to name identification.The character string of the argument is a one-byte kana character string, and the return type is a normalized half-width kana character string.

The character string type item to which this function is appliedInput filter>>Please change it to one of one-byte (including blank).

ACCOUNTKANANORM(${hankaku-kananame})

Detailed conversion rules are as follows.

  • If there are multiple consecutive hyphens etc., put them together.
  • Normalize "V, D, D" to "B, Z, Z".
  • Remove the abbreviations of "KOKUYA", "KOKUYO CO., LTD."
    (* 2) Corresponding abbreviations are as follows.
    "Ka" "Yu." "Me" "Shi" "Ki" "" Ka "" Yu "" "
  • Remove the voiced point and semi-voiced point.
  • Convert lowercase letters (pronunciation/geminate) to capital letters.
  • Convert hyphen to vowel.
  • If the letters "a" ("o") are consecutive in the character string and the second character is "e" ("o"), "e" to "i" and "o" to ".
  • Delete single-byte blanks (spaces).

ANORMPART (address string, component)

Address Normalization ConverterBy extracting the elements separated from the address character string into prefectures, municipalities, municipalities, etc. by linking with them.Specific usage is "definition of model item> String - Collaboration with Address Normalization ConverterPlease read.

ANORMPART(${address}, "PREF")

The component part can do the following specification.(Please enclose the component name with double quotation marks.)

Designation of components Description
CTV_CODEMunicipal code
AREA_CODEPostal code
PREFName of prefectures
CTVCity name
AREATown area name
KOAZASmall letter/chome
BANCHI_GOStreet address
AREA_NUMBERLetter/chome + address number
NAMEBuilding name
CLASSBuilding floor
PREF_KName of prefecture (Kana)
CTV_KMunicipal name (Kana)
AREA_KTown area name (Kana)
KOAZA_KUnderwear name (Kana)
C_CTV_CODEMunicipal code (candidate)
C_AREA_CODEZip code (candidate)
C_PREFName of prefecture (candidate)
C_CTVCity name (candidate)
C_AREAPlace name (candidate)
C_PREF_KName of prefecture (Kana) (candidate)
C_CTV_KMunicipal name (Kana) (candidate)
C_AREA_KTown area name (Kana) (candidate)
C_KOAZA_KUnderwear name (Kana) (candidate)
C_KOAZALittle/chome (candidate)
C_BANCHI_GOStreet address (candidate)
C_AREA_NUMBERLetter/chome + address number (candidate)
C_NAMEBuilding name (candidate)
C_CLASSBuilding floor number (candidate)
· This function requires address normalization converter R5/R6 API option.
· "Candidate" is set as a candidate for the next point if more than one interpretation of the entered address is found.In other words, the candidate may not exist.
· The value of AREA_NUMBER is the same as the value of KOAZA and the value of BANCHI_GO connected by a hyphen (-).That is, you can use it when you want to handle KOAZA and BANCHI_GO all at once.
· For details on the handling of address information, please read the manual attached to the Address Normalization Converter product.

ASC (input character string)

Convert full-width character strings to half-width characters. Specifically, "alphabet" "number" "symbol" "katakana" is the target.

CONCATENATE (character string 1, character string 2, character string 3, ...)

Returns a concatenated string of argument strings. Multiple argument strings can be written, separated by commas.(There is no restriction on the number)

It is not possible to specify repeating items or repeated container items in the CONCATENATE argument.insteadJOINYou can use.

CONCATENATE(${str1}, ${str2})

An example Behavior
CONCATENATE("A") "A"
CONCATENATE("A", "B") "AB"
CONCATENATE("A", "", null, "B", "", "C") "ABC"

COUNT (string array)

Returns the length of the string array of arguments.If the argument is null, 0 is returned.

COUNT(${array_of_string_item})

EXACT (character string 1, character string 2)

We compare two strings.If it is the same, it returns true.Since the return type is a boolean value (true or false)IF functionYou can use it inside of.

EXACT(${item1}, ${item2})

An example Behavior
EXACT("ABC", "ABC") true
EXACT("ABC", "ABD") false

EXACT (date 1, date 2)

We will compare two dates.If it is the same, it returns true.Since the return type is a boolean value (true or false)IF functionYou can use it inside of.

EXACT(${date1}, ${date2})

Wagby internally uses Java.In Java, character strings and date matching can not be done with "==" operator.For example, the expression "item 1 ==" Yamada "is alwaysfalse.In order to avoid this problem, Wagby provides an EXACT function.Be sure to use the EXACT function to judge match between character string and date.

FIND (search character string, target, [start position])

Returns the position from the beginning of the search string.The return value type is integer type.Count from 1. If not found, it returns -1.

The starting position can be omitted.The default starting position is 1. Uppercase and lowercase letters are distinguished.You can not use wildcards.

FIND(${item1}, ${target}, ${pos})

An example Behavior
FIND ("City", "Okinawa Prefecture Uruma-shi Osaki 5th 1", 4) 7
FIND ("U", "Okinawa Prefecture Uruma-shi Osakazaki 5, 1") 4

FINDTAIL (search string, target)

Returns from the end of the target string the search string.Returns the position of the first character found from the end. The return value type is integer type. If not found, it returns -1.

FINDTAIL(${item1}, ${target})

An example Behavior
When the value of the character string type item urlitem is "file: /////server001/fileshare/catalog001.doc"

IF(NOT(ISBLANK(${urlitem})),
MID(${urlitem},FINDTAIL("/",${urlitem})+1),"")
catalog001.doc
When the value of the character string type item urlitem is "file: ///// server001 \ fileshare \ catalog001.doc"

IF(NOT(ISBLANK(${urlitem})),
MID(${urlitem},FINDTAIL("\\",${urlitem})+1),"")
catalog001.doc

FINDRE (search character string, target, [start position])

Returns the position from the beginning of the search string.The return value type is integer type. In the search character string partRegular expressionYou can specify.(Regular expression application rules are MATCHRE It is equivalent to.)

The starting position can be omitted. Uppercase and lowercase letters are distinguished.

FINDRE(${item1}, ${target}, ${pos})

An example Behavior
FINDRE ("w. + GbyR [0-9] \\. [0-9] \\. [0-9]", "AIUOO 12345 w 3 gby R 7. Abc") 11

ISBLANK (character string)

ISBLANK (date type)

ISBLANK (time type)

ISBLANK (date and time type)

Checks whether the argument is NULL or blank.Returns true if it is null or empty.Since the return type is a boolean value (true or false)IF functionYou can use it inside of.

ISBLANK(${item1})

An example Behavior
ISBLANK("    "); true
ISBLANK("   A"); false

ISINCLUDE (character string 1, character string 2)

Returns true if the value of the first argument contains any of the characters of the second argument. Since the return type is a boolean value (true or false)IF functionYou can use it inside of.

ISINCLUDE(${item1},${item2})

An example Behavior
ISINCLUDE("Hello,World!", "aiueo"); true
ISINCLUDE("Hello,World!", "xyz"); false

JIS (input character string)

Convert half-width character strings to full-width characters. Specifically, "alphabet" "number" "symbol" "katakana" is the target.

JOIN (string array)

JOIN (string array, delimiter)

Returns a string that is a concatenation of each element of a string array with a delimiter. If delimiter is not specified, "," is delimiter. If the delimiter is null, use the character string "0" of length 0 as the delimiter. If the string array is null, it returns a zero length string "".

Null is replaced with blanks.Also, delimiter characters for null elements are not output.
For example, if the argument is "Hokkaido", "Aomori", null, "Akita", the result of JOIN is "Hokkaido, Aomori, Akita".

JOIN(${array_of_string_item}, "#")

The function paired with JOIN isSPLITis.

JPKANANORM (character string containing kana characters)

Normalize voiced sounds, vibrant sounds to killing sounds.For example, the character string "Yamada" becomes "Yamata".The return type is a string type.

JPKANANORM(${kananame})

Detailed conversion rules are as follows.

Input characters: Vagagogego Zazizzo dadaedo de Babibu Vivo Papipipe Poipuroko
Output letter: Ukakikukenko Sasisse Syntax Tachitti Hahihae Hajikhoeho Ayueo Yayayakketsu

LEFT (character string, [number of characters])

It returns the character with the specified number of characters from the beginning (left end) of the character string.If the number of characters is omitted, it becomes 1.The return type is a string type.

LEFT(${item1}, ${num})

An example Behavior
LEFT("abcde", 3) "abc"

LEN (character string)

Returns the number of characters in the string.The return value type is integer type.

LEN(${item1})

An example Behavior
LEN("abcde") 5

LOWER (character string)

Converts uppercase letters of uppercase letters to lowercase letters.The return type is a string type.

LOWER(${item1})

An example Behavior
LOWER("HELLO, WORLD."); "hello, world."

LPAD (character string, specified number of digits)

LPAD (character string, specified number of digits, embedded character)

Insert an embedded character to the left of the character string until the specified number of digits is reached.If no embedded character is specified, a space is inserted.

LPAD(${item1}, 6, "0")

An example Behavior
LPAD("ABC", 6); "   ABC"
LPAD("ABC", 6, "0"); "000ABC"

LTRIM (string)

Remove the extra space (half-width, double-byte), tab, and new-line character included on the left side of the string.The return type is a string type.

LTRIM(${item1})

An example Behavior
LTRIM("   ABC"); "ABC"

MAILADDRESS (string)

MAILADDRESS (character array)

Extracts the mail address part from a character string representing a mail address conforming to the RFC 822 format. It is also possible to specify items of repeating items (character strings) as arguments.In this case, the return value is also a character array.

Input string result
Taro Yamada <yamada@foo.bar.com> yamada@foo.bar.com

MATCHRE (search character string, target character string)

Returns a partial character string matching the search character string from the target character string as a character string array. Regular expressions can be used for search strings.

MATCHRE(${searchitem}, ${targetitem})

Expression example JOIN(MATCHRE("(S|E)[0-9]+_[0-9]+$", ${item}), ",")
Example of input Item = "Jasmin Taro S2010_0401 \ n" + "E2010_ 0402 Jiro Kabasa Junior \ n" + "Mr. Hanako S2010 _ 0403"
result "S2010_0401,S2010_0403"
Description From the value of the argument item, an array of character strings matching the condition "beginning with 'S' or 'E', followed by one or more consecutive digits, an underscore, followed by a digit, and end of line" receive.In addition, this is used as an argument of the JOIN function, and it is a comma-separated character string.

Here, $ represents "end of line".In "E2010_ 0402 Juban Jiro Jiro \ n" in the above example, you can see that the condition does not match because "E2010 - 0402" is not the end of the line, but arbitrary characters are included.

MATCHRE 1 (search character string, target character string, [index], [group number])

Returns a partial character string matching the search character string from the target character string.If there are multiple partial character strings hitting the search character string, you can specify an index and obtain an arbitrary substring.(Index start number is 1)

Also, when grouping search patterns in parentheses in a regular expression, you can specify a group number and acquire a character string of an arbitrary group.Treat as 1 if index is omitted and 0 if group number is omitted.

Example: When the contents of the body of the body item in the model are

Customer ID: A0001 We are always indebted to the person in charge.
I have a question about Wagby's license.

Xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Customer ID: A0002 or higher, thank you.

An example Behavior
MATCHRE 1 ("^ (Customer | Customer) ID [] *: [] * (. *) $", $ {Body}) Customer ID: A0001
MATCHRE 1 ("^ (Customer | Customer) ID [] *: [] * (. *) $", $ {Body}, 0) Customer ID: A0001
MATCHRE 1 ("^ (Customer | Customer) ID [] *: [] * (. *) $", $ {Body}, 1) Customer ID: A0002
MATCHRE 1 ("^ (Customer | Customer) ID [] *: [] * (. *) $", $ {Body}, 1, 0) Customer ID: A0002
MATCHRE 1 ("^ (Customer | Customer) ID [] *: [] * (. *) $", $ {Body}, 1, 1) customer
MATCHRE 1 ("^ (Customer | Customer) ID [] *: [] * (. *) $", $ {Body}, 1, 2) A0002

MID (character string, start value, number of characters)

MID (character string, starting value)

Returns a character with the specified number of characters from an arbitrary position in the string.The position of the first character becomes 1.The return type is a string type.
If the third argument (number of characters) is omitted, all strings after the start value are returned.

MID(${item1}, ${begin}, ${length})

An example Behavior
MID("abcde", 2, 3) "bcd"
MID("abcde", 2) "bcde"

NUMTOJTEXT (number, delimiter pattern, character type)

NUMTOJTEXT (character string representing number, separator pattern, character type)

Convert numbers to Japanese text.The return type is a string.

There are four types of delimiter patterns.

  • 0: no delimiter pattern
  • 1: every three digits (thousands)
  • 2: million and 100 million units
  • 3: Ten, hundred, one thousand, ten thousand and one hundred million

There are four types of character pattern as follows.

  • 0: Half-width number
  • 1: Full-width number
  • 2: Chinese numerals (one, two, three)
  • 3: Old Kanji (I, II, participation)
An example Returned string
NUMTOJTEXT(123456789, 0, 0) "123456789"
NUMTOJTEXT(123456789, 1, 0) "123,456,789"
NUMTOJTEXT(123456789, 2, 0) "123.445 million 6789"
NUMTOJTEXT(123456789, 3, 0) "122, 3 450 567 78 9"
NUMTOJTEXT(123456789, 0, 1) "123456789"
NUMTOJTEXT(123456789, 1, 1) "123, 456, 789"
NUMTOJTEXT(123456789, 2, 1) "123.445 million 6789"
NUMTOJTEXT(123456789, 3, 1) "122, 3 450 567 78 9"
NUMTOJTEXT(123456789, 0, 2) "one two three four five six seven eight nine"
NUMTOJTEXT(123456789, 1, 2) "one two three four five six seven eight nine"
NUMTOJTEXT(123456789, 2, 2) "123,456,687"
NUMTOJTEXT(123456789, 3, 2) "122, 346, 667, 289"
NUMTOJTEXT(123456789, 3, 3) "One hundred twenty two thousand four hundred and four hundred fifty thousand six hundred and nine hundred eight nine"
NUMTOJTEXT("59234271", 3, 3) "Five thousand ninety hundred thousand four hundred thousand two hundred seventy picks"

PADDING (1 character to be filled, number of digits, character string)

Add "filling one character" before the argument string.Make it a character string within the range of "number of digits" as a whole. Enclose it in double quotes.(If two or more characters are specified, the first character is valid.)

PADDING (1 character to fill, number of digits, $ {item 1})

An example Behavior
PADDING("0", 6, ${item1}) "000123"
* When the value of $ {item 1} is "123"

PATTERN (input character string, pattern character string)

Returns how many pattern strings are included in the input string.

PATTERN ($ {item 1}, "East")

An example Behavior
PATTERN ("Tokyo and Kyoto", "Kyo") 2
PATTERN ("Tokyo and Kyoto", "Tokyo") 1

PROPER (string)

Converts the first letter of the alphabet to upper case letters and the second and subsequent letters to lower case letters.The return type is a string type.

PROPER(${item1})

An example Behavior
PROPER("hello, world.") "Hello, world."

RANDSTR (number of digits)

RANDSTR (number of digits, character string to exclude)

It generates a random character string consisting of uppercase letters, lowercase letters, and numbers.
The second argument specifies "excluded character string".If this argument is omitted, "iIl1Oo0" is specified by default as a character string to be excluded.This is a measure to increase visibility by removing similar characters.

If RANDSTR () is applied to an item A and another item B refers to the value of A, it is guaranteed that the value of B and the value of A are the same.
When RANDSTR () is used more than once in a certain item A, the result of the first RANDSTR () and the result of the second and subsequent RANDSTR () have the same value.

RANDSTR(8)

An example Behavior
RANDSTR(8, "0123456789") Generate an 8-digit random character string excluding numbers.
RANDSTR(8, "") Since we specified an empty string as empty, we generate a random character string for all strings.

REMOVEHTMLTAG (target character string)

REMOVEHTMLTAG (target character string, line feed code)

Remove the HTML tags contained in the string.The return type is a string type.
The br tag is replaced with a line feed code.If the second argument is omitted, "\ r \ n" is used as the line feed code.(Windows standard).You can also specify "\ r" (Mac) or "\ n" (Linux) individually.

REMOVEHTMLTAG(${richtextitem})

REPLACE (target character string, starting position, number of characters, [substitution character string])

Remove the specified number of characters in the string.Replacement strings can be omitted.The return type is a string type.

REPLACE(${target}, ${start}, ${len}, ${replace})

An example Behavior
When s = "AIUEOO"
REPLACE(s,1,1)
"..."
When s = "Kakikoko"
REPLACE(s,1,2)
"Kukko"
When s = "Sasashiso"
REPLACE(s,2,2)
"What is it?"

REPT (character string, repeat count)

Repeatedly display the character string a specified number of times.The return type is a string type.

REPT(${item1}, ${count})

An example Behavior
REPT("*", 5) "*****"

RPAD (character string, specified number of digits)

RPAD (character string, specified number of digits, embedded character)

Insert embedding characters to the right of the character string until the specified number of digits is reached.If no embedded character is specified, a space is inserted.

RPAD(${item1}, 6, "0")

An example Behavior
RPAD("ABC", 6); "ABC   "
RPAD("ABC", 6, "0"); "ABC000"

RTRIM (character string)

Remove the extra space (half-width, double-byte), tab, and new-line character included on the right side of the string.The return type is a string type.

RTRIM(${item1})

An example Behavior
RTRIM("ABC   "); "ABC"

SLICE (character array, index)

Returns the element specified by the index from the string array of arguments.The return value is a string type. If the input string array is null, or the index indicates a value beyond the string array, it returns a zero length string "".

SLICE(${array_of_string_item}, 0)

An example Behavior
Array = "Hokkaido", "Aomori", "Akita"
SLICE(array, 0)
"Hokkaido"
Array = "Hokkaido", "Aomori", "Akita"
SLICE(array, -1)
""
Array = "Hokkaido", "Aomori", "Akita"
SLICE(array, 3)
""
array = null
SLICE(array, 0)
""

SPLIT (target character string)

SPLIT (target character string, delimiter character)

Divide the target character string by delimiter.When the delimiter is omitted, the space is taken as a delimiter.The return type is an array of strings.

For each delimited character string,LTRIMWhenRTRIMWill be applied.For this reason, leading and trailing blanks are deleted.

SPLIT(${target})
SPLIT(${target}, ",")
An example Behavior
SPLIT(" a  , bc,  d  , efg  ", ",") a
bc
d
efg

A function paired with SPLITJOINis.

Specify multiple delimiters7.11

You can specify multiple delimiters.In the following example, both "," and ";" are treated as delimiters.

SPLIT(${target}, ",;")

SUBSTITUTE (target character string, search character string, replacement character string)

Find the search character string from the character string and replace it with the substitution character string.The return type is a string type.

SUBSTITUTE(${target}, ${str}, ${replace})

An example Behavior
S = "Okinawa Prefecture Naha city"
LEN (s) - LEN (SUBSTITUTE (s, "prefecture", ""))
1
When s = "Okinawa Prefecture Okinawa City"
LEN (s) - LEN (SUBSTITUTE (s, "Oki", ""))
2

TEXT (number)

TEXT (number, format)

TEXT (date, format)

Converts a number (or date serial number) and date type to a formatted string.

If you do not specify the format of the second argument,TOSTRIt has the same behavior as the function.

TEXT(${item1}, "yyyy-MM-dd")

TEXT(1234, "#,###") "1,234"
TEXT(3.33333, "0.0") "3.3"
TEXT(0.1234, "0.0%") "12.3%"
TEXT(0.00001, "0.0E0") "1.0E-5"
TEXT(1234, "\\#,####") "\\1,234"
TEXT(${date}, "yyyy-MM-dd"); "2000-01-01"
* When the value of $ {date} is 2000-1-1.
TEXT ($ {date}, "MY MONTH DAY YYYY") "January 1, 2000"
* When the value of $ {date} is 2000-1-1.
TEXT ($ {date}, "{0} {1, number, integer} year {2, number, integer} month {3, number, integer} days") "January 1, Heisei 28"
* When the value of $ {date} is 2016 - 1 - 1.
(Please read "Supplement for Japanese Calendar" for details.)
TEXT(${time}, "HH:mm") "15:05"
* When the value of $ {time} is 15: 05: 55.To represent the time in 24 hours, use uppercase "H".
Excel has the designation "[h]: mm" for expressing more than 24 hours, but it is not supported by Wagby.
TEXT(${time}, "h:m:s") "3:5:55"
* When the value of $ {time} is 15: 05: 55.
TEXT(${time}, "ahh:mm") "12:00 PM"
* When the value of $ {time} is 00: 00: 00."Am" can display "am/pm".

Supplement for Japanese Calendar

The rules of the Japanese calendar format are as follows.

How to specifyDescription
{0} or {5}Year (Meiji, Taisho, Showa, Heisei)
{6}Year (Ming, Dai, Akira Ping)
{7}Year (M, T, S, H)
{1,number,integer}Year
{2,number,integer}Month
{3,number,integer}Day

Application example: Acquire the "year" part of the date as a character string of "Hxx" format

Combine with the FISCALYEAR function.Item1 is a date type item.

TEXT(DATEVALUE(CONCATENATE(TOSTR(FISCALYEAR(${item1})),"-1-1")),"{7}{1,number,integer}")

TOBYTE (character string)

Converts a string-represented number to a 1-byte integer.Specifically, it converts the character string "1" to 1.

TOSHORT (character string)

Converts a string-represented number to a 2-byte integer.

TOINT (character string)

Converts a character string representation number to an integer type (4-byte integer).

TOLONG (character string)

Converts a character string representation number to an 8-byte integer.

TOFLOAT (character string)

Converts a string-represented number to a 4-byte floating-point number.

TODOUBLE (character string)

Converts a string representation number to an 8-byte floating point number.

TOSTR (number)

TOSTR (date)

Converts a numeric/date type value to a string type.TEXTUnlike functions, format specification can not be performed. It can be used for the purpose of setting calculation result to character type item.

TOSTR(${num}+1)

TOSTR_ARRAY (numeric array)

Convert base type array to string type array.Applicable to repetitive items, checkbox items, etc.

TRIM (character string)

Remove extra space (half-width, double-byte), tab, and new-line character from the string.All leading blanks are deleted.Leave one blank space between characters.The return type is a string type.

The processing flow is LTRIMWhenRTRIM And combine multiple blank characters into one character.

TRIM(${item1})

An example Behavior
TRIM("   ABC"); "ABC"
TRIM("  A B C ") "A B C"
TRIM("   A  B  C   ") "A B C"

UPPER (character string)

Convert lowercase letters of uppercase letters to uppercase letters.The return type is a string type.

UPPER(${item1})

An example Behavior
UPPER("hello, world."); "HELLO, WORLD."

VALUE (string)

VALUE (string, default value)7.4

Converts a string representing a numeric value to a numeric value.The date and time strings are converted to date (time) serial values.The return type is 8 byte floating point type.

If the first argument string is null or an unparsable value, the default value is used.When it is omitted, it becomes Double.NAN (indeterminate).The default value can be given as the second argument.The type is an 8-byte floating point number.

VALUE(${item1})
VALUE(${item1}, 0.0)
VALUE("0.12") 0.12
VALUE("1,234") 1234
VALUE("1,234.567") 1234.567
VALUE("1,23E-4") 0.000123
VALUE("12%") 0.12
VALUE("15:30") 0.645833
VALUE("2000-01-01 12:34:56") 36526.52426
VALUE ("January 1, 2000") 36526

VALUE_ARRAY (array of strings)

It behaves the same as VALUE, but passes an array of strings as an argument.The return type is an array of 8 byte floating point type.