BasementDweller Posted April 6, 2021 Share Posted April 6, 2021 (edited) Hi -- My code-writing skills are not good. I have an array ($aUsers) with a varying number of rows (averaging around 280 to 300 rows) and 13 columns. All column rows are filled with data except Col4, which is an empty column. I'd like to add "staff" to all Col4 rows. I've tried several ways to do this, and ended up with the script below. The trouble I have with the below is that although it does add "staff" to all Col4 rows, it moves every other columns' data down to start just below the row where Col4's data ends. So what I end up with is about 300 rows with no data in any column except for Col4, then an additional 300 rows with all columns filled with data except Col4. I'd like to see the original number of rows with all columns filled with the data they already have, and all Col4 rows filled with "staff". For $i = 0 To UBound($aUsers) - 1 _ArrayInsert($aUsers, $i, "staff", 4) Next _ArrayDisplay($aUsers) I hope someone can show me how to get this right. Thank you! Edited April 6, 2021 by BasementDweller Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted April 6, 2021 Moderators Share Posted April 6, 2021 BasementDweller, Just assign the value directly: For $i = 0 To UBound($aUsers) - 1 $aUsers[$i][4] = "staff" Next _ArrayDisplay($aUsers) As you have found out - using _ArrayAdd adds an entire new row to the array. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
BasementDweller Posted April 6, 2021 Author Share Posted April 6, 2021 M23 -- Thank you! Thank you! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now