Search results 60

Sorted from new to old.

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

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

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

GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

2019Mar31

Val2

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

2019Jan3

GenerateRandom

Generates a random string, returns string passed, then full date, then 8-chars ...

2018Sep12

1 2 3 4