Atom
atom before_excludatom before_includatom countatom count_distinctatom count_lrtrimatom count_lrtrim_distinctatom distinctatom distinct_lrtrimatom distinct_lrtrim_1sbeforeatom findatom find_lrtrimatom getatom get_firstatom get_first_lrtrimatom get_lastatom get_last_lrtrimatom get_lrtrimatom lrtrimatom positionatom position_lrtrimatom size
atom before_exclud <atomList> <index> <separator>
Description
Get the atom list before the first occurrence of an atom in an atom list (atom excluded).
Get the atom list before the first occurrence of an atom in an atom list (atom excluded).
Parameters
atomList: The atom list (example: A,B,C) - String - required
index: The atom index - Number - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
index: The atom index - Number - required
separator: The list separator (in this example ','), 1 character 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 (atom included).
Get the atom list before the first occurrence of an atom in an atom list (atom included).
Parameters
atomList: The atom list (example: A,B,C) - String - required
index: The atom index - Number - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
index: The atom index - Number - required
separator: The list separator (in this example ','), 1 character 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 number of occurrences of an atom in an atom list.
Count the number of occurrences of an atom in an atom list.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom count " A, B,A ,A ,C, D " "A " ","
mentdb
2
atom count_distinct <atomList> <atomToCount> <separator>
Description
Count the number of distinct occurrences of an atom in an atom list.
Count the number of distinct occurrences of an atom in an atom list.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character 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 number of occurrences of an atom in an atom list, after lrtrim.
Count the number of occurrences of an atom in an atom list, after lrtrim.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character 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 number of distinct occurrences of an atom in an atom list, after lrtrim.
Count the number of distinct occurrences of an atom in an atom list, after lrtrim.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToCount: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom count_lrtrim_distinct " A, B,A ,A ,C, D " "A " ","
mentdb
1
atom distinct <atomList> <separator>
Description
Get the distinct atoms of a list
Get the distinct atoms of a list
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character 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 the distinct atoms of a list, after lrtrim
Get the distinct atoms of a list, after lrtrim
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character 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 the distinct atoms of a list, after lrtrim, with one space added before every atom except the first.
Get the distinct atoms of a list, after lrtrim, with one space added before every atom except the first.
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character 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 an atom in an atom list.
Find the position of an atom in an atom list.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character 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 an atom in an atom list, after lrtrim on each atom.
Find the position of an atom in an atom list, after lrtrim on each atom.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom find_lrtrim " A, B,A ,A ,C, D " "A " ","
mentdb
1
atom get <atomList> <index> <separator>
Description
Get the atom at a specific index in an atom list
Get the atom at a specific index in an atom list
Parameters
atomList: The atom list (example: A,B,C) - String - required
index: The position of the atom (starting at 1) - Number - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
index: The position of the atom (starting at 1) - Number - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom get "A,B,C,D" 2 ","
mentdb
B
atom get_first <atomList> <separator>
Description
Get the first atom of an atom list
Get the first atom of an atom list
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom get_first "A, B ,C,D" ","
mentdb
A
atom get_first_lrtrim <atomList> <separator>
Description
Get the first atom of an atom list, after lrtrim
Get the first atom of an atom list, after lrtrim
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom get_first_lrtrim " A, B ,C,D" ","
mentdb
A
atom get_last <atomList> <separator>
Description
Get the last atom of an atom list
Get the last atom of an atom list
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom get_last "A, B ,C,D" ","
mentdb
D
atom get_last_lrtrim <atomList> <separator>
Description
Get the last atom of an atom list, after lrtrim
Get the last atom of an atom list, after lrtrim
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom get_last_lrtrim " A, B ,C, D" ","
mentdb
D
atom get_lrtrim <atomList> <index> <separator>
Description
Get the atom at a specific index in an atom list, after lrtrim
Get the atom at a specific index in an atom list, after lrtrim
Parameters
atomList: The atom list (example: A,B,C) - String - required
index: The position of the atom (starting at 1) - Number - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
index: The position of the atom (starting at 1) - Number - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom get_lrtrim "A, B ,C,D" 2 ","
mentdb
B
atom lrtrim <atomList> <separator>
Description
Apply lrtrim to each atom of a list
Apply lrtrim to each atom of a list
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character 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 an atom in an atom list.
Find the position of an atom in an atom list.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character 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 an atom in an atom list, after lrtrim on each atom.
Find the position of an atom in an atom list, after lrtrim on each atom.
Parameters
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
atomToFind: The atom to search - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom position_lrtrim " A, B,A ,A ,C, D " "A " ","
mentdb
1
atom size <atomList> <separator>
Description
Get the number of atoms of an atom list (size >= 1)
Get the number of atoms of an atom list (size >= 1)
Parameters
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
atomList: The atom list (example: A,B,C) - String - required
separator: The list separator (in this example ','), 1 character max - Number - required
admin
atom size "A,B,C,D" ","
mentdb
4