Search results 60

Sorted from new to old.

RangeValues

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

2024Jan25

Frequency1

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

2023Dec16

ReplaceStrings

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

2023Nov11

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

2020Aug21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

ProtectString + UnProtectString

Protects or unprotects a string giving a password Using XorD and similar to ...

2020Jan10

IsThere1_Image

Searches for an image and return the file extension of found, or returns null ...

2019Dec7

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

1 2 3 4