Could anyone offer a suggestion to get me started? Here’s the situation:
I was just given a project whereas I will receive a .csv (comma delimited) file, but I was told that the headers could shift. Was told that one day when the contact downloads the report, the columns could be in a different order. For example, today he could download the report for me to then pick up and map and it is like this:
NAME ADDRESS CITY STATE ZIPCODE
Tomorrow, he could create the .csv for me and it could be like this:
ADDRESS NAME CITY ZIPCODE STATE
I was told that they will not do anything to address this and it will be my job to make sure that when I get the .csv file, I am properly mapping the data. Looks like they will always send the header names (ADDRESS, NAME, CITY) regardless, so I would think that this will help somewhat, but being that I’ve always dealt with flat files that always had stagnant positions, I’m currently confused as to how to approach this.
Currently thinking perhaps that I can’t make a flat file for this and will instead have to first convert the .csv to a xml and then maybe I can make this work, but I don’t see a service involving .csv to .xml. This job doesn’t want us to use Java unless it’s a last resort and we have no choice.
Any suggestions? Unfortunately, I was given a short timeline on this.