Innov-AI     Services     Supporters     Contact     About    
Atom

Like all languages, you have a few data manipulation functions.

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).

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




© 2012 - 2023