Search results 116

Sorted from new to old.

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13

Remove Managed by Your Organization from Edge

AI helped me here to remove the message on my browser of (Managed by your ...

2024Jan10

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

1 2 3 ...7 8