csv lookup question

[gooogle]

I am using DS 8.1 server.
I have a CSV file with data such as below:

from=jack, ac= 12345, to= jill, amount= 123.

from this comma seperated string i need to look up
from = person name & to = person name. i have a separate table with names to lookup from

i need to find out who is paying to who & how much from the csv file ? how do i do that ?

plzz help

thanks

[anbu]

Load CSV file into hash file. Use the hash file for lookup

[gooogle]

Load CSV file into hash file. Use the hash file for lookup

after converting to hash file

how can i read which party paid who ?
i mean how can i seperate that as the data i am getting is like a string only seperated by commas such as (payfrom= john, payto= jill, amount=100)


thanks

[ArndW]

Take this problem in small steps. First you need to load your file into a hashed file or a database table. In order to do that, you need to create a DDL or schema of what that table should look like. Is it correct to assume that a table/file in the form of:

Code: Select all

Name    Type
FROM     VarChar
ACCUNT VarChar
TO         VarChar
AMOUNT VarChar

is what is contained in your input file?

[ray.wurlod]

Load CSV file into hash file. Use the hash file for lookup

It's hashed file, not hash file.

[anbu]

Load CSV file into hash file. Use the hash file for lookup

It's hashed file, not hash file.

ok. Thanks Ray