FX - Atom @ Data transformation (ETL) @ MentDB Weak
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 (excluded atom).
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
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).
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
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.
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
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.
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
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.
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
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.
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
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
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
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
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
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.
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
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.
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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.
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
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)
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
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