Search_Replace with a Carriage Return


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Search_Replace with a Carriage Return
# 1  
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:
Code:
New_York:Commercial
         Geology
         Geophysics
         Petrophysics
         Production_Engineering
         Reservoir_Engineering
Pasadena:Commercial
         Geology
         Geophysics
         Petrophysics
         Production_Engineering
         Reservoir_Engineering

To look like this:
Code:
New_York
        Commercial
        Geology
        Geophysics
        Petrophysics
        Production_Engineering
        Reservoir_Engineering
Pasadena
        Commercial
        Geology
        Geophysics
        Petrophysics
        Production_Engineering
        Reservoir_Engineering

I've used this command successfully in VI:
Code:
s/:/^M        /g

But cannot seem to get it right within a script. I use the following line:
Code:
sed -e 's/:/^M      /g' filename

but it will remove the "New_York:" which is what I need.

Any help would be greatly appreciated.

Thank You!
# 2  
You can try:
Code:
tr ':' '\n' < File

# 3  
Are you sure it's actually removing it, and not just a display issue?

e.g. this works fine on cygwin:
Code:
$ sed -e 's/:/\n\t/g' x.txt
New_York
        Commercial
         Geology
         Geophysics
         Petrophysics
         Production_Engineering
         Reservoir_Engineering
Pasadena
        Commercial
         Geology
         Geophysics
         Petrophysics
         Production_Engineering
         Reservoir_Engineering

# 4  
Carriage return and newline are not the same thing.

Carriage return moves to the beginning of the line but does not move it down -- probably causing the display issue you saw.

Newline, \n, moves it down one line and moves the cursor to the beginning of the line.
# 5  
I'm working this through Exceed on Demand. It might be a display issue, but this script will be deployed globally and all that will be using it will be seeing what I'm seeing.

Using the "sed -e 's/:/\n\t/g' " removed the ":" but didn't place a new line. However, the tr command worked.

Thanks!
# 6  
Quote:
Originally Posted by leepet01
Using the "sed -e 's/:/\n\t/g' " removed the ":" but didn't place a new line. However, the tr command worked.

Thanks!
You might have a crummy old sed which doesn't even support \n.
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #648
Difficulty: Medium
Window Maker was written from scratch by Tim Berners-Lee, best known as the inventor of the World Wide Web.
True or False?

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. Shell Programming and Scripting

2 carriage return within a record

Hi all, need your help in replacing carriage return in a record. Input: 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: col1|col2|col3|col4|col5|col6|col7|col8|col9|col10... (12 Replies)
Discussion started by: agathaeleanor
12 Replies

5. 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

6. 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

7. 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

8. 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

9. Shell Programming and Scripting

carriage return/line feeds

Hello, I have a file that has got carriage returns in it and I want to take them out. Anyone know how I can do this in a ksh? thanks (4 Replies)
Discussion started by: pitstop
4 Replies

10. UNIX for Advanced & Expert Users

carriage return stamp online

hi all, someone knows why the carriare return on txseries-aix don't work? exsample: i have: 01 TESTATA-INIZIO. 03 TESTA-NL1 PIC X. 03 R-TESTA1. 05 FILLER PIC X(70) VALUE SPACE. 05 DATA-ST1 PIC... (11 Replies)
Discussion started by: tullo
11 Replies

Featured Tech Videos