Using awk to split a column into two columns


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Using awk to split a column into two columns
# 1  
Old 08-26-2019
Using awk to split a column into two columns

Hi,

I am trying to split the following output into two columns, where each column has Source: Destination:

OUTPUT TO FILTER

Code:
$ tshark -r Capture_without_mtr.pcap -V | awk '/        (Source|Destination): [0-9]/' | more
        Source: x.x.x.x
        Destination: x.x.x.x
        Source: x.x.x.x
        Destination: x.x.x.x
        Source: x.x.x.x
        Destination: x.x.x.x

I am attempting to use the below condition ORS=NR%2?FS:RS (If NR%2, then TRUE condition - FS - default space, else FALSE condition - RS - default \n) however it does not work.

Code:
$ tshark -r Capture_without_mtr.pcap -V | awk '/        (Source|Destination): [0-9]/ {ORS=NR%2?FS:RS}'
$

DESIRED OUTPUT

Code:
$ tshark -r Capture_without_mtr.pcap -V | awk '/        (Source|Destination): [0-9]/' | paste - - | sort | uniq
        Source:x.x.x.x                         Destination: x.x.x.x
        Source: x.x.x.x                        Destination: x.x.x.x
        Source: x.x.x.x                        Destination: x.x.x.x

Can I please get some guidance around what is incorrect?

Thanks.
# 2  
Old 08-26-2019
You don't seem to print out anything, and your search pattern doesn't match the lines. Try
Code:
awk '/(Source|Destination): [x0-9]/ {ORS=NR%2?FS:RS} 1' file
        Source: x.x.x.x         Destination: x.x.x.x
        Source: x.x.x.x         Destination: x.x.x.x
        Source: x.x.x.x         Destination: x.x.x.x

# 3  
Old 08-26-2019
Hi.

An Alternative:
Code:
paste -s -d "\t\n" z1

producing:
Code:
        Source: x.x.x.x         Destination: x.x.x.x
        Source: x.x.x.x         Destination: x.x.x.x
        Source: x.x.x.x         Destination: x.x.x.x

On a system like:
Code:
OS, ker|rel, machine: Linux, 3.16.0-7-amd64, x86_64
Distribution        : Debian 8.11 (jessie) 
paste (GNU coreutils) 8.23

Best wishes ... cheers, drl
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ... (4 Replies)
Discussion started by: ranjancom2000
4 Replies

2. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies

3. UNIX for Dummies Questions & Answers

Split 1 column into numerous columns based on patterns

Hi, I have a text file 'Item_List.txt' containing only 1 column. This column lists different products, each separated by the same generic string header "NEW PRODUCT, VERSION 1.1". After this the name of the product is given, then a delimiter string "PRODUCT FIELD", and then the name of the... (11 Replies)
Discussion started by: mmab
11 Replies

4. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5 (1 Reply)
Discussion started by: jacobs.smith
1 Replies

5. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies

6. Shell Programming and Scripting

Split text separated by ; in a column into multiple columns

Hi, I need help to split a long text in a column which is separated by ; and i need to print them out in multiple columns. My input file is tab-delimited and has 11 columns as below:- aRg02004 21452 asdfwf 21452 21452 4.6e-29 5e-29 -1 3 50 ffg|GGD|9009 14101.10 High class -node. ; ffg|GGD|969... (3 Replies)
Discussion started by: redse171
3 Replies

7. UNIX for Dummies Questions & Answers

Split a column into multiple columns at certain character count

Hey everyone, I have an issue with a client that is passing me a list of values in one column, and occasionally the combination of all the values results in more than an 255 character string. My DB has a 255 character limit, so I am looking to take the column (comma delimited file), and if it... (1 Reply)
Discussion started by: perekl
1 Replies

8. Shell Programming and Scripting

split one column into multiple columns

hey, i have the following data: 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 (7 Replies)
Discussion started by: zaneded
7 Replies

9. UNIX for Dummies Questions & Answers

split one column into multiple columns

hey guys... Im looking to do the following: 1 2 3 4 5 6 7 8 9 Change to: 1 4 7 2 5 8 3 6 9 Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want. (3 Replies)
Discussion started by: zaneded
3 Replies

10. Web Development

split the fields in a column into 3 columns

Have a column "address" which is combination of city, region and postal code like. Format is : city<comma><space>region<space>postal code abc, xyz 123456 All these three city, region and postal code are not mandatory. There can be any one of the above. In that case a nell... (2 Replies)
Discussion started by: rakshit
2 Replies
Login or Register to Ask a Question