Search results 16

Sorted from new to old.

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Mar4

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

Feb7

SQL Cross Apply String_Split with XML Path

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

Jan20

Arr_1Dim_2Str

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

2023Aug14

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

ANStrSort2

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

2020Sep24

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

Split string into table

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

2018Dec18

Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31

CapitalizeAllWords

Capitalize first letter in all words In a String

2018Jul15

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

Floor

Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...

2018Apr25

WordsCount

Counts the words in a string (using spaces)

2018Apr23