Remove Carriage Return (CRLF) within double quotes Post: 302950445

Sponsored Content

Top Forums Shell Programming and Scripting Remove Carriage Return (CRLF) within double quotes Post 302950445 by covina on Friday 24th of July 2015 02:19:47 PM

07-24-2015

Registered User

Please copy and paste in Note++ and you will see it (display the end of line symbol to see CRLF)
Here is the sample file:

Code:

6,,G0570405,037112,13907187-P06241,P06241,,B1249998,,,03/10/2014,12:42:00,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,1301,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --

Processed in purification",Small Box,,WB for DNA,Yes,3/11/2014 11:55 AM,130100010,,,,,,0,,
9,,,,12112008,BAF312A2304,EH07583,G0521371,2024001,D-D,02/21/2014,09:22:00,03/11/2014 09:00:00,,,,,Male,1240924436,,Frozen Acceptable ,2024,DNA PaxGene Tube,V1CYP,,"Partsample Barcode: 01240924436011
Material: BA
Sample Description: CYP2C9 Haplotype
Eurofins Study Code: 2181261098

-- Added 3/11/2014 2:36 PM by abc --

Processed in purification",Small Box,,WB for DNA,No,3/11/2014 12:18 PM,,,,,,,0,,
10,,,,CL15312003,12-102-13,,G0573245,0135-1306,,03/10/2014,,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,135,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --

Processed in purification",Small Box,3064,WB for DNA,Yes,3/11/2014 12:36 PM,,,,,,,0,,
11,,,,CL15312003,12-102-13,,G0576563,0135-1308,,03/10/2014,15:45:00,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,135,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --

Processed in purification",Small Box,3064,WB for DNA,Yes,3/11/2014 12:36 PM,,,,,,,0,,
12,,,,CL15312003,12-102-13,,G0576562,0135-1307,,03/10/2014,12:48:00,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,135,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --

Processed in purification",Small Box,3064,WB for DNA,Yes,3/11/2014 12:36 PM,,,,,,,0,,
24,,,,19012034,BAN2401-G000-201,I6720150214,G0521407,10901054,,03/04/2014,,03/11/2014 10:00:00,,,,,Female,,,Frozen Acceptable ,1090,EDTA Tube,2 (Baseline),,"Sample Name: PG (APOE4)
Year of Birth: 1933",Small Box,,WB for DNA,No,3/11/2014 3:20 PM,,,,,,,0,28456103,

I wanted to be formatted like this:

Code:

5,,G0570409,037112,13907187-P06241,P06241,,B1249997,,,03/10/2014,12:42:00,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,1301,SST Tube,,,,Large Box,,Serum,Yes,3/11/2014 11:07 AM,130100010,,,,,,0,,
6,,G0570405,037112,13907187-P06241,P06241,,B1249998,,,03/10/2014,12:42:00,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,1301,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --Processed in purification",Small Box,,WB for DNA,Yes,3/11/2014 11:55 AM,130100010,,,,,,0,,
9,,,,12112008,BAF312A2304,EH07583,G0521371,2024001,D-D,02/21/2014,09:22:00,03/11/2014 09:00:00,,,,,Male,1240924436,,Frozen Acceptable ,2024,DNA PaxGene Tube,V1CYP,,"Partsample Barcode: 01240924436011 Material: BA Sample Description: CYP2C9 Haplotype Eurofins Study Code: 2181261098 -- Added 3/11/2014 2:36 PM by abc -- Processed in purification",Small Box,,WB for DNA,No,3/11/2014 12:18 PM,,,,,,,0,,
10,,,,CL15312003,12-102-13,,G0573245,0135-1306,,03/10/2014,,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,135,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --Processed in purification",Small Box,3064,WB for DNA,Yes,3/11/2014 12:36 PM,,,,,,,0,,
11,,,,CL15312003,12-102-13,,G0576563,0135-1308,,03/10/2014,15:45:00,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,135,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --Processed in purification",Small Box,3064,WB for DNA,Yes,3/11/2014 12:36 PM,,,,,,,0,,
12,,,,CL15312003,12-102-13,,G0576562,0135-1307,,03/10/2014,12:48:00,03/11/2014 10:00:00,,,,,,,,Cool/Acceptable,135,DNA PaxGene Tube,,,"-- Added 3/11/2014 2:36 PM by abc --Processed in purification",Small Box,3064,WB for DNA,Yes,3/11/2014 12:36 PM,,,,,,,0,,
24,,,,19012034,BAN2401-G000-201,I6720150214,G0521407,10901054,,03/04/2014,,03/11/2014 10:00:00,,,,,Female,,,Frozen Acceptable ,1090,EDTA Tube,2 (Baseline),,"Sample Name: PG (APOE4) Year of Birth: 1933",Small Box,,WB for DNA,No,3/11/2014 3:20 PM,,,,,,,0,28456103

Last edited by Scrutinizer; 07-24-2015 at 06:56 PM.. Reason: better file; mod: code tags

covina

View Public Profile for covina

Find all posts by covina

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove a carriage return at end of variable

Is there a command in unix to remove a carriage return character(^M) at the end of a variable value?

2. UNIX for Dummies Questions & Answers

To remove carriage return between the line

Hi, I have a situation where I need to remove the carriage return between the lines. For.eg. The input file: 1,ad,"adc sdfd",edf 2,asd,"def fde",asd The output file should be 1,ad,adc sdfd,edf 2,asd,def fde,asd Thanks Shash

3. Shell Programming and Scripting

sqlplus returning value - remove carriage return '\r' - Please help

Guys - Simple code, i am trying to get a number back from sqlplus call to a query. After that, i need to use that number in a loop. --------------------------------- #!/bin/ksh VALUE=`sqlplus -silent sh/password@sh <<END set pagesize 0 feedback off verify off heading off echo off select...

4. UNIX for Dummies Questions & Answers

Remove ^M (carriage return) with string manipulation

Hello, I want remove ^M at end of my files line if I use command : tr -d '\r' <inp>out it work fine but get I the same result by manipulating the string ? I want this because in my text file I manipulate some other part I have input "the cat^M" I want output "the cat" I have made...

5. Shell Programming and Scripting

Remove carriage return in a record

6. Shell Programming and Scripting

Excel CSV with Double Quotes and Carriage Returns

Hi List, I am sure this issue must have been encountered before. I have saved an excel CSV and sent it to my linux box where I require to parse it as a CSV line by line. The file displays fine in Excel with csv headers and consistent records and fields. However when I look at it in linux I see...

7. Shell Programming and Scripting

Awk to remove carriage return from 65th field

Hi, I have a pipe delimited file. There are around 700 columns in the file. The 65th column has carriage return which is causing read issue with our ETL process. I would like to replace the new line characters in 65th field with "nothing" i have return the following code and need help to...

8. Shell Programming and Scripting

Remove carriage return from the variable

Hi, I try to handle very large numbers with a bash script. I run ssh command in a remote server and store the output in a local variable. But this output contains a return carriage at the end. So I try to remove it by tr But I can't figure out the right notation with printf. So my problem...

9. UNIX for Dummies Questions & Answers