Search text file

Hello,

Just cannot think straight at the moment. I have an employee table in
.csv fomat where the far left column is everyone's unique emplyee ID
and the column to the right has the employee Id of their manager -
basically a one to many realationship. I just can't think of how to
this...maybe an array or dictionary object? I am very adept at using
them.

Thanks for any help provided.

Tim

ekkehard
Wed Oct 11 03:33:26 CDT 2006

timwmarion@yahoo.com wrote:
> Hello,
>
> Just cannot think straight at the moment. I have an employee table in
> .csv fomat where the far left column is everyone's unique emplyee ID
> and the column to the right has the employee Id of their manager -
> basically a one to many realationship. I just can't think of how to
do what?
> this...maybe an array or dictionary object? I am very adept at using
> them.

Depending on what you want to achieve, using ADO/Text Driver and treating
your .csv file as an SQL table may be an efficient way to access your
employee info.

McKirahan
Wed Oct 11 09:50:55 CDT 2006

<timwmarion@yahoo.com> wrote in message
news:1160546816.816949.239340@i42g2000cwa.googlegroups.com...
> Hello,
>
> Just cannot think straight at the moment. I have an employee table in
> .csv fomat where the far left column is everyone's unique emplyee ID
> and the column to the right has the employee Id of their manager -
> basically a one to many realationship. I just can't think of how to
> this...maybe an array or dictionary object? I am very adept at using
> them.

"I just can't think of how to this..." -- What are you wanting to do?

Perhaps identify each employee's manager's name?
Perhaps identify each manager's employees?

Does the file look anything like the following?
11,21 employee 11 manager 21
12,21 employee 12 manager 21
13,21 employee 13 manager 21
21,31 employee 21 manager 31
31,00 employee 31 (president)

Are there no names in the file just a pair of numbers?