Arraysearch column 0, return value from column 1

[BigAl]

I have a CSV file which i am putting into a 2D array, for the purpose of this we'll say the 2 columns are "ID" and "NAME"

What I need todo is search the array for a variable (a variable I read from an ini file on the local machine) which is in column 0 but i want to return the value in string in column 1 for that row, ie: 

ID, NAME

01, AAAA

02, BBBB

03, CCCC

 

So if i search in the array for "02" i want it to return the string "BBBB" so i can use this as a variable later on.

I'm using the CSVSplit.au3 from czardas to get my csv into a 2D array which is working perfectly.

I have tried using the _ArraySearch in Combo with _ArrayToString but the output i'm getting is "02, BBBB" instead of just "BBBB" from my example above.

Any help on how todo this would be greatly appreciated, and apologies if this has already been covered, i did look though the forum first but couldn't find a solution. 

[BrewManNH]

Why not use the INI* functions for this if it's an .ini file?

[BigAl]

Thanks for your reply.

The ini file on the local machine only has the "ID" in it, not the name, so i have a CSV which matches the ID to the name which i will include within my final exe, so i need to reference the ID pulled out of the ini file against my csv to get the correct name. 

 

[BrewManNH]

In that case, don't use _ArrayToString, just reference the array's [1] element to get just the second column's text.

[Subz]

Just to clarify BrewManNH comment:

#include <Array.au3>
#include <File.au3>
Local $aFileName
_FileReadToArray("Filename.csv", $aFileName, 1, ",")
Local $iSearch = _ArraySearch($aFileName, IniRead("FileName.ini", "Section", "Id", "N/A"))
    If @error Then MsgBox(48, "Error", "ID Not Found")
MsgBox(48, "Success", "ID Found" & $aFileName[$iSearch][1])

 

[BrewManNH]

@subz I could have posted working code, but chose to point the user in the direction they needed so they could learn to use AutoIt.

I'd refer you to my signature, specifically the second line in red as to why.

[Subz]

@BrewManNH Actually read your previous post incorrectly, I thought you had written $aArray[1] so was going to just clarify that it was $aArray[_ArraySearch][1] but then thought it wouldn't make sense so just wrote out the function for clarity.

Apologies for that.

[Tosyk]

I have exact same  question, but I have a lot of columns: players2.txt and I have ID list: chars.txt

I need to search for these IDs in column 'playerid' of players2.txt table and return 2 values for each id: from 'firstnameid' and 'lastnameid' columns. Searched online but lost tbh Only found this discussion which is very close to the topic.

Please help me

players2.txt