Difference between revisions of "EXPLODE()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) (→Example) |
||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to separate a string into the elements of an array | Function to separate a string into the elements of an array | ||
| − | |||
==Syntax== | ==Syntax== | ||
EXPLODE(<expC1>, <expC2>) | EXPLODE(<expC1>, <expC2>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[AADD()]], [[AAVERAGE | + | [[AADD()]], [[AAVERAGE()]], [[ACOPY()]], [[ADEL()]], [[ADESC()]], [[ADIR()]], [[AELEMENT()]], [[AFIELDS()]], [[AFILL()]], [[AINS()]], [[ALEN()]], [[AMAX()]], [[AMIN()]], [[APPEND FROM ARRAY]], [[ARRAY()]], [[ASCAN()]], [[ASIZE()]], [[ASORT()]], [[ASTORE()]], [[ASTRING()]], [[ASUBSCRIPT()]], [[ASUM()]], [[COPY TO ARRAY]], [[DECLARE]], [[DIMENSION]], [[GATHER]], [[IMPLODE()]], [[IN_ARRAY()]], [[LOCAL]], [[PRIVATE]], [[PUBLIC]], [[RELEASE]], [[RESTORE]], [[SAVE]], [[SCATTER]] |
| − | + | ||
==Description== | ==Description== | ||
The EXPLODE() function returns an array, having separated the string. <expC2>, into individual elements of the array. The character string, <expC1>, is used as the string separator. | The EXPLODE() function returns an array, having separated the string. <expC2>, into individual elements of the array. The character string, <expC1>, is used as the string separator. | ||
| − | |||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | open database southwind | |
| − | + | use customers | |
| − | + | aFldlist = explode(",", fldlist()) | |
| + | cFldlist = implode(",", aFldlist) | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | |||
[[Category:Array Processing Functions]] | [[Category:Array Processing Functions]] | ||
| − | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] | ||
| + | [[Category:Lianja VFP Extensions]] | ||
| + | [[Category:VFP Function Extensions]] | ||
Latest revision as of 06:44, 10 May 2019
Contents
Purpose
Function to separate a string into the elements of an array
Syntax
EXPLODE(<expC1>, <expC2>)
See Also
AADD(), AAVERAGE(), ACOPY(), ADEL(), ADESC(), ADIR(), AELEMENT(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, ARRAY(), ASCAN(), ASIZE(), ASORT(), ASTORE(), ASTRING(), ASUBSCRIPT(), ASUM(), COPY TO ARRAY, DECLARE, DIMENSION, GATHER, IMPLODE(), IN_ARRAY(), LOCAL, PRIVATE, PUBLIC, RELEASE, RESTORE, SAVE, SCATTER
Description
The EXPLODE() function returns an array, having separated the string. <expC2>, into individual elements of the array. The character string, <expC1>, is used as the string separator.
Example
open database southwind use customers aFldlist = explode(",", fldlist()) cFldlist = implode(",", aFldlist)
