Uh oh!
There was an error while loading.Please reload this page.
- Notifications
You must be signed in to change notification settings - Fork13
😎 Array functions that are similar JavaScript functions. Example: Push, Pop, Shift, Unshift, Sort, length, toString.
License
NotificationsYou must be signed in to change notification settings
todar/VBA-Arrays
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
A whole bunch of Array functions to make it easier and faster coding. Many functions are to try and mimic JavaScript. Example: Push, Pop, Shift, Unshift, Splice, Sort, Reverse, length, toString.
- www.roberttodar.com About me and my background and some of my other projects.
- Style Guide A guide for writing clean VBA code. Notes on how to take notes =)
- Boilerplate Boilerplate that contains a bunch of helper libraries such as JSON tools, Code Analytics, LocalStorage, Unit Testing, version control and local network distribution, userform events, and more!
- Strings String function library.
ToString,Inject,StringSimilarity, and more. - Analytics Way of tracking code analytics and metrics. Useful when multiple users are running code within a shared network.
- Userform EventListener Listen to events such as
mouseover,mouseout,focus,blur, and more.
| Function Name | Description |
|---|---|
ArrayAverage | Returns the average of all the numbers inside an array. |
ArrayContainsEmpties | ReturnsTrue if the array contains any empties. |
ArrayDimensionLength | Returns the dimensionlenght of the array. |
ArrayExtractColumn | Extracts a column from a 2 dim array and returns it as a 1 dim array |
ArrayExtractRow | Extracts a row from a 2 dim array and returns it as a 1 dim array |
ArrayFilter | Uses regex to filter items in a single dim array |
ArrayFilterTwo | Uses regex to filter items in a two dim array. |
ArrayFromRecordset | Converts a recordset into a 2 dim array including it's headers |
ArrayGetColumnIndex | Return the column index based on the header name |
ArrayGetIndexes | Returns a single dim array of the indexes of column headers |
ArrayIncludes | Checks to see if a value is in single dim array |
ArrayIndexOf | Returns the index of an item in a single dim array |
ArrayLength | Returns the number of items in an array |
ArrayPluck | Extracts a list of a given property. Must be array of dictionries |
ArrayPop | Removes the last element in array, returns the popped element |
ArrayPush | Adds a new element(s) to an array (at the end), returns the new array length |
ArrayPushTwoDim | Adds a new element(s) to an array (at the end). Must be full row of data |
ArrayQuery | Saves array in CSV file and allows the ability to run ADODB queries on it. |
ArrayRemoveDuplicates | Removed duplicates from single dim array |
ArrayReverse | Reverse array (can be used after sort to get the descending order) |
ArrayShift | Removes element from array - returns removed element |
ArraySort | Sort an array |
ArraySplice | Changes the contents of an array by removing or replacing existing elements and/or adding new elements. |
ArraySpread | Spreads out an array into a single array. example: jagged arrays, dictionaries, collections. |
ArraySum | Returns the Sum of a single dim array containing numbers |
ArrayToCSVFile | Saves a two dim array to a CSV file |
ArrayToString | Returns a string from a 1 or 2 dim array, separated by optional delimiter and vbnewline for each row |
ArrayTranspose | Application.Transpose has a limit on the size of the array and is limited to the 1st dim. This fixes those issues. |
ArrayUnShift | Adds a new element to the begining of the array |
Assign | Quick tool to either set or let depending on if element is an object |
ConvertToArray | Convert other list type objects to an array |
IsArrayEmpty | This function tests whether the array is empty (unallocated). Returns TRUE or FALSE. |
- Import ArrayFunctions.bas file.
- Set a reference to
Microsoft Scripting Runtimeas this uses dictionaries for removing duplicates.
Below are some of the examples you can do with single dim arrays. Note, there are several functions for two dim arrays as well.
'EXAMPLES OF VARIOUS FUNCTIONSPrivateSubarrayFunctionExamples()' For simplicity using `a` as the variable. Otherwise, don't do that in your real code! =)DimaAsVariant' Single dim functions that manipulate the array.ArrayPusha,"Banana","Apple","Carrot"'--> Banana,Apple,CarrotArrayPopa'--> Banana,Apple --> returns CarrotArrayUnShifta,"Mango","Orange"'--> Mango,Orange,Banana,AppleArrayShifta'--> Orange,Banana,AppleArraySplicea,2,0,"Coffee"'--> Orange,Banana,Coffee,AppleArraySplicea,0,1,"Mango","Coffee"'--> Mango,Coffee,Banana,Coffee,AppleArrayRemoveDuplicatesa'--> Mango,Coffee,Banana,AppleArraySorta'--> Apple,Banana,Coffee,MangoArrayReversea'--> Mango,Coffee,Banana,Apple' Array properties functions.' These get details of the array: index of items, lenght, ect.ArrayLengtha'--> 4ArrayIndexOfa,"Coffee"'--> 1ArrayIncludesa,"Banana"'--> TruearrayContainsa,Array("Test","Banana")'--> TrueArrayContainsEmptiesa'--> FalseArrayDimensionLengtha'--> 1 (single dim array)IsArrayEmptya'--> False' Here is an example of a jagged array.a=Array(1,2,3,Array(4,5,6,Array(7,8,9)))' Can flatten jagged array with the spread formula. Note this is a deep spread.' This formula also spreads dictionaires and collections as well!a=ArraySpread(a)'--> 1,2,3,4,5,6,7,8,9' Math function examplesArraySuma'--> 45ArrayAveragea'--> 5' Filter use's regex patterna=Array("Banana","Coffee","Apple","Carrot","Canolope")a=ArrayFilter(a,"^Ca|^Ap")' Array to string works with both single and double dim arrays!Debug.PrintArrayToString(a)EndSub
About
😎 Array functions that are similar JavaScript functions. Example: Push, Pop, Shift, Unshift, Sort, length, toString.
Topics
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Releases
No releases published
Sponsor this project
Uh oh!
There was an error while loading.Please reload this page.
Packages0
No packages published