Sign in to follow this  
Followers 0
demeter

Howot get data from Array

3 posts in this topic

#1 ·  Posted (edited)

Hello,

First time in here and already stumbling over the good old array functions again (did have same issues in VBA).

Here is what I try to achieve:

I have a userform which I like to populate with data from a CSV file that uses ; as separation marks.

I found the following parser for the array:

'?do=embed' frameborder='0' data-embedContent>>

This clearly shows my array coming from the CSV file.

However the problem is how do I get, for example, the data from row 3 column 5 shown as text on a label?

For some reason I cant figure it out.

I would say following would work but it doesn't:

#include <array.au3>
#include <CSV.au3>

$rc = _ParseCSV("treintijden.csv", ";" )

For $i = 0 To UBound($rc)
    _ArrayDisplay($rc)
    ; You can now use the array as necessary
Next

   msgbox $rc[3][5]

Thanks in advance.

Regards,

Demeter

Edited by demeter

Share this post


Link to post
Share on other sites



Try this

#include <array.au3>
#include <CSV.au3>

$rc = _ParseCSV("treintijden.csv", ";")

_ArrayDisplay($rc)

MsgBox(0, "", $rc[2][4]) ; 3rd row, 5th column - Arrays start at 0,0 and not 1,1

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

BrewManNH,

Thanks works like a charm.

Cheers,

Demeter

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0