Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Row separator

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Row separator
# 1  
Old 10-02-2014
Row separator
Hello All,
I need help with the below, I would appreciate any tip.

I have a file as below

Code:
 
 Input file
 Apple: Green
 Banana: Yellow
 Grapes: Black
 Apple: Red
 Banana: Green
 Grapes: Green
 Grapes: Brown
 Apple: Pale Red
 Banana: Greenish yellow
 Grapes: Brown
 Apple: Yellowish Red
 Banana: Pale Brown
 Grapes: BlackSeedless
  
 Output file:
  
 ---------------
 Apple: Green
 Banana: Yellow
 Grapes: Black
 ---------------
 Apple: Red
 Banana: Green
 Grapes: Green
 Grapes: Brown
 ---------------
 Apple: Pale Red
 Banana: Greenish yellow
 Grapes: Brown
 ---------------
 Apple: Yellowish Red
 Banana: Pale Brown
 Grapes: BlackSeedless

i.e. I want to add a header "-------" at start of the line with Apple, like the file should add header when it sees Apple.

Any help is much appreciated.
# 2  
Old 10-02-2014
You could use sed for this simple replacement:

Code:
sed 's/^Apple:/---------------\n&/' infile > outfile

# 3  
Old 10-02-2014
Nope, I am still seeing the same
Code:
 root@test1:/tmp# cat fru
 Apple: Green
 Banana: Yellow
 Grapes: Black
 Apple: Red
 Banana: Green
 Grapes: Green
 Grapes: Brown
 Apple: Pale Red
 Banana: Greenish yellow
 Grapes: Brown
 Apple: Yellowish Red
 Banana: Pale Brown
 Grapes: BlackSeedless
  
 
 root@test1:/tmp# sed 's/^Apple:/---------------\n&/' fru
 Apple: Green
 Banana: Yellow
 Grapes: Black
 Apple: Red
 Banana: Green
 Grapes: Green
 Grapes: Brown
 Apple: Pale Red
 Banana: Greenish yellow
 Grapes: Brown
 Apple: Yellowish Red
 Banana: Pale Brown
 Grapes: BlackSeedless

# 4  
Old 10-02-2014
That should had worked, unless that there is white space in front of `Apple'.
In that case, remove the `^' from it.
# 5  
Old 10-02-2014
Yahoo! it works but, I still see that Apple is not taking a new line?
It is on same line as dashes (----------).
Code:
 root@test1:/home/user1# sed 's/Apple:/---------------\n&/' /tmp/fru
 ---------------nApple: Green
 Banana: Yellow
 Grapes: Black
 ---------------nApple: Red
 Banana: Green
 Grapes: Green
 Grapes: Brown
 ---------------nApple: Pale Red
 Banana: Greenish yellow
 Grapes: Brown
 ---------------nApple: Yellowish Red
 Banana: Pale Brown
 Grapes: BlackSeedless

Last edited by m6248m; 10-02-2014 at 05:56 PM.. Reason: Corrected the wording
# 6  
Old 10-02-2014
Does this work better?

Code:
perl -wlpe '/Apple:/ and print "----------------";' fru

# 7  
Old 10-02-2014
Oops! I don't have perl Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Keep only the closet match of timestamped row (include headers) from file1 to precede file2 row/s

This is a question that is related to one I had last August when I was trying to sort/merge two files by millsecond time column (in this case column 6). The script (below) that helped me last august by RudiC solved the puzzle of sorting/merging two files by time, except it gets lost when the... (0 Replies)
Discussion started by: aachave1
0 Replies

2. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Hi ALL, We have requirement in a file, i have multiple rows. Example below: Input file rows 01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212 01,1,102319,0,1,80,20,U,1,241,00000059420000006021 I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies

3. UNIX for Beginners Questions & Answers

Keep only the closet match of timestamped row (include headers) from file1 to precede file2 row/s

My original files are like this below and I distinguish them from the AP_ID (file1 has 572 and file2 has 544). Also, the header on file1 has “G_” pre-pended. NOTE: these are only snippets of very large files and much of the data is not present here. Original File 1: ... (36 Replies)
Discussion started by: aachave1
36 Replies

4. Shell Programming and Scripting

Create multiple files from single file based on row separator

Hello , Can anyone please help me to solve the below - Input.txt source table abc col1 char col2 number source table bcd col1 date col2 char output should be 2 files based on the row separator "source table" abc.txt col1 char (6 Replies)
Discussion started by: Pratik4891
6 Replies

5. Shell Programming and Scripting

Add Row from First Row (Split Row)

HI Guys, I have Below Input :- RepigA_hteis522 ReptCfiEtrBsCll_aofe MSL04_MSL2_A25_1A 0 9 MSL04_MSL2_A25_1B 0 9 MSL04_MSL2_A25_1C 0 9 RepigA ReptCfiEtrBsCll hteis522 aofe MSL04_MSL2_A25_1A 0 9 MSL04_MSL2_A25_1B 0 9 MSL04_MSL2_A25_1C 0 9 Split Data in two first row... (2 Replies)
Discussion started by: pareshkp
2 Replies

6. Shell Programming and Scripting

row separator with RS

I have a file contains lines such as below: HRS ? ? ? Pg ? 20120811 1223 19.6 GAU 1.00e-01 0.00e-01 0.00e-01 0.00e-01 TBZ ? ? ? Pg ? 20120811 1223 26.2 GAU 1.00e-01 0.00e-01 0.00e-01 0.00e-01 ### HRS ? ? ? Pg ? 20120811 1228 52.2 GAU 1.00e-01 0.00e-01 0.00e-01 0.00e-01 ### ... (4 Replies)
Discussion started by: saeed.soltani
4 Replies

7. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

8. UNIX for Dummies Questions & Answers

Shell Script: Traverse Database Table Row by Row

Hello Everyone, My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row. I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table. Please help. Thanks &... (5 Replies)
Discussion started by: ahsan.asghar
5 Replies

9. UNIX for Dummies Questions & Answers

How to calculate the percentage/fraction of each value in a row against the maximum row value?

Hi, For each row in a file, i would like to identify the maximum value and calculate the percentage/fraction of the max for other values in the row. Then, I would like to print a copy of the file where values above a threshold are replaced with "1" and other values are left as "0". In the... (2 Replies)
Discussion started by: auburn
2 Replies

10. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies
Login or Register to Ask a Question