Topic Options
#21207 - 12/07/09 05:50 PM Data Selection from CSV
Kevin Fay Offline
OL Newbie

Registered: 06/05/07
Posts: 21
Loc: Alexandria, VA
When I was at training 2 years ago we went over mainly line data, but I have a CSV file.

The data needs to be separated by sales rep > customer name > item. Each sales rep has multiple customers and each customer has multiple items.

Each customer is on its own sheet(s) of paper, containing each one of their items on its own line (spreadsheet type of view). I can get a single record to show up on a sheet, but not get it to loop through.

I have a PressTalk on a non-ejecting page
Code:
define(&a,integer,0)

if(&customer1 = trim(@(3,1,75)))
    for(&a, 1, 1, 100)
       setstyle(&Style1)
       &output1:=&customer1 + '     ' + trim(@(6,1,75)) + '     ' + trim(@(7,1,75))
       &customer1:=trim(@(3,1,75))
    endfor()

endif()
and then on my output page I have:
Code:
setstyle(&Style1)
show(&output1)
Am I in the right direction and just missing something, or am I in left field?

Top
#21208 - 12/07/09 05:51 PM Re: Data Selection from CSV
Kevin Fay Offline
OL Newbie

Registered: 06/05/07
Posts: 21
Loc: Alexandria, VA
I meant to post this in PlanetPress 6 Design.

Top


Moderator:  cosimo, OL Newsgroup Support