Parse CSV
-
I need to parse a CSV file and match it with the first line of CSV with my table field. (eg:) My first line of Csv file will be like this Venue Event Date Cost Quantity Notes my database table fields will be Venue Event Date Notes Quantity Cost. I need to match because the order of CSV file will change . Can any one help me to match fields. My table fields and Csv fields will be same only. Pardon me if my presentation is wrong. Thanks in advance.
-
I need to parse a CSV file and match it with the first line of CSV with my table field. (eg:) My first line of Csv file will be like this Venue Event Date Cost Quantity Notes my database table fields will be Venue Event Date Notes Quantity Cost. I need to match because the order of CSV file will change . Can any one help me to match fields. My table fields and Csv fields will be same only. Pardon me if my presentation is wrong. Thanks in advance.
When you have the fields in the file, surely you should be able to iterate over them and match them with those in the DB?
Cheers, विक्रम
And sleep will come, it comes to us all And some will fade and some will fall
-
I need to parse a CSV file and match it with the first line of CSV with my table field. (eg:) My first line of Csv file will be like this Venue Event Date Cost Quantity Notes my database table fields will be Venue Event Date Notes Quantity Cost. I need to match because the order of CSV file will change . Can any one help me to match fields. My table fields and Csv fields will be same only. Pardon me if my presentation is wrong. Thanks in advance.