Search results 60

Sorted from new to old.

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

May16

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Feb19

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

2024Oct29

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

2024Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

1 2 3 4