Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need to add prefix using sed or awk from cat the file
Top Forums Shell Programming and Scripting Need to add prefix using sed or awk from cat the file Post 303006120 by ranjancom2000 on Friday 27th of October 2017 09:31:44 AM
Old 10-27-2017
Thanks i am search in google not able to find the right code. It work great if i have any doubt on procession i will come back

---------- Post updated at 08:31 AM ---------- Previous update was at 07:17 AM ----------

Hi RudiC

Could you please help to provide a solution using awk or diff command. I need to add one more prefix by compare a file input. Since the file very large it will contain more then 10k devs. I can't compare in loop. Instead in want to use diff or some other compare command

Real file
Code:
Node1,dev2,nofast,TDEV RW 1035788
Node1,dev10,nofast,TDEV RW 1035788
Server1,dev14,nofast,TDEV RW 69053
Server2,dev4,nofast,TDEV RW 69053
Server2,dev1,nofast,TDEV RW 103579
Server3,dev7,nofast,TDEV RW 69053
server4,dev11    RDF1+TDEV RW 69053
server4,dev9    RDF1+TDEV RW 517894
server4,dev3    RDF1+TDEV RW 621473
server6,dev5,nofast,TDEV RW 34526
server6,dev8,nofast,TDEV RW 34526
server6,dev13    RDF1+TDEV RW 34526
server6,dev12    RDF1+TDEV RW 34526
server6,dev6,nofast,TDEV RW 34526

Code:
The input file will have 20k devs like that 

dev14
dev15
dev16
dev17
dev18
dev19
dev20
dev21
dev1
dev23
dev24
dev25

I need output will be like this "nofast,T1"

Code:
Server1,dev14,nofast,T1,TDEV RW 69053
Server2,dev4,nofast,TDEV RW 69053
Server2,dev1,nofast,T1,TDEV RW 103579
Server3,dev7,nofast,TDEV RW 69053
server4,dev11    RDF1+TDEV RW 69053
server4,dev9    RDF1+TDEV RW 517894
server4,dev3    RDF1+TDEV RW 621473
server6,dev5,nofast,TDEV RW 34526
server6,dev8,nofast,TDEV RW 34526
server6,dev13    RDF1+TDEV RW 34526
server6,dev12    RDF1+TDEV RW 34526
server6,dev6,nofast,TDEV RW 34526

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem to add the string(without sed & awk) into the middle of file

Hi, I have tried many times to add the string into the first line of the file or the middle of the file but could not find the solution. I first tried by $echo "paki" >> file This code only append paki string at the end of file "file" but how can i add this "paki" into the first line or... (5 Replies)
Discussion started by: ali hussain
5 Replies

2. UNIX for Dummies Questions & Answers

tr, sed, awk, cat or scripting

I need to change all Newline caracters (\12) to Fieldseparator(\34). tr -A '\12' '\34' <file1> file2 Replace all delete (\177) with Newline (\12) tr -A '\177' '\12' <file2> file3 Put the name of the file first in all rows. awk '{printf "%s\34%s\n", FILENAME,$0} file3 > file4 So far no... (6 Replies)
Discussion started by: MrKlint
6 Replies

3. Shell Programming and Scripting

Remove prefix using awk

Remove prefix using awk File: nawk -F"|" '{if ($1 ~ /^xyz./) print; else { gsub(.*\..*, \..*, $1) ;print }}' file Error: ouput required: (5 Replies)
Discussion started by: pinnacle
5 Replies

4. Shell Programming and Scripting

Need awk script to add a prefix to each line in file

Hello , I have file with below content : '165567885', '165568443', '165568805', I need an awk script that would add a prefix zero after first ' . Like '0165567885', '0165568443', '0165568805', Please help. Thanks in advance. (5 Replies)
Discussion started by: rmv
5 Replies

5. Shell Programming and Scripting

awk or sed to add field in a text file

Hi there, I have a csv file with some columns comma sepated like this : 4502-17,PETER,ITA2,LEGUE,92,ME - HALF,23/05/10 15:00 4502-18,CARL,ITA2,LEGUE,96,ME - HALF,20/01/09 14:00 4502-19,OTTO,ITA2,LEGUE,97,ME - MARY,23/05/10 15:00 As you can see the column n. 7 is a timestamp column, I need... (23 Replies)
Discussion started by: capnino
23 Replies

6. Linux

Adding a prefix to a column using awk/sed commands

Hello, I am a newbie to linux and struggling to find a better way to append a column in a text file. Here is the file i want to modify: It has 8 columns (and thousands of rows). I want to append the first column by adding "chr" infront of the numbers. Some rows have a string in the first... (4 Replies)
Discussion started by: bjorngill
4 Replies

7. UNIX for Dummies Questions & Answers

How to pass cat file in awk statement?

Hi, I am working on kernel parameters, want to check values under /proc/sys/kernel below I tried for kernel.sem SEMMNS: 4096 cat /proc/sys/kernel/sem | awk '{print $2}' awk '{ if ($2 < 33000) print }' /proc/sys/kernel/sem |awk '{print $2}' 32000 The above... (7 Replies)
Discussion started by: stew
7 Replies

8. Shell Programming and Scripting

Extract Uniq prefix from a start and end prefix

Dear All, assume i have a file with content: <Start>6000</Start> <Stop>7599</Stop> the output is: 6000 7000 7100 7200 7300 7400 7599 how should we use any awk, sed, perl can do this task, means to extract the uniq prefixes from the start and stop prefix. Thanks Jimmy (3 Replies)
Discussion started by: jimmy_y
3 Replies

9. Shell Programming and Scripting

awk move select fields to match file prefix in two directories

In the awk below I am trying to use the file1 as a match to file2. In file2 the contents of $5,&6,and $7 (always tab-delimited) and are copied to the output under the header Quality metrics. The below executes but the output is empty. I have added comments to help and show my thinking. Thank you... (0 Replies)
Discussion started by: cmccabe
0 Replies

10. Shell Programming and Scripting

Add the word "prefix" to beginning of line using sed

SUSE linux bash shell this works test -d /tmpp && echo "directory exists" || echo "directory doesn't exists" |sed -e "s/^/prefix /" prefix directory doesn't exists but why doesn't this work? test -d /tmp && echo "directory exists" || echo "directory doesn't exists" |sed -e... (3 Replies)
Discussion started by: snoman1
3 Replies

LEARN ABOUT V7

flist

FLIST(1)							     [nmh-1.5]								  FLIST(1)

NAME

       flist, flists - list the number of messages in given sequence(s)

SYNOPSIS

       flist [+folder1 [+folder2 ...]]	[-sequence name1 [-sequence name2 ...]]  [-all | -noall] [-showzero | -noshowzero] [-recurse | -norecurse]
	    [-fast | -nofast] [-alpha | -noalpha] [-version] [-help]

       flists is equivalent to flist -all

DESCRIPTION

       Flist is used to search a list of folders and display the number of messages in these folders that are  in  a  given  sequence  or  set	of
       sequences (for example the "unseen" sequence). This is especially useful if you use some mechanism such as slocal or procmail (typically in
       conjunction with rcvstore) to pre-sort your mail into different folders before you view it.

       By default, the command flist will search the current folder for the given sequence or sequences (usually "unseen").  If  (possibly  multi-
       ple)  folders  are  specified  on the command line with +folder, then all these folders are searched for the given sequence(s).	Flist will
       display for each folder searched, the number of messages in each of the specified sequences, and the total number of messages.

       The option -sequence is used to specify the name of a sequence in which to search for.  This option may be used multiple times  to  specify
       multiple  sequences.   If this is not given, then the default is to search for all the sequences specified by the "Unseen-Sequence" profile
       component. For more details about sequences, read the mh-sequence(5) man page.

       Typically, flist will produce a line for each sequence, for every folder that is searched, even those which do not contain any messages	in
       the  given  sequence.   Specifying -noshowzero will cause flist to print only those folder/sequence combinations such the folder has a non-
       zero number of messages in the given specified sequence.

       If -recurse is given, then for each folder that is search, flist will also recursively descend into those folders to search subfolders  for
       the given sequence.

       If  -fast  is given, only the names of the folders searched will be displayed, and flist will suppress all other output.  If this option is
       used in conjunction with -noshowzero, then flist will only print the names of those folders searched that contain messages in in  at  least
       one of the specified sequences.

   Multiple Folders
       If  the	option	-all  is given (and no folders are specified with +folder), then flist will search all the folders in the top level of the
       users nmh directory.  These folders are all preceded by the read-only folders, which occur as "atr-cur-" entries in the user's nmh context.

       An example of the output of flist -all is:

	    /work/Mail	has  5 in sequence unseen (private); out of  46
	    inbox+	has 10 in sequence unseen	   ; out of 153
	    junklist	has  0 in sequence unseen	   ; out of  63
	    postmaster	has  1 in sequence unseen	   ; out of   3

       The "+" after inbox indicates that it is the current folder.

       The "private" flag indicates that the given sequence for that folder is private.  See the mh-sequence(5) man page for details about private
       sequences.

       If  the	option	-all  and +folder are both specified, then flist will search this folder, and all its first level subfolders for the given
       sequence.  You may specify multiple folders in this way.

       If flist is invoked by a name ending with "s" (e.g.  flists), then the switch -all is assumed by default.

       The sorting order for the listing is alphabetical (with -alpha), or in a priority order defined by the "Flist-Order"  profile  entry  (with
       -noalpha).   Each item in the "Flist-Order" is a folder name or a folder name pattern that uses * to match zero or more characters.  Longer
       matching patterns have precedence over shorter matching patterns.  For example:

	    Flist-Order: personal petproject mh* * admin *junk

       This order puts a few interesting folders first, such as those with mail addressed to you personally, those about a pet project, and  those
       about mh-related things.  It places uninteresting folders at the end, and it puts everything else in the middle in alphabetical order.

FILES

       $HOME/.mh_profile	  The user profile

PROFILE COMPONENTS

       Path:		    To determine the user's nmh directory
       mh-sequences:	    File that contains public sequences
       Unseen-Sequence:     The name of the unseen message sequence
       Flist-Order:	    To sort folders by priority

SEE ALSO

       folder(1), rcvstore(1), slocal(1), mh-sequence(5)

DEFAULTS

       `-sequence' defaults to Unseen-Sequence profile entry
       `-showzero'
       `-noall'
       `-norecurse'
       `-noalpha'
       `-nofast'

CONTEXT

       If  +folder  is	given,	it  will become the current folder.  If multiple folders are given, the last one specified will become the current
       folder.

MH.6.8								   11 June 2012 							  FLIST(1)
All times are GMT -4. The time now is 09:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy