Extract info from an external csv file

Posted by: Sami786

Extract info from an external csv file - 07/17/19 12:51 PM

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
Posted by: Jean-C├ędric

Re: Extract info from an external csv file - 07/17/19 01:45 PM

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.
Posted by: Sami786

Re: Extract info from an external csv file - 07/18/19 05:15 PM

will do, thanks for you guidance.