Sponsored Content
Top Forums Shell Programming and Scripting 2 carriage return within a record Post 302548252 by agathaeleanor on Thursday 18th of August 2011 12:25:58 AM
Old 08-18-2011
2 carriage return within a record

Hi all,

need your help in replacing carriage return in a record.

Input:
Code:
col1|col2|col3|col4|col5|col6|col7|col8|col9|col10
1|aa|bb|cc|dd|eee
eee|ff|ggggg|hh
hhh|iii
2|zz|yy|xx|ww|vv|uu|tt|ss|rr

Output:
Code:
col1|col2|col3|col4|col5|col6|col7|col8|col9|col10
1|aa|bb|cc|dd|eee:::eee|ff|ggggg|hh:::hhh|iii
2|zz|yy|xx|ww|vv|uu|tt|ss|rr

Currently i execute script to get rid of carriage return, but it concatenates records start from line2 into one whole record
Code:
grep -v '^$' Input.txt | nawk -F\| 'FNR==1{n=NF}NF<n{for (i=1;i<=n;i++) if (i<n) {l=$0;getline;$0=l":::"$0}}1'

col1|col2|col3|col4|col5|col6|col7|col8|col9|col10
1|aa|bb|cc|dd|eee:::eee|ff|ggggg|hh:::hhh|iii:::2|zz|yy|xx|ww|vv|uu|tt|ss|rr

Your help is much appreciate.

Moderator's Comments:
Mod Comment Please use code tags, thanks.

Last edited by zaxxon; 08-18-2011 at 01:59 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Capture carriage return.

I try to test the carriage return in a variable. $ LENGTH=`expr $VARIABLE : ".*"` will return the length of the variable. But this doesn't work if $VARIABLE has zero length. Any help will be well appreciated. Thanks in advance. Giovanni (4 Replies)
Discussion started by: gio123bg
4 Replies

2. Shell Programming and Scripting

Removing Carriage return to create one record

I have a file with multiple records in it and want to create a single record by removing all the carriage returns, is there a sed command or another command that will easily allow this to happen. current layout 813209A 813273C 812272B expected result 813209A813273C812272B previously I... (3 Replies)
Discussion started by: r1500
3 Replies

3. Shell Programming and Scripting

Dont want carriage return

I have observed with print & echo, they produce carriage return <CR> or newline, after they display string next to them. Is there anyway to avoide these <CR> after the intended string is displayed? (3 Replies)
Discussion started by: videsh77
3 Replies

4. UNIX for Dummies Questions & Answers

carriage return and linefeed

hi can anyone please tell me the difference between carriage return, linefeed and newline ? (2 Replies)
Discussion started by: streetfi8er
2 Replies

5. Shell Programming and Scripting

Lost carriage return when assign

Hello . Now i have a different problem, lost "carriage return" when assigning a variable. The assignation is done in a peculair way but its ok. The variable "v_tmp" have spaces and carriage return. Its created with v_tmp=`echo $i | awk '.........'` And the assignation where i lost all the... (6 Replies)
Discussion started by: trutoman
6 Replies

6. Shell Programming and Scripting

Remove carriage return in a record

Hi all gurus, I need help in removing carriage return existed within a record delimited by pipe <|>. Sample: A_01|Test1|Testing1|Remarks1 A_02|Test2|Test ing2|Remarks2 A_03|Test3|Testing3| Remarks3 Desire output: A_01|Test1|Testing1|Remarks1 A_02|Test2|Testing2|Remarks2... (10 Replies)
Discussion started by: agathaeleanor
10 Replies

7. Shell Programming and Scripting

Search_Replace with a Carriage Return

Hey folks, I've been working on this for some time. Seems simple, but I'm stumped. I need the following data format: New_York:Commercial Geology Geophysics Petrophysics Production_Engineering Reservoir_Engineering Pasadena:Commercial ... (5 Replies)
Discussion started by: leepet01
5 Replies

8. Shell Programming and Scripting

Carriage return ksh

Hello, How do i usecarriage return in ksh. I want to do an echo "bla bla" and another echo "bla bla" will appear and replace the first echo on screen. I tried: until ; do echo "bla bla \r" done please advice. Thanks. (3 Replies)
Discussion started by: LiorAmitai
3 Replies

9. Shell Programming and Scripting

Substitute \n with carriage return

Hello all, I've a flat file in the following format: AB\001\CDED\001\ABC\001\nEG\001\HIJF\001\EFG\001\nHI\003\HIUL\003\HIJ\003 And I want to substitute \n with the carriage return. Any help is appreciated! Regards, - Seth (8 Replies)
Discussion started by: sethmj
8 Replies

10. UNIX for Dummies Questions & Answers

Remove carriage return

I need to remove the carriage return comes inbetween the record. Need to have CR only at the end. I used the below command. tr -d '\n' < filewithcarriagereturns > filewithoutcarriagereturns But its removing all the CR and giving one line output. Input File: 12345 abcdegh... (11 Replies)
Discussion started by: srvn_saru
11 Replies
SLUGIMAGE(1)						      General Commands Manual						      SLUGIMAGE(1)

NAME
slugimage - Manipulate NSLU2 firmware images SYNOPSIS
slugimage [-p|-u] [options] DESCRIPTION
slugimage can be used to create or unpack NSLU2 firmware images. OPTIONS
-d, --debug Turn on debugging output -q, --quiet Turn off status messages -u, --unpack Unpack a firmware image -p, --pack Pack a firmware image -l, --little Convert Kernel and Ramdisk to little-endian -i, --input Input firmware image filename -o, --output Output firmware image filename -b, --redboot Input/Output RedBoot filename -k, --kernel Input/Ouptut Kernel filename -s, --sysconf Input/Output SysConf filename -r, --ramdisk Input/Output Ramdisk filename(s) -f, --fisdir Input/Output FIS directory filename -y, --payload Input/Output Payload filename -t, --trailer Input/Output Trailer filename -e, --ethaddr Set the Ethernet address AUTHOR
This man page was written by Joey Hess, <joey@kitenet.net>. SLUGIMAGE(1)
All times are GMT -4. The time now is 03:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy