Search results 192

Sorted from new to old.

SQL Cross Apply String_Split with XML Path

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

2024Jan20

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ANStrFind_AndOrAdd

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

2023Dec19

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

1 2 ...4 ...11 12