Character screening and paste into newfile in columns instead of rows Post: 302999073

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Character screening and paste into newfile in columns instead of rows Post 302999073 by Ankit Vyas on Tuesday 13th of June 2017 03:58:39 AM

Old

06-13-2017

Registered User

Hammer & Screwdriver

Character screening and paste into newfile in columns instead of rows

QL10169_SAUJANA%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KCRN11,MeContext=QL10169_SAUJANA_5
%External_Link_Failure
%X2_link_problem_to_one_or_several_neighbouring_eNodeBs.
QL10187_MATANG_JAYA_2%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KUCHING,MeContext=QL10187_MATANG_JAY A_2_3
%External_Link_Failure
%X2_link_problem_to_one_or_several_neighbouring_eNodeBs.
QL10192_JLNKRUKUP%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_MRRN13,MeContext=QL10192_JLNKRUKUP_1
%External_Link_Failure
%X2_link_problem_to_one_or_several_neighbouring_eNodeBs.

Above is the example, i want to do something like below,
1.Check first character of everyline if it is not % then print in the new file.
2.Read secondline if it is "%", then it should paste into the 2nd column of the first line which already pasted.
3.like wise till end of the line.

Can someone pls help on this

Ankit Vyas

View Public Profile for Ankit Vyas

Find all posts by Ankit Vyas

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cut and paste columns using awk

Hi, Let's say that I have a file called table, I know that if I need to see a the second column for exampls I use: awk ' {print $2}' table.txt Is there anyway to use awk to actually cut a column and put it somewhere else in the table?:confused:

2. Shell Programming and Scripting

appending several columns with awk and paste

Hello, I am trying to solve for a couple of hours now the following problem: I have n files and would like to add the third column of each file to a new file: temp1.txt 1 2 3 1 2 3 1 2 3 temp2.txt 1 2 4 1 2 4 1 2 4 1 2 4 temp3.txt

3. Emergency UNIX and Linux Support

awk- add columns and make new column and save as newfile

Hi, I have file as below: 5 6 7 4 8 9 3 5 6 output needs to be another file with 4th column as $1+$2 and 5th column as $3+$4. sample output file 5 6 7 11 18 4 8 9 12 21 3 5 6 8 14 Anybody have answer Thanks in advance

4. Shell Programming and Scripting

Paste second columns from files to its corresponding file

Hi All, I have two sets of files. One set with extension .txt This set has file names with numbers like these. 1.txt, 2.txt, 3.txt until extactly 100.txt. The .txt files look like these: 0.38701788 93750 0.38622013 94456 0.38350296 94440 0.38282126 94057 0.38282126 94439 0.35847232...

5. Shell Programming and Scripting

split paste them in rows

Hi, I have a file as ABC 123_456_789 234_678_901 XYZ 1100_1250_1580_1680 1175_1440_1620_1890 so on What I want my output file to look is "split by underscore and then place the contents in rows" output ABC 123 234 ABC 456 678 ABC 789 901 XYZ 1100 1175 XYZ 1250 1440...

6. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and...

7. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I...

8. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'...

9. Shell Programming and Scripting

Character screening and paste into new file in columns instead of rows

QL10169_SAUJANA%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KCRN11,MeContext=QL10169_SAUJANA_5 %External_Link_Failure %X2_link_problem_to_one_or_several_neighbouring_eNodeBs. QL10187_MATANG_JAYA_2%SubNetwork=ONRM_ROOT_MO_R,SubNetwork=ERBS_KUCHING,MeContext=QL10187_MATANG_JAY A_2_3...

10. UNIX for Beginners Questions & Answers

awk command to paste 1st columns of 2 files.

I have 2 files contains more than 5000 lines, I want to paste the 1st column of both file in an output file using awk. Please suggest to me I had tried paste command but it merges my both column. --- Post updated at 10:26 PM --- file1.txt 2020-01-07 235400 2020-01-07 235400 2020-01-07...

LEARN ABOUT OPENSOLARIS

ng_atmllc

NG_ATMLLC(4)                                               BSD Kernel Interfaces Manual                                               NG_ATMLLC(4)

NAME

     ng_atmllc -- ATM LLC netgraph node type

SYNOPSIS

     #include <netgraph/ng_atmllc.h>

DESCRIPTION

     The atmllc node type translates frames in to and out of ATM LLC encapsulation, as specified by RFC 1483.  In LLC encapsulation the protocol
     of a given protocol data unit (PDU) is specified by an IEEE 802.2 LLC header, possibly followed by an IEEE 802.1a SubNetwork Attachment Point
     (SNAP) header.  This node currently handles the Ethernet and FDDI protocols.

     The node transmits and receives ATM PDUs on the atm hook.  Received PDUs are decoded and forwarded to the ether or fddi hooks as appropriate.
     Data received on the ether or fddi hooks are assumed to be full Ethernet or FDDI packets as appropriate and are encapsulated into a PDU and
     transmitted via the atm hook.

HOOKS

     This node type supports the following hooks:

     atm     ATM connection.  Typically, this hook would be connected to a ng_atm(4) node, which handles transmission of ATM PDUs over an ATM
             device.

     ether   Ethernet connection.  This hook sends and receives Ethernet frames.  This would normally be connected to an ng_eiface(4) node if in
             use.

     fddi    FDDI connection.  This hook sends and receives FDDI frames.

CONTROL MESSAGES

     This node type supports the generic control messages.

SHUTDOWN

     This node shuts down upon receipt of a NGM_SHUTDOWN control message, or when all hooks have been disconnected.

SEE ALSO

     netgraph(4), ng_atm(4), ng_eiface(4), ngctl(8)

     J. Heinanen, Multiprotocol Encapsulation over ATM Adaptation Layer 5, RFC 1483.

AUTHORS

     Benno Rice <benno@FreeBSD.org>

BSD                                                                March 8, 2004                                                               BSD