09-03-2011
Quote:
Originally Posted by
yazu
In the third line you just remove columns 2-4 with spaces in it, not extracting any data.
Hi yazu. thanks I'll give that a try. The capital letter was a mistake, sorry.
Is there a way of doing it for an arbitrary number of fields, I actually need it in the range 2 to 102 but because I do not understand your sed command I cannot adapt it. Could you please elaborate on it.
---------- Post updated at 02:14 PM ---------- Previous update was at 01:17 PM ----------
I tried to wrap my head around it for a while now but I don't understand it at all any further help greatly appreciated.
Last edited by cue; 09-03-2011 at 03:40 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
I have this code:
#!/usr/bin/ksh
#SERVICES
gzcat *SERVICES* | awk '
{
SUBSCRIBERNUMBER=substr($0,1,20)
SUBSCRIBERNUMBER=trim(SUBSCRIBERNUMBER)
SERVICECODE=substr($0,22,61)
SERVICECODE=trim(SERVICECODE)
STARTDD=substr($0,63,72)
STARTDD=trim(STARTDD)
STARTDT=substr($0,74,81)... (1 Reply)
Discussion started by: naoseionome
1 Replies
2. Shell Programming and Scripting
Hi suppose I have a csv file like this
count,1977,1978,1979
usa, , , blue
japan, red, yellow,green
india, , yellow,blue
china, blue, yellow, green
I want the output to be(replace everything, including empty data, with the most recent data):
... (1 Reply)
Discussion started by: grossgermany
1 Replies
3. Shell Programming and Scripting
Hello all,
I have a problem with a skript of mine:
My input has the following format
1,33296 transcript_id"ENSRNOT00000018629" 0 1,33296 0
0 transcript_id"ENSRNOT00000029014" 0
0,907392 transcript_id"ENSRNOT00000016905" 0,907392
0 transcript_id"ENSRNOT00000053370" 0
0... (0 Replies)
Discussion started by: DerSeb
0 Replies
4. Shell Programming and Scripting
Hi,
Does any one know how to avoid the scenario where awk ignores the fields having only spaces or empty fields?
for instance,
Data: "a","b","c","d",""," "
code:
awk -F, '{ print NF }' File
the output I get is 4 instead of 6 do you know how to avoid this? (6 Replies)
Discussion started by: ahmedwaseem2000
6 Replies
5. Shell Programming and Scripting
Hi
file.in and file.out are in csv format. the code I have now is,
cat file.in | awk -F"," '!($1$2$3$4$5$6$7$8 in a){a;print $0}' > file.out
Here, I am printing entire line using $0. however, I want to print $1 to $150 and it should be in csv format. Cut -d is not good in performace.... (3 Replies)
Discussion started by: krishnix
3 Replies
6. Shell Programming and Scripting
Hi! I need to learn that how a shell script can transverse a csv file n check if any field is empty or not. means its contains two comma or space b/w commas i.e., "" or " ".
can anyone help me out how I can do that.... (10 Replies)
Discussion started by: sukhdip
10 Replies
7. Shell Programming and Scripting
I am trying to selectively display several columns from a db2 query, which gives me a fixed-width output (partial output listed here):
--------- -------------------------- ------------ ------
000 0000000000198012 702 29
000 0000000000198013 ... (9 Replies)
Discussion started by: ahsh79
9 Replies
8. Shell Programming and Scripting
I am trying to cut a range of fields in awk. The below seems to work for removing field 50, but what is the correct syntax for removing a range ($50-$62). Thank you :).
awk
awk 'BEGIN{FS=OFS="\t"}{$50=""; gsub(/\t\t/,"\t")}1' test.vcf.hg19_multianno.txt > output.csv
Maybe:
awk... (6 Replies)
Discussion started by: cmccabe
6 Replies
9. Shell Programming and Scripting
I am trying to use awk to identify and print out records in fields that are empty along with which line they are in. I hope the awk below is close, it runs but nothing results. Thank you :).
awk
awk -F'\t' 'FNR==NR ~ /^*$/ { print "NR is empty" }' file
file
123 GOOD ID 45... (3 Replies)
Discussion started by: cmccabe
3 Replies
10. Shell Programming and Scripting
Hello
I have a file like this
a,b,c,1,2,3,d,e,f,,,,g,h,i,,,,j,k,l
and using awk 'FS="'"{print $9,$10,$11}' does not work as I was hoping. I would like the empty fieds, i.e. between the two comma to be interpreted as a zero. is this possible?
I would like to get f 0 0 out of the above... (1 Reply)
Discussion started by: garethsays
1 Replies
LEARN ABOUT DEBIAN
root-tail
ROOTTAIL(1) General Commands Manual ROOTTAIL(1)
NAME
root-tail - print text directly to X11 root window
SYNOPSIS
root-tail [-g|--geometry GEOMETRY] [-fn|--font FONTSPEC] [--color color] [--reload SEC COMMAND] [--shade] [--outline] [--minspace]
[--noflicker] [-f|--fork] [--reverse] [--whole] [--partial] [--update] [--cont STRING] [--wordwrap] [--justify] [--noinitial] [--frame]
[-id ID] [-i|--interval SECONDS] [-V] file1[,color[,desc]] [file2[,color[,desc]]]
DESCRIPTION
Displays a given file anywhere on your X11 root window, i.e. it is kind of tail -f for multiple files using your desktop background as out-
put window.
All non-option arguments on the command line are files to be logged. A null desc (example: "/var/log/messages,red,") will prevent the
printing of a description and the []'s.
General Options
--color COLOR
Use COLOR as default.
--font | -fn FONTSPEC
Use font FONTSPEC. This can be either a fixed width font like -fn fixed or any font using -fn '-*-*-*-*-*-*-*-*-*-*-*-*-*-*' with
the appropriate fields filled out (see xfontsel). Specifying a different FONTSPEC before each filename will cause each file to be
displayed in a different font.
-f | --fork
Forks to the background.
--reverse
Display the files in reverse order, with the newest lines at the top.
--whole
Only display whole lines. If the last line of a file doesn't yet end with a newline character then wait until it does before dis-
playing it. This is the default if more than one file is being displayed.
--partial
This is the opposite of the --whole option (see above). It displays lines even if they don't yet have a newline at the end. This is
the default if only one file is being displayed.
--update
Update partial lines 'in place' if they are still on the screen when they are updated in their files. Using --update automatically
turns on --partial.
--cont STRING
When partial lines are broken into two lines in the display, prefix the 2nd line with STRING. Defaults to "|| ". Specify the
"--whole" argument to ensure partial lines are never displayed, or specify "--update" to attempt to "repair" broken lines in-place.
--cont-color COLOR
Use COLOR when displaying the continuation string (as optionally specified with the --cont option above).
--wordwrap
The default behaviour is to fit as much as possible onto each line of output, even if this means splitting a word between one line
and the next. The --wordwrap argument splits lines at spaces if possible.
--justify
After wrapping long lines, attempt to justify the text to produce a smooth right-hand margin. Implies --wordwrap.
--reload SEC COMMAND
Re-display the file(s) and run COMMAND every SEC seconds. The default is to never re-display the file(s).
--shade
Add black shading to the font.
--outline
Add a black outline to the font (making redraws quite a bit slower).
--minspace
Use minimum linespace even when using shading or outlining. This might result in leftover pixels (dependign on font and logfile con-
tent).
--noflicker
Use slower but flicker-free update.
--noinitial
Don't display the end of the file(s) initially.
-id ID Use the given window ID for output instead of the root window.
-i | --interval SECONDS
Use the specified sleeping interval between checks instead of the default 2.4 seconds. Fractional values are OK.
-V Print version information.
--frame
Draw a frame around the selected area. This is useful when trying to find the perfect geometry.
EXAMPLE
root-tail -g 800x250+100+50 -font 10x20 /var/log/messages,green -font 12x24 /var/log/secure,red,'ALERT'
BUGS
Some desktop environments open a virtual root window and make it difficult to share it. If you cannot see anything after starting root-
tail, try to find a setting "allow programs on desktop" or similar, or manually specify a window id.
Should you happen to find any bugs please fix them and send me a diff.
NOTE: This program was modified by Marc Lehmann <pcg@goof.com>, who couldn't reach the original author. Please direct bug-reports etc. to
pcg@goof.com.
http://root-tail.plan9.de/
4.2 Berkeley Distribution 2004-03-27 ROOTTAIL(1)