Adding columns with values dependent on existing columns
Hello
I have a file as below
on which I want to add new columns such that:
if ref is a string >1 (i.e line 2) then I generate 2 new columns where:
first new column = start-1
second new column = start+(length of string in ref)+1
therefore, for line 2 output would look like:
chr1 135419 TATACA T 2 0 135418 135426
or:
if length of string in ref = 1 and alt=string of length>1 (i.e. line 1) then
first new column = start
second new column = start+2
so, output for line 1 would be:
chr1 18884 C CAAAA 2 0 18884 18886
Anybody able to help with an approach to doing this?
Would awk be the best way to do this? My perl is non-existent otherwise I imagine that would be a good way to do it
I want to select the first column from a daily file called foo.csv. The result is written to file foo.txt. Currently the following script is used for that:
cut -d, -f 1 foo.csv > foo.txt
A typical result would yield :
A12
A45
B11
B67
What needs to happen in addition is that two columns... (5 Replies)
Hey everyone!
I have a need to add 2 files together as columns.
For instance, I have one file that has several rows of data and I want to take data from another file and add Line 1 to the end of Line1 in the first file
file1 line1.........file2 line1
file1 line2.........file2 line2... (12 Replies)
Hi All ,
Kindly help me with this soln
awk '{printf "%s %7s \n", $1,$c}' infile
where
value of variable c I am externally giving input
But executing the above command shows all the columns of infile where as I want only 1st column of infile and 2nd column should print value c (8 Replies)
Hi All,
i have an excel sheet as below:
day
-----
monday
tuesday
wenesday
thursday
friday
i need to append the two more columns in this existing file below:
insert date should be todays date---
day insert date insert user
---- ---------- ... (3 Replies)
Hi everyone,
I have file1 and file2 comma separated both.
file1 is:
Header1,Header2,Header3,Header4,Header5,Header6,Header7,Header8,Header9,Header10
Code7,,,,,,,,,
Code5,,,,,,,,,
Code3,,,,,,,,,
Code9,,,,,,,,,
Code2,,,,,,,,,file2... (17 Replies)
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
Hello,
I am using AWK in UBUNTU 12.04.
I have a dataset as follows:
1 2 12 1 4 1 4 1 7 9 4 6
1 2 4 5 7 8 45 7 4 5 7 5
What I want to do is to add the values of some columns to each other and print it in the same file as the new column while omitting the previous two columns to have... (3 Replies)
Hi all,
I am kind of stuck with printing my desired output. Please help me if you know how it can work.
My input file(tab separated):
NW_0068.1 41,16 100,900
NW_0699.1 4,2,19 200,700,80
My Output file (desired):
NW_0068.1 41,16 100,900 100 - 141
NW_0068.1 41,16 100,900 ... (3 Replies)
I have two files, file1 and file2 who have identical number of rows and columns. However, the script is supposed to be used for for different files and I cannot know the format in advance. Also, the number of columns changes within the file, some rows have more and some less columns (they are... (13 Replies)
Discussion started by: maya3
13 Replies
LEARN ABOUT OPENSOLARIS
indicator
indicator(1F) FMLI Commands indicator(1F)NAME
indicator - display application specific alarms and/or the "working" indicator
SYNOPSIS
indicator [-b [n]] [-c column] [-l length] [-o] [-w]
[string]...
DESCRIPTION
The indicator function displays application specific alarms or the "working" indicator, or both, on the FMLI banner line. The argument
string is a string to be displayed on the banner line, and should always be the last argument given. Note that string is not automatically
cleared from the banner line.
OPTIONS -bn The -b option rings the terminal bell n times, where n is an integer from 1 to 10. The default value is 1. If the terminal has
no bell, the screen is flashed instead, if possible.
-c column The -c option defines the column of the banner line at which to start the indicator string. The argument column must be an
integer from 0 to DISPLAYW-1. If the -c option is not used, column defaults to 0 .
-l length The -l option defines the maximum length of the string displayed. If string is longer than length characters, it will be trun-
cated. The argument length must be an integer from 1 to DISPLAYW. If the -l option is not used, length defaults to DISPLAYW.
Note that if string doesn't fit it will be truncated.
-o The -o option causes indicator to duplicate its output to stdout .
-w The -w option turns on the "working" indicator.
EXAMPLES
Example 1 A sample output of the indicator command.
When the value entered in a form field is invalid, the following use of indicator will ring the bell three times and display the word WRONG
starting at column 1 of the banner line.
invalidmsg=`indicator -b 3 -c 1 "WRONG"`
To clear the indicator after telling the user the entry is wrong:
invalidmsg=`indicator -b 9 -c 1 "WRONG"; sleep 3;
indicator -c 1 " "`
In this example the value of invalidmsg (in this case the default value Input is not valid), still appears on the FMLI message line.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO attributes(5)SunOS 5.11 5 Jul 1990 indicator(1F)