Search Results

I am sorry, in a hurry, i mentioned the last column incorrectly.

"LP232"+"40"+"932"+"GREEN"+"PEN"+"23"
"LP1234"+"44"+"933"+"RED"+"PENCIL"+"24"
"LP23"++"920"++"YELLOW"+"KNIFE"+"23"

OUTPUT IS
...

I just got the changed requirement. Initially I was told that the files would be of the first posted format. But later files of the latest 2 formats have come!!
Sorry to bother you.

I have 2 requirements.

FIRST REQUIREMENT:

IT HAS + as DELIMITER AND " AS TEXT SEPERATOR. PLEASE SEE THAT THERE IS NO " BEFORE THE FIRST COLUMN. ALSO IT HAS DELIMITER VALUE AT THE END.
...

A file contains the following data

Name, Age, Sex, city, country
abc, 20, m, tokyo, Japan
def, 21, f, sydney, Australia
ghd, 23, m, chicago, USA
rww, 29, f, london, UK

I need the city...