Shell Programming and Scripting

Yet again, that cannot be your CSV file.

CSV means "comma-separated values".

Your values are not separated by commas.

Hi mahi_mayu069,

Firstly, the csv file you have provided in the zip file is different from what you have provided later in your #7 post. The content in the zip file doesn't look like a csv since the delimiter or list seperator is absurd. The content in the #7 post is fine. It looks like the delimiter is ";" (a semicolon).

Now in order to view a delimited excel file in windows with a desired delimiter you need to modify the Windows System List Seperator. Please follow the below steps to perform the same :
1. Go to Control Panel in windows. (Assuming Windows 7)
2. Select View by : Category
3. Select Clock, Language and Region.
4. Select Region and Language.
5. In the formats tab, select Additional Settings.
6. Modify the List Seperator value to any desired delimiter. It could be a "|" (pipe), "," (comma), ";" semicolon etc.
7. Click on Apply an Ok.
8. Now open the delimited .csv file in Excel and you will get the desired output.

Make sure you have a common delimiter in your file.

Please use code tags as required by forum rules!

I can't see any relationship between what you call the .csv file and the final EXCEL file that you presented as required output. What lines should make it into the output, based on which decision? Within lines, more data fields are present than in the .csv, and different from the .csv should they exist. How should they be calculated? Why is "none" present in two lines?

Please reconsider and respecify utmost carefully!