Search results 58

Sorted from new to old.

CutLeftNumber

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

2023Dec31

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

ReplaceStrings

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

2023Nov11

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

LXFormat

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

2023Jun30

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

Remove_Between2Quotes

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

2020Mar9

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

RandomGUID

Creates a random GUID number like ... 879AE395-E026-0A63-EFC1-152038C4400B ...

2019Dec18

1 2 3 4