Atom
Like all languages, you have a few data manipulation functions.
atom before_exclud <atomList> <index> <separator>
Description
get the atom list before the first occurrence of an atom in an atom list (excluded atom).
Parameters
atomList: Atom list (example A,B,C) - String - required
index: The index atom - Number - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom before_exclud " A, B,A ,A ,C, D " "3" ","
mentdb
A, B
atom before_includ <atomList> <index> <separator>
Description
get the atom list before the first occurrence of an atom in an atom list (included atom).
Parameters
atomList: Atom list (example A,B,C) - String - required
index: The index atom - Number - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom before_includ " A, B,A ,A ,C, D " "3" ","
mentdb
A, B,A
atom count <atomList> <atomToCount> <separator>
Description
count the occurrence number of an atom in an atom list.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom count " A, B,A ,A ,C, D " "A " ","
mentdb
2
atom count_distinct <atomList> <atomToCount> <separator>
Description
count the occurrence number of a distinct atom in an atom list.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom count_distinct " A, B,A ,A ,C, D " "A " ","
mentdb
1
atom count_lrtrim <atomList> <atomToCount> <separator>
Description
count the occurrence number of a lrtrim atom in an atom list.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom count_lrtrim " A, B,A ,A ,C, D " "A " ","
mentdb
3
atom count_lrtrim_distinct <atomList> <atomToCount> <separator>
Description
count the occurrence number of a lrtrim distinct atom in an atom list.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom count_lrtrim_distinct " A, B,A ,A ,C, D " "A " ","
mentdb
1
atom distinct <atomList> <separator>
Description
get distinct atom for each atom in a list
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom distinct "A,B,A,A ,C,D" ","
mentdb
A,B,A ,C,D
atom distinct_lrtrim <atomList> <separator>
Description
get lrtrim distinct atom for each atom in a list
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom distinct_lrtrim " A, B,A ,A ,C, D " ","
mentdb
A,B,C,D
atom distinct_lrtrim_1sbefore <atomList> <separator>
Description
get lrtrim distinct atom for each atom in a list. add one space before all atoms, except the first.
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom distinct_lrtrim_1sbefore " A, B,A ,A ,C, D " ","
mentdb
A, B, C, D
atom find <atomList> <atomToFind> <separator>
Description
find the position of atom in an atom list.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom find " A, B,A ,A ,C, D " "A " ","
mentdb
3
atom find_lrtrim <atomList> <atomToFind> <separator>
Description
find the position of atom in an atom list. lrtrim on each atom before.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom find_lrtrim " A, B,A ,A ,C, D " "A " ","
mentdb
1
atom get <atomList> <index> <separator>
Description
get atom at the specific index in an atom list
Parameters
atomList: Atom list (example A,B,C) - String - required
index: Position of the atom (start to 1) - Number - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom get "A,B,C,D" 2 ","
mentdb
B
atom get_first <atomList> <separator>
Description
get the first atom in an atom list
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom get_first "A, B ,C,D" ","
mentdb
A
atom get_first_lrtrim <atomList> <separator>
Description
get the first lrtrim atom in an atom list
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom get_first_lrtrim " A, B ,C,D" ","
mentdb
A
atom get_last <atomList> <separator>
Description
get the last atom in an atom list
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom get_last "A, B ,C,D" ","
mentdb
D
atom get_last_lrtrim <atomList> <separator>
Description
get the last lrtrim atom in an atom list
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom get_last_lrtrim " A, B ,C, D" ","
mentdb
D
atom get_lrtrim <atomList> <index> <separator>
Description
get lrtrim atom at the specific index in an atom list
Parameters
atomList: Atom list (example A,B,C) - String - required
index: Position of the atom (start to 1) - Number - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom get_lrtrim "A, B ,C,D" 2 ","
mentdb
B
atom lrtrim <atomList> <separator>
Description
get lrtrim atom for each atom in a list
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom lrtrim " A, B,A ,A ,C, D " ","
mentdb
A,B,A,A,C,D
atom position <atomList> <atomToFind> <separator>
Description
find the position of atom in an atom list.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom position " A, B,A ,A ,C, D " "A " ","
mentdb
3
atom position_lrtrim <atomList> <atomToFind> <separator>
Description
find the position of atom in an atom list. lrtrim on each atom before.
Parameters
atomList: Atom list (example A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom position_lrtrim " A, B,A ,A ,C, D " "A " ","
mentdb
1
atom size <atomList> <separator>
Description
get size atom of an atom list (size >=1)
Parameters
atomList: Atom list (example A,B,C) - String - required
separator: List Separator (in this example ','), 1 CHAR MAX - Number - required
admin
atom size "A,B,C,D" ","
mentdb
4
Innov-AI
Services
Supporters
Contact
About