Sponsored Content
Top Forums Shell Programming and Scripting How to remove new line characters from data rows in a Pipe delimited file? Post 303041254 by styris on Tuesday 19th of November 2019 12:29:27 PM
Old 11-19-2019
How to remove new line characters from data rows in a Pipe delimited file?

I have a file as below

Code:
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
2345|FirstName2|MiddleName3|LastName4|
 Add1 || ADD2|
 234|000000000

OUTPUT :
Code:
Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber
1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000
2345|FirstName2|MiddleName3|LastName4| Add1 || ADD2|234|000000000


Last edited by RavinderSingh13; 11-19-2019 at 01:39 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove new line characters from a partcular column data

Dear friends, I have a pipe delimited file having 5 columns. However the column no-3 is having extra new line characters as the data owing to owing , I am having issues. Ideally my file should have only newline termination at the end of each record and not within column data of any of... (1 Reply)
Discussion started by: sureshg_sampat
1 Replies

2. Shell Programming and Scripting

Remove SPACES between PIPE delimited file

This is my input file with extra information in the HEADER and leading & trailing SPACES between PIPE delimiter. 02/04/2010 Dynamic List Display 1 --------------------------------------------------------------------------------------... (6 Replies)
Discussion started by: srimitta
6 Replies

3. Shell Programming and Scripting

Selecting rows from a pipe delimited file based on condition

HI all, I have a simple challenge for you.. I have the following pipe delimited file 2345|98|1809||x|969|0 2345|98|0809||y|0|537 2345|97|9809||x|544|0 2345|97|0909||y|0|651 9685|98|7809||x|321|0 9685|98|7909||y|0|357 9685|98|7809||x|687|0 9685|98|0809||y|0|234 2315|98|0809||x|564|0 ... (2 Replies)
Discussion started by: nithins007
2 Replies

4. Shell Programming and Scripting

Help with converting Pipe delimited file to Tab Delimited

I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use cat file | sed 's/|//t/g' The above command substituted "/t" not tab in the place of pipe. Sample file: abc|123|2012-01-30|2012-04-28|xyz have to convert to: abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies

5. UNIX for Dummies Questions & Answers

find string and get the rest of the line in a pipe delimited file

Hi friends, I have a file where I should search for a string and get the rest of the line but without the delimiter using awk. for example I have the series of string in a file: input_string.txt bbb ccc aaa and the mapping file looks like this. mapping.txt aaa|12 bbb|23 ccc|43... (11 Replies)
Discussion started by: kokoro
11 Replies

6. Shell Programming and Scripting

Find for line with not null values at nth place in pipe delimited file

Hi, I am trying to find the lines in a pipe delimited file where 11th column has not null values. Any help is appreciated. Need help asap please. thanks in advance. (3 Replies)
Discussion started by: manikms
3 Replies

7. Shell Programming and Scripting

Remove few columns from pipe delimited file

I have file as below column1|column2|column3|column4|column5| fill1|fill2|fill3|fill4|fill5| abc1|abc2|abc3|abc4|abc5| . . . . i need to remove column2,3, from that file column1|column4|column5| fill1|fill4|fill5| abc1|abc4|abc5| . . . (3 Replies)
Discussion started by: greenworld123
3 Replies

8. Shell Programming and Scripting

To remove duplicates from pipe delimited file

Hi some one please help me to remove duplicates from a pipe delimited file based on first two columns. 123|asdf|sfsd|qwrer 431|yui|qwer|opws 123|asdf|pol|njio Here My first record and last record are duplicates.As per my requirement I want all the latest records into one file. I want the... (12 Replies)
Discussion started by: ginrkf
12 Replies

9. Shell Programming and Scripting

How to remove alphabets/special characters/space in the 5th field of a tab delimited file?

Thank you for 4 looking this post. We have a tab delimited file where we are facing problem in a lot of funny character. I have tried using awk but failed that is not working. In the 5th field ID which is supposed to be a integer only of that file, we are getting corrupted data as below. I... (12 Replies)
Discussion started by: Srithar
12 Replies

10. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies
gdcmpdf(1)							       GDCM								gdcmpdf(1)

NAME
gdcmpdf - Tool to convert PDF to PDF/DICOM. SYNOPSIS
gdcmpdf [options] file-in file-out DESCRIPTION
The gdcmpdf tool convert a PDF file (any PDF version) into an encapsulated PDF/DICOM file. By default it will try to read the PDF meta information stored in the PDF and convert this information to some specific DICOM fields (see below). However it may fails (eg. wrong password on encrypted PDF file) in which case empty value are used. PARAMETERS
file-in PDF input filename file-out DICOM output filename options general options -h --help print this help text and exit -v --version print version information and exit -V --verbose verbose mode (warning+error). -W --warning warning mode, print warning information -E --error error mode, print error information -D --debug debug mode, print debug information Usage Example $ wget http://gdcm.sourceforge.net/gdcm.pdf $ gdcmpdf gdcm.pdf gdcm.dcm To re-extract the encapsulated pdf file: $ gdcmraw -i gdcm.dcm -t 42,11 -o gdcm.dcm.pdf $ diff gdcm.pdf gdcm.dcm.pdf PDF Info Mapping Here is how the PDF info is mapped to DICOM information (typical pdfinfo output): Title: GDCM Reference Manual Subject: Grassroots DICOM API reference Keywords: GDCM,DICOM,JPEG,Lossless JPEG,JPEG-LS,J2K,JPEG 2000,RLE Author: Mathieu Malaterre and co. Creator: LaTeX with hyperref package Producer: pdfeTeX-1.21a CreationDate: Tue Apr 28 15:34:26 2009 Tagged: no Pages: 1188 Encrypted: no Page size: 612 x 792 pts (letter) File size: 13756841 bytes Optimized: yes PDF version: 1.4 Converted to DICOM this leads to: # Dicom-Data-Set # Used TransferSyntax: Little Endian Explicit (0008,0005) CS [ISO_IR 100] # 10, 1 SpecificCharacterSet (0008,0012) DA [20090428] # 8, 1 InstanceCreationDate (0008,0013) TM [182550.302631] # 14, 1 InstanceCreationTime (0008,0016) UI =EncapsulatedPDFStorage # 30, 1 SOPClassUID (0008,0018) UI [1.2.826.0.1.3680043.2.1143.776842935192792959289022034349197114] # 64, 1 SOPInstanceUID (0008,0020) DA [20090428] # 8, 1 StudyDate (0008,0023) DA [20090428] # 8, 1 ContentDate (0008,002a) DT [20090428153437.000000] # 22, 1 AcquisitionDateTime (0008,0030) TM [182550.302160] # 14, 1 StudyTime (0008,0033) TM [153426.000000] # 14, 1 ContentTime (0008,0050) SH (no value available) # 0, 0 AccessionNumber (0008,0060) CS [OT] # 2, 1 Modality (0008,0064) CS [WSD] # 4, 1 ConversionType (0008,0070) LO [LaTeX with hyperref package] # 28, 1 Manufacturer (0008,0090) PN (no value available) # 0, 0 ReferringPhysiciansName (0010,0010) PN [Mathieu Malaterre and co.] # 26, 1 PatientsName (0010,0020) LO (no value available) # 0, 0 PatientID (0010,0030) DA (no value available) # 0, 0 PatientsBirthDate (0010,0040) CS (no value available) # 0, 0 PatientsSex (0018,1020) LO [pdfeTeX-1.21a] # 14, 1 SoftwareVersions (0020,000d) UI [1.2.826.0.1.3680043.2.1143.1868121832223417351654232480755123133] # 64, 1 StudyInstanceUID (0020,000e) UI [1.2.826.0.1.3680043.2.1143.1330099150825746617507846107663964311] # 64, 1 SeriesInstanceUID (0020,0010) SH (no value available) # 0, 0 StudyID (0020,0011) IS [1] # 2, 1 SeriesNumber (0020,0013) IS [1] # 2, 1 InstanceNumber (0028,0301) CS [YES] # 4, 1 BurnedInAnnotation (0040,a043) SQ (Sequence with explicit length #=0) # 0, 1 ConceptNameCodeSequence (fffe,e0dd) na (SequenceDelimitationItem for re-encod.) # 0, 0 SequenceDelimitationItem (0042,0010) ST [GDCM Reference Manual] # 22, 1 DocumentTitle (0042,0011) OB 255044462d312e34a25e7f3cfd3a33323037372030... # 13756842, 1 EncapsulatedDocument (0042,0012) LO [application/pdf] # 16, 1 MIMETypeOfEncapsulatedDocument $ stat gdcm.pdf File: `gdcm.pdf' Size: 13756841 Blocks: 26912 IO Block: 4096 regular file Device: fe01h/65025d Inode: 2675750 Links: 1 Access: (0644/-rw-r--r--) Uid: ( 1002/mmalaterre) Gid: ( 1002/mmalaterre) Access: 2009-04-28 16:05:00.000000000 +0200 Modify: 2009-04-28 15:34:37.000000000 +0200 Change: 2009-04-28 16:05:00.000000000 +0200 Explanation for the different Date/Time mappings: o Study Date/Time, Instance Creation Date/Time are both equal to the current time gdcmpdf tool was run, o Acquisition Date Time is set to the Modify Time of the actual pdf file, o Content Date/Time are set from the actual PDF header info: CreationDate. SEE ALSO
gdcmconv(1), gdcmraw(1), pdfinfo(1) COPYRIGHT
Copyright (c) 2006-2011 Mathieu Malaterre Version 2.2.0 Tue Feb 5 2013 gdcmpdf(1)
All times are GMT -4. The time now is 09:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy