Sponsored Content
Top Forums Shell Programming and Scripting Changing values in the first column. Post 302881185 by Akshay Hegde on Friday 27th of December 2013 03:17:57 AM
Old 12-27-2013
Quote:
Originally Posted by PikK45
This is what I thought after seeing @Akshay's analysis

Code:
awk '{ 
  if( length($1) == 1 ) {
    if( $1 == 1) $1 = "+1"; 
    else if ($1 == 0) $1= "-1"; 
  }
  print;}' input.txt

if( length($1) == 1 ) is not needed since 00 is 0only, if he/she is treating 00 aschar then length($1) would be necessary, and your old solution was right I think.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12... (5 Replies)
Discussion started by: manneni prakash
5 Replies

2. Shell Programming and Scripting

How to pick values from column based on key values by usin AWK

Dear Guyz:) I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z). I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in... (16 Replies)
Discussion started by: repinementer
16 Replies

3. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies

4. Shell Programming and Scripting

Cat Values from Several files if it meets criteria for column values

I have results from some statistical analyses. The format of the results are as given below: I want to select lines that have a p-value (last column) less than 0.05 from all the results files (*.results) and cat to a new results file. It would be very nice if a new column is added that tells... (2 Replies)
Discussion started by: genehunter
2 Replies

5. UNIX for Dummies Questions & Answers

shift values in one column as header for values in another column

Hi Gurus, I have a tab separated text file with two columns. I would like to make the first column values as headings for the second column values. Ex. >value1 subjects >value2 priorities >value3 requirements ...etc and I want to have a file >value1 subjects >value2 priorities... (4 Replies)
Discussion started by: Unilearn
4 Replies

6. Shell Programming and Scripting

Converting odd values to even values(or vice-versa) located in a column

Hello All, I have a below data in a .csv file where all rows where col1 is A, col2 is odd numbers, similarly even numbers for all rows where col1 is B. Note that my data has some other columns(not shown here) too (around 100) after col2. Tool,Data A,1 A,3 A,5 .... so on B,2 B,4 .... ... (4 Replies)
Discussion started by: ks_reddy
4 Replies

7. UNIX for Dummies Questions & Answers

Changing values of a column based on formula

Hi, I have a tab delimited text file with two columns where the second column takes on values between 1 and 6 (including). If the value of the second column, includes 1,2,3 I want to replace it with LOW. If it is 4,5,6 I want to replace it with HIGH. How do I go about doing that? Thanks ... (3 Replies)
Discussion started by: evelibertine
3 Replies

8. UNIX for Dummies Questions & Answers

Changing the values of a column using awk and gsub

Hi, I am using the following code to change NA to X in only the 5th column of my text file: awk '{gsub("NA","x",$5)}1' in.file > out.file How can I modify this code if I want to change NA to X in multiple columns of the text file (i.e. columns 5,6 and 7). Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies

9. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

10. Shell Programming and Scripting

Changing values only in 3rd column and 4th column

#cat file testing test! nipw asdkjasjdk ok! what !ok host server1 check_ssh_disk!102.56.1.101!30!50!/ other host server 2 des check_ssh_disk!192.6.1.10!40!30!/ #grep check file| awk -F! '{print $3,$4}'|awk '{gsub($1,"",$1)}1' 50 30 # Output: (6 Replies)
Discussion started by: kenshinhimura
6 Replies
ARRAY_SLICE(3)								 1							    ARRAY_SLICE(3)

array_slice - Extract a slice of the array

SYNOPSIS
array array_slice NULL (array $array, int $offset, [int $length], [bool $preserve_keys = false]) DESCRIPTION
array_slice(3) returns the sequence of elements from the array $array as specified by the $offset and $length parameters. PARAMETERS
o $array - The input array. o $offset - If $offset is non-negative, the sequence will start at that offset in the $array. If $offset is negative, the sequence will start that far from the end of the $array. o $length - If $length is given and is positive, then the sequence will have up to that many elements in it. If the array is shorter than the $length, then only the available array elements will be present. If $length is given and is negative then the sequence will stop that many elements from the end of the array. If it is omitted, then the sequence will have everything from $offset up until the end of the $array. o $preserve_keys - Note that array_slice(3) will reorder and reset the numeric array indices by default. You can change this behaviour by setting $preserve_keys to TRUE. RETURN VALUES
Returns the slice. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.2.4 | | | | | | | The default value of the $length parameter was | | | changed to NULL. A NULL$length now tells the | | | function to use the length of $array. Prior to | | | this version, a NULL$length was taken to mean a | | | zero length (nothing will be returned). | | | | | 5.0.2 | | | | | | | The optional $preserve_keys parameter was added. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 array_slice(3) examples <?php $input = array("a", "b", "c", "d", "e"); $output = array_slice($input, 2); // returns "c", "d", and "e" $output = array_slice($input, -2, 1); // returns "d" $output = array_slice($input, 0, 3); // returns "a", "b", and "c" // note the differences in the array keys print_r(array_slice($input, 2, -1)); print_r(array_slice($input, 2, -1, true)); ?> The above example will output: Array ( [0] => c [1] => d ) Array ( [2] => c [3] => d ) SEE ALSO
array_splice(3), unset(3), array_chunk(3). PHP Documentation Group ARRAY_SLICE(3)
All times are GMT -4. The time now is 08:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy