ETL project with C language

The project will need to be done in C# language only no C++ or other language please. I can send full description of this project. The objectives of this assignment are to demonstrate proficiency in file I/O, data structures, and data transformation using C language resources. Specifically, you will read in data from a text file, use that data to populate a data structure, and print that data to STDOUT by accessing the newly populated structure. The first part of ETL is extraction. The filename of a text file will be passed to your program via the command line. The data contained in that file is to be read into memory (i.e., extracted). Your program will be compiled and run on Eustis using the following commands: gcc -o etl hw1etl.c ./etl inputFile It is entirely possible that the input file either does not exist or is not where it is supposed to be. In such an event, your program should print an error message to STDERR that indicates which file is missing, then your program should exit safely. Use the following format for your error message (fileName should display the actual name of the missing file): etl ERROR: File “fileName” not found. The input file is in CSV (comma separated values) format where each line contains the data for one airport and the fields are as printed below. Note that these fields vary in size and content. Some fields may even be empty. Also note that the data for some of the fields are a melange of types. Specifically, the FAA Site Number and both latitude and longitude contain numbers, punctuation, and text. 1.2 Transformation The second part of ETL is transformation. A list of comma separated values is convenient for text files, but it is far less convenient in memory. Once the data for a single airport has been read into a buffer, you will need to parse the buffer based on the commas between the data fields. The parsed data will then be used to populate a structure of the type struct airPdata (i.e. the data has been transformed from CSV to a data structure). The format of airPdata, shown below, will be defined in airPdata.h. Note that the airPdata structure uses the same names as the input file’s Field Names (See Table 1 on page 2), though not all of the Field Names are used. typedef struct airPdata{ char *siteNumber; //FAA Site Number char *LocID; //Airport’s ‘‘Short Name’’, \textit{e.g.} MCO char *fieldName; //Airport Name char *city; //Associated City char *state; //State char *latitude; //Latitude char *longitude; //Longitude char controlTower;//Control Tower, this is a single character (Y/N) } airPdata; Remember, some of these fields will be of differing lengths for each airport. When you allocate memory structure’s fields, you can assume that no entry will be longer than 50 characters (plus 1 character for the terminating NULL). 1.3 Loading Finally, the third part of ETL is loading. With the data now in an airPdata structure it can be easily accessed by functions and/or other programs (i.e., loaded). For this assignment, you will use pass the airPdata structure to a function ( PrintData(airPdata airport) ) that will print the data to STDOUT (aka the console). Before calling PrintData for the first time, make sure you print a header line that names each column. Specifically, use the following two lines of code: printf("%-12s %-11s %-42s %-34s %-3s %-15s %-16s Towernn", "FAA Site", "Short Name", "Airport Name", "City", "ST", "Latitude", "Longitude"); printf("%-12s %-11s %-42s %-34s %-3s %-15s %-16s =====nn", "========", "==========", "============", "====", "==", "========", "=========");