Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Change the text in 2nd column in file
Top Forums Shell Programming and Scripting Change the text in 2nd column in file Post 302738887 by pamu on Monday 3rd of December 2012 04:58:12 AM
Old 12-03-2012
Try this...

only problem is with OFS..

Code:
$ cat file
abc.xxx.out.remoteOn           TRUE                               write
def.xxx.out.remoteOn           TRUE                               write
ghi.xxx.out.remoteOn           FALSE                               write
jkl.xxx.out.remoteOn           TRUE                               write

$ awk '{if($0 ~ /FALSE/){$2="TRUE"}else if($0 ~ /TRUE/){$2="FALSE"}}1' OFS="\t" file
abc.xxx.out.remoteOn    FALSE   write
def.xxx.out.remoteOn    FALSE   write
ghi.xxx.out.remoteOn    TRUE    write
jkl.xxx.out.remoteOn    FALSE   write

This User Gave Thanks to pamu For This Post:
sdosanjh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to insert new text and change existing text in a file using SED

Hi all, I need to insert new text and change existing text in a file. For that I used the below line in the command line and got the expected output. sed '$a\ hi... ' shell > shell1 But I face problem when using the same in script. It is throwing the error as, sed: command garbled:... (4 Replies)
Discussion started by: iamgeethuj
4 Replies

2. Shell Programming and Scripting

Writing out 2nd column into one file from multiple files

I have several files that are being generated every 20 minutes. Each file contains 2 columns. The 1st column is Text, 2nd column is Data. I would like to generate one single file from all these files as follows: One instance of 1st column Text, followed by 2nd column Data separated by... (5 Replies)
Discussion started by: subhap
5 Replies

3. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

4. Shell Programming and Scripting

comparing column of two different files and print the column from in order of 2nd file

Hi friends, My file is like: Second file is : I need to print the rows present in file one, but in order present in second file....I used while read gh;do awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile done < secondfile but the output I am... (14 Replies)
Discussion started by: CAch
14 Replies

5. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

6. Shell Programming and Scripting

Help i want to change the data of one file and apend it into 2nd file.

Hi All, Please help i have written an ksh script, where i am actually take count of lines in one file and want to update this count to 2nd field of a new file and apend the this into an existing file. Note the below script is in for loop -------- I am apending few records in a file... (7 Replies)
Discussion started by: iamnoone
7 Replies

7. Shell Programming and Scripting

Change file content 4 column to one Column using script

Hi Gurus, I have file content sample: ,5113955056,,TAgent-Suspend ,5119418233,,TAgent-Suspend ,5102119078,,TAgent-Suspend filenames 120229H5_suspend, 120229H6_unsuspend I receive those files one of directory /home/temp/ I need following: 1. Backup first /home/temp/ file to... (5 Replies)
Discussion started by: thepurple
5 Replies

8. Shell Programming and Scripting

Replace 2nd column in file

I have following entries file abc.txt abc83.out.remote TRUE abc84.out.remote TRUE abc85.out.remote TRUE abc86.out.remote TRUE Please help me, how do i toggle the entries listed in 2nd column based on the search patterns (abcxx) abcxx, i can get... (14 Replies)
Discussion started by: sdosanjh
14 Replies

9. Shell Programming and Scripting

Datestamp format 2nd change in csv file (awk or sed)

I have a csv file formatted like this: 2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07and I'm trying to change it to MM/DD/YYYY HH:MM for both occurances. I have got this: awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csvThis... (6 Replies)
Discussion started by: say170
6 Replies

10. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies

LEARN ABOUT PHP

proc_get_status

PROC_GET_STATUS(3)							 1							PROC_GET_STATUS(3)

proc_get_status - Get information about a process opened byproc_open(3)

SYNOPSIS

       array proc_get_status (resource	$process)

DESCRIPTION

       proc_get_status(3) fetches data about a process opened using proc_open(3).

PARAMETERS

	      o $process
		- The proc_open(3) resource that will be evaluated.

RETURN VALUES

	An array of collected information on success, and FALSE on failure. The returned array contains the following elements:

       +---------+--------------------------------------+---+
       |element  |					|   |
       |	 |					|   |
       |	 |		   type 		|   |
       |	 |					|   |
       |	 |	       description		|   |
       |	 |					|   |
       +---------+--------------------------------------+---+
       |command  |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		  string		|   |
       |	 |					|   |
       |	 |  The  command string that was passed |   |
       |	 | to proc_open(3).			|   |
       |	 |					|   |
       |  pid	 |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		   int			|   |
       |	 |					|   |
       |	 |		process id		|   |
       |	 |					|   |
       |running  |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		   bool 		|   |
       |	 |					|   |
       |	 |					|   |
       |	 | TRUE if the process	is  still  run- |   |
       |	 | ning, FALSE if it has terminated.	|   |
       |	 |					|   |
       |signaled |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		   bool 		|   |
       |	 |					|   |
       |	 |					|   |
       |	 | TRUE  if  the child process has been |   |
       |	 | terminated by  an  uncaught	signal. |   |
       |	 | Always set to FALSE on Windows.	|   |
       |	 |					|   |
       |stopped  |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		   bool 		|   |
       |	 |					|   |
       |	 |					|   |
       |	 | TRUE  if  the child process has been |   |
       |	 | stopped by a signal. Always	set  to |   |
       |	 | FALSE on Windows.			|   |
       |	 |					|   |
       |exitcode |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		   int			|   |
       |	 |					|   |
       |	 |  The   exit	code  returned	by  the |   |
       |	 | process (which is only meaningful if |   |
       |	 | running  is	FALSE). Only first call |   |
       |	 | of this function return real  value, |   |
       |	 | next calls return -1.		|   |
       |	 |					|   |
       |termsig  |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		   int			|   |
       |	 |					|   |
       |	 |  The   number  of  the  signal  that |   |
       |	 | caused the child process  to  termi- |   |
       |	 | nate  its execution (only meaningful |   |
       |	 | if signaled is TRUE).		|   |
       |	 |					|   |
       |stopsig  |					|   |
       |	 |					|   |
       |	 |					|   |
       |	 |		   int			|   |
       |	 |					|   |
       |	 |  The  number  of  the  signal   that |   |
       |	 | caused the child process to stop its |   |
       |	 | execution   (only   meaningful    if |   |
       |	 | stopped is TRUE).			|   |
       |	 |					|   |
       +---------+--------------------------------------+---+
SEE ALSO

       proc_open(3).

PHP Documentation Group 													PROC_GET_STATUS(3)
All times are GMT -4. The time now is 01:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy