Texts + Strings 166

Texts, strings, convert, replace, encode, parts and concatenations

Sorted from new to old.

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Feb4

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3

NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Feb1

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

Jan13

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

Jan9

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

Jan8

CutString9

Cuts from CutFrom starting from any of items found from ...

Jan7

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1

CutLeftNumber

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

2023Dec31

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

Frequency1

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

2023Dec16

1 2 3 ...10 11