Re^3: Parse .csv file from FTP using Perl

Replies are listed 'Best First'.
Re^4: Parse .csv file from FTP using Perl by Sherlock Perl (Novice) on Jun 21, 2012 at 00:55 UTC
Yes I perfectly understand your logic. I have two rows in the .csv file and lets say the .csv looks like this: A1 = a B1 = b C1 = c .... etc etc A2 = 1 B2 = 2 C2 = 3 .... etc etc. So I want to find the value in Row 2 (A2, B2, C2,...) that corresponds to lets say value "c" in Row1. It is basically like HLOOKUP function in excel. I am not sure if I am clear enough in explaining what I want to do?	[reply]
Re^5: Parse .csv file from FTP using Perl by muba (Priest) on Jun 21, 2012 at 01:03 UTC
So the CSV file would look like this? `a,b,c 1,2,3` [download] How does any of the fields in line 2 correspond to any of the fields in line 1? I'm afraid I don't follow :) Edit: Wait, I think I get it now. What you want is a way to tell Perl, "hey, listen. What is the number of the field in the first line that has the value 'c'? Got that? Okay, now give me the value of the field with that number in the second line." Is that what you mean? There are actually several approaches, and I'm coming up with something momentarily. Hold on. Edit-edit: Yes, got it now. Okay, gimme a couple minutes.	[reply] [d/l]
Re^6: Parse .csv file from FTP using Perl by Sherlock Perl (Novice) on Jun 21, 2012 at 01:11 UTC
What I want the code to be doing is: Return the value in Row 2 which is in the same column as "b" is in Row 1. This means that the code would have to locate where "b" is first I guess. I assume I need to use this operator ~= and some looping or have all the values in the first row stored in an array and the check each element maybe..? And when I find the location of b just return the value in the second row which is in the same column as b...again I assume some kind of loop maybe? Thank you again I really appreciate your help! Edit: Yes this is exactly what I want. Thank you very much for the help :) I owe you big time for all this help:)	[reply]
Re^7: Parse .csv file from FTP using Perl by muba (Priest) on Jun 21, 2012 at 01:53 UTC
Re^8: Parse .csv file from FTP using Perl by Sherlock Perl (Novice) on Jun 21, 2012 at 01:58 UTC
Some notes below your chosen depth have not been shown here
Re^7: Parse .csv file from FTP using Perl by Tux (Canon) on Jun 21, 2012 at 06:45 UTC
Re^8: Parse .csv file from FTP using Perl by Sherlock Perl (Novice) on Jun 21, 2012 at 13:45 UTC
Some notes below your chosen depth have not been shown here


Syntactic Confectionery Delight
	PerlMonks