Topic Options
#57150 - 07/17/19 12:51 PM Extract info from an external csv file
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 324
Loc: Home
Hi, I have a question.
I need to access an external csv data file, and then I need to search for a name in column A, and then I need to extract the info from column B and C into a variable. Is that possible in PP Design or In Production?

I know in production I can access an external Excel file and read info from a position but I'm not sure how to search for a name in column A, and extract info from column B and C!

Can any one help.

THANKS


Edited by Sami786 (07/17/19 12:52 PM)
_________________________
Peace

Top
#57151 - 07/17/19 01:45 PM Re: Extract info from an external csv file [Re: Sami786]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 471
Loc: Québec, Canada
You could do this in a script in Production. You script would load the CSV file in memory, inside an array, and you could search and extract what you need.

You could as well use the Lookup in Microsoft Excel Documents plugin in concordance with the metadata. Using this, you would need to modify your CSV file.

I suggest you contact us at support so we can show you how it is done.

You can open a ticket on our website.

Top
#57154 - 07/18/19 05:15 PM Re: Extract info from an external csv file [Re: Sami786]
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 324
Loc: Home
will do, thanks for you guidance.
_________________________
Peace

Top