I am trying to grep column 4 with pipe delimiter (
|) and replace all double quotes within it and then enclose that string with double quotes again.
Problem is column 4 is where user can write anything, even a pipe, which is my delimiter and it breaks my process.
E.g. column 4 may be
Now I am trying to write command which goes to column 4, replace all double quotes then enclose it with double quote again so I can treat it as single string to make my process work.
Required Output for column 4 is
Similarly I have do the same for column 7, required Output for column 7 is
Final output should look like this: