I have a requirement to read a text file and split into a specific column for processing further.
we are facing issue while trying to split a column that has been qualified using double quote.
sample data TXT.FILE
first Name | middle name | last name | address 1 | address 2 | city | Pincode | phone number|emailid
John|“NA”|Smith|“102|A Naval street”|“Sea side area”|Chennai|600 001|98765 email@example.com
Sam|“NA”||“102|103| der street”|“airforce area”|Bangalore|600 023|98756 firstname.lastname@example.org
Mark|“NA”|fernadas|“101|Block A|05 Commando street”|“Military area”|Delhi|110 001|98765 email@example.com
Here | is the delimiter and text within a quote("") should be considered as a single column, the challenge we facing here the text within the quote has | sign as part of the column. Here split the text into 9 column