Search results 21

Sorted from new to old.

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

Jul30

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Jul29

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Jul18

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Feb18

RangeValues

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

Jan25

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

CutLeftNumber

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

2023Dec31

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

Tabs12 in BS4

More Tabs in Bootstrap4, non-default that is smooth look, and elegant

2019Feb4

Restore Arabic text files

Solution to restore ASCII Arabic text files. Sometimes I noticed when system ...

2019Jan14

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

2018Sep5

1 2