Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Repeat same word in the rest of the column.
Top Forums Shell Programming and Scripting Repeat same word in the rest of the column. Post 302969561 by RavinderSingh13 on Thursday 24th of March 2016 05:31:59 AM
Old 03-24-2016
Hello shoaibjameel123,

Could you please try following and let me know if this helps you.
Code:
for file in *.txt
do
        awk '{if($2==""){$2=Q};if($2){Q=$2};print}' $file > tmp_file
        mv tmp_file $file
done

Also if above doesn't meet your requirement please let us know complete details about your requirement to help you, hope this helps.

NOTE: Also try to execute this within TEST environment for few files before running it in actual environment if All is Well with test then go for actual environment please.

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
shoaibjameel123
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to grep a word and next column to that word?

Hi, I have input file as below. Can you help me? inac_4y;0;2;Balance;200;1;1; 0;2;Balance;100;1; 0;inac_nq;0;1;Balance;100;1 desired output Balance;200 Balance;100 Balance;100 -Suresh Please use and tags when posting code, data or logs etc. to preserve formatting... (5 Replies)
Discussion started by: suresh3566
5 Replies

2. Shell Programming and Scripting

To search a word in particular column using awk

I have a data in a file like this 1 praveen bmscollege 2 shishira bnmit 3 parthiva geethamce I want to search "praveen" using awk command i tried like this but i did not get awk `$2="praveen" {print $0} ` praveen.lst can anyone help me solving this problem in... (2 Replies)
Discussion started by: praveenhegde
2 Replies

3. UNIX for Dummies Questions & Answers

Search word in 3rd column and move it to next column (4th)

Hi, I have a file with +/- 13000 lines and 4 column. I need to search the 3rd column for a word that begins with "SAP-" and move/skip it to the next column (4th). Because the 3rd column need to stay empty. Thanks in advance.:) 89653 36891 OTR-60 SAP-2 89653 36892 OTR-10 SAP-2... (2 Replies)
Discussion started by: AK47
2 Replies

4. Shell Programming and Scripting

Help with subtraction column by column and repeat print out with N

Input file: 2 10 15 20 24 Output file 2 8 NNNNNNNN 10 5 NNNNN 15 5 NNNNN 20 4 NNNN 24 Do anybody experience subtraction column by column and print out number of subtraction times with N? The second column of the output file is the subtraction of 10-2 = 8; The third column just... (3 Replies)
Discussion started by: perl_beginner
3 Replies

5. UNIX for Dummies Questions & Answers

Sum third column in a file when 1 and 2 repeat

Hello, Below is a portion of a file I am working on: 2:15 3001 120 2:15 3001 26.25 2:15 3002 12.5 2:15 3002 15 9:45 3001 45 9:45 3001 45 9:45 3002 105 9:45 3005 180 9:45 3005 123.75 9:45 3005 15 I am trying to get the sum of column 3 for all repeated values of columns 1 and 2 (The... (6 Replies)
Discussion started by: c@rlos
6 Replies

6. Shell Programming and Scripting

Add word for a missing column

Hi team... I need some help/advise on adding a word for a missing column. I have a file as below. Rep N1 Forever Limited 2015 Rep N2 Limited 2016 since 2nd content is 3 lines missing one line so i need to make this like Rep N1 Forever (3 Replies)
Discussion started by: newbee5
3 Replies

7. Shell Programming and Scripting

Find Word in Column with replace

Hi ALL i have file.txt with text : 4c:66:41:6b:b5:5f, 00:00,00:00, -22:-25, users1, 10.101.3.119, host1 4c:66:41:2c:c1:5a, 00:00,00:00, -21:-25, 10.101.3.112, host1 4c:66:41:6b:b1:5e, 00:00,00:00, -21:-25, users1, 10.101.3.113, host1 4c:66:41:2c:c1:5b, 00:00,00:00, -21:-25, 10.101.3.115,... (3 Replies)
Discussion started by: gnulyn
3 Replies

8. Shell Programming and Scripting

Find Word in Column with replace (2)

Dear ALL, I have sample file : 4c:66:41:6b:b5:5f, 00:00,00:00, -22:-25, robert, 10.101.3.119, host1 4c:66:41:2c:c1:5a, 00:00,00:00, -21:-25, 10.101.3.112, host1 4c:66:41:6b:b1:5a, 00:00,00:00, -21:-25, Julia, 10.101.3.113, host1 4c:66:41:2c:c1:5b, 00:00,00:00, -21:-25, 10.101.3.115, host1... (2 Replies)
Discussion started by: gnulyn
2 Replies

9. UNIX for Advanced & Expert Users

Cut a word between two strings and repeat the same in the entire file

in the below data i need to search for the word typeMismatch and then traverse back to find the filename of that particular mismatch. Like this we have to get all the file names which has error in them. How can i acheive this. I tried use sed or awk but not able to achevie the same. Sample... (2 Replies)
Discussion started by: ATWC
2 Replies

10. UNIX for Beginners Questions & Answers

How to search for a word in column header that fully matches the word not partially in awk?

I have a multicolumn text file with header in the first row like this The headers are stored in an array called . which contains I want to search for each elements of this array from that multicolumn text file. And I am using this awk approach for ii in ${hdr} do gawk -vcol="$ii" -F... (1 Reply)
Discussion started by: Atta
1 Replies

LEARN ABOUT OSX

otest

otest(1)						    BSD General Commands Manual 						  otest(1)

NAME

     otest -- SenTestingKit, OCUnit.

SYNOPSIS

     otest [-SenTest Self | All | None | <TestCaseClassName/testMethodName>] path

DESCRIPTION

     otest runs the unit tests found in the bundle given at path.

ARGUMENTS

     -SenTest value  This flag denotes the scope of the unit test to be run. Possible values are Self, All, None and <TestCaseClassName/test-
		     MethodName>. The default value is Self.

     path	     Path to the bundle that contains the unit tests.

OBJECTIVE-C GARBAGE COLLECTION
     otest is built with support for Objective-C garbage collection.  Due to the "whole process" nature of Objective-C garbage collection, invok-
     ing otest from the command line or an IDE or debugger will run otest with garbage collection enabled.  Doing so requires that the bundle con-
     taining the unit tests also be built with support for garbage collection.

     To avoid this requirement and disable garbage collection, run otest in an environment with the OBJC_DISABLE_GC environment variable set to
     YES.

ENVIRONMENT

     OBJC_DISABLE_GC  Set to YES to disable Objective-C garbage collection for otest when running test bundles that do not use it.

FILES

     /Developer/Tools/RunTargetUnitTests  A script that calls otest with the correct arguments for use with Xcode.

SEE ALSO

     RunTargetUnitTests(1), otest(1)

Xcode								   June 2, 2019 							     Xcode
All times are GMT -4. The time now is 04:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy