Difference between revisions of "STREXTRACT()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 11: | Line 11: | ||
The STREXTRACT() function extracts a string from <expC1> from between the delimiters specified in <expC2> and <expC3>. The occurrence to be extracted can also be specified. | The STREXTRACT() function extracts a string from <expC1> from between the delimiters specified in <expC2> and <expC3>. The occurrence to be extracted can also be specified. | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
− | !width=30%|Parameter||Description | + | !width="30%"|Parameter||Description |
|- | |- | ||
|<expC1>||The string to be searched | |<expC1>||The string to be searched | ||
|- | |- | ||
− | |valign=top|<expC2>||The start delimiter. If <expC2> is an empty string, the string is extracted from the start of <expC1> to the first occurrence of <expC3>. | + | |valign="top"|<expC2>||The start delimiter. If <expC2> is an empty string, the string is extracted from the start of <expC1> to the first occurrence of <expC3>. |
|- | |- | ||
− | |valign=top|<expC3>||The end delimiter. If omitted or empty, the string is extracted from <expC2> to the end of <expC1> | + | |valign="top"|<expC3>||The end delimiter. If omitted or empty, the string is extracted from <expC2> to the end of <expC1> |
|- | |- | ||
− | |valign=top|<expN1>||The occurrence of <expC2> at which to start the extraction. If omitted, the first occurrence is extracted. | + | |valign="top"|<expN1>||The occurrence of <expC2> at which to start the extraction. If omitted, the first occurrence is extracted. |
|- | |- | ||
|<expN2>||Optional flags (see below). | |<expN2>||Optional flags (see below). | ||
Line 28: | Line 28: | ||
====Settings:==== | ====Settings:==== | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
!width=15%|Bit||Width=15%|Value (additive)||Setting | !width=15%|Bit||Width=15%|Value (additive)||Setting | ||
|- | |- | ||
|0||1||Search is case-insensitive. | |0||1||Search is case-insensitive. | ||
|- | |- | ||
− | |valign=top|1||valign=top|2||End delimiter is not required. If <expC3> is specified, but not found, the string will be extracted from <expC2> to the end of <expC1> | + | |valign="top"|1||valign="top"|2||End delimiter is not required. If <expC3> is specified, but not found, the string will be extracted from <expC2> to the end of <expC1> |
|- | |- | ||
− | |valign=top|2||valign=top|4||The delimiters are included in the return string. | + | |valign="top"|2||valign="top"|4||The delimiters are included in the return string. |
|- | |- | ||
|} | |} | ||
Line 56: | Line 56: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] |
Revision as of 06:49, 4 February 2013
Purpose
Function to perform string extraction from between specified delimiters
Syntax
STREXTRACT(<expC1>, <expC2> [,<expC3>[,<expN1>[,<expN2>]]])
See Also
AT(), ATNEXT(), INLIST(), LEFT(), MTOS(), OCCURS(), RAT(), RIGHT(), RPAD(), SET STRESCAPE, STR(), STRTRAN(), STUFF(), SUBSTR()
Description
The STREXTRACT() function extracts a string from <expC1> from between the delimiters specified in <expC2> and <expC3>. The occurrence to be extracted can also be specified.
Parameter | Description |
---|---|
<expC1> | The string to be searched |
<expC2> | The start delimiter. If <expC2> is an empty string, the string is extracted from the start of <expC1> to the first occurrence of <expC3>. |
<expC3> | The end delimiter. If omitted or empty, the string is extracted from <expC2> to the end of <expC1> |
<expN1> | The occurrence of <expC2> at which to start the extraction. If omitted, the first occurrence is extracted. |
<expN2> | Optional flags (see below). |
Settings:
Bit | Value (additive) | Setting |
---|---|---|
0 | 1 | Search is case-insensitive. |
1 | 2 | End delimiter is not required. If <expC3> is specified, but not found, the string will be extracted from <expC2> to the end of <expC1> |
2 | 4 | The delimiters are included in the return string. |
Example
htmlstring1 = "<title>STREXTRACT()</title>" ? STREXTRACT(htmlstring1, "<title>", "</title>") STREXTRACT() ? STREXTRACT(htmlstring1, "<title>", "</title>",1,4) <title>STREXTRACT()</title> ? STREXTRACT(htmlstring1, "<", ">",2) /title
Products
Lianja, Lianja Server