I've imported a CSV file that has a header row. The first column is labeled "DATE" and contains various dates, while the subsequent columns are simply numbered (like "1", "2", "3", etc.). I've written a script that asks the user for a specific date from the DATE column, as well as a column number to search in. For instance, I want to get the value at the intersection of row "1/1/2000" and column "6". However, I'm struggling to figure out how to properly retrieve that value in my script.
3 Answers
To fetch the value you need, you might want to ensure that your script prompts separately for both the date and the column number. Using `Out-GridView` could be handy for displaying the results and letting users filter through them easily for a clearer view.
You can simplify your retrieval process with a line of code like this: `($csv | Where-Object { $searchdate -eq (Get-Date($_.Date)) })."$targetColumnNumber"`. This should help you automatically extract the value you're looking for from the specified column, given the correct inputs.
Thanks for that! I’ll check out your script suggestion.
It’s important that the column header matches the name you’re using in the script. If it doesn’t need to match exactly, you should consider adding a third parameter in your function to define what you're looking for instead of using $getNum twice.
I've tried prompting separately for both, still not sure how to get the exact value though.