accessing data from json array of json arrays

Hi,

i am reading in a inventory file in csv format with readdcsv() and get what 
i believe is a array of arrays.

R: From aix inventory, got data 
[["xlsmp.rte","5.1.0.0","default","lslpp"],["xlsmp.msg.en_US.rte","5.1.0.0","default","lslpp"],["xlsmp.msg.EN_US.rte","5.1.0.0","default","lslpp"],["xlsmp.aix61.rte","5.1.0.0","default","lslpp"],["xlmass.lib","6.1.0.4","default","lslpp"],["xlmass.aix53.lib","6.1.0.4","default","lslpp"],["xlmass.adt.include","6.1.0.4","default","lslpp"],["xlmass.8.1.3","8.1.3.1","default","lslpp"],["xlmass.10.1.0","10.1.0.0","default","lslpp"],["xlfrte.aix61","15.1.3.5","default","lslpp"],["xlfrte","15.1.3.5","default","lslpp"]]

now i need to extract the version number from a package (by name).  tried 
filter() and grep() but both returned nothing.

example:

["xlfrte.aix61","15.1.3.5","default","lslpp"] 
      |                         |     
  package name   version

test promise:

bundle agent eval_numbers {


    vars:

        "my_data" data => 
readcsv("$(sys.workdir)/state/software_packages.csv");
        "aix_inventory_str" string => format("%S", my_data);

        "test_filtergrep" slist => grep("^ xlfrte .*$", my_data);

        #"keys_unsorted" slist => getindices("my_data");
        #"keys"          slist => sort(keys_unsorted, "lex");

    #methods:

        #"call_to_get_stuff"   usebundle => get_stuff ( @(my_data), $(keys) 
);

    reports:

        "From aix inventory, got data $(aix_inventory_str)";

        "Filtered result $(test_filtergrep)";

        #"Keys sorted $(keys)";

}


so how to do it?

wbr 

chris

-- 
You received this message because you are subscribed to the Google Groups "help-cfengine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/help-cfengine/4c5a8faa-ddb3-42b7-9f94-bfac668890abn%40googlegroups.com.