12-29-2011
@bmk:
Which version of 'awk'?
In my machine works but I use the GNU version, and perhaps other don't support the withespace character regex '\s'. Try with a simple space, like:
$ awk 'BEGIN { FS = OFS = "|" } { for ( i = 1; i <= NF; i++ ) { if ( i == 2 || i == 4 || i == 10 ) { sub( /^ */, "", $i ); sub( / *$/, "", $i ) } } { print } }' infile
Regards,
Birei
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello Friends,
Can any one help me with this issue:
I would like to format a file:
say if I have rows like:
4512 , SMITH , I-28984 ,, 4324 , 4343
42312 , SMITH , I-2EE8984 ,, 432E4E4 , 4343
I would like to have the output diaplayed like :
4512... (8 Replies)
Discussion started by: sbasetty
8 Replies
2. Shell Programming and Scripting
I have a file with only one field something like this :
213.45
220.65
240.47
345.67
320.45
I want to remove all spaces in between. Is there any unix command for that ?Thanks in advance.. (2 Replies)
Discussion started by: jacks
2 Replies
3. Shell Programming and Scripting
Hi,
I want to trim the spaces on left side of the variable value. For eg: if it is 4 spaces followed by value, All the spaces on the left should be supressed.
Easy but want it quickly.
Regards,
Shiv@jad (6 Replies)
Discussion started by: Shiv@jad
6 Replies
4. Shell Programming and Scripting
Hi all,
I have a problem to format data from different database queries into one look. The input data are as follows, every line has the same number of values but a different number of characters:
adata, bdata, cdata, ddata
fffdata, gdata, hdata, idata
jdata, kdata, ... (6 Replies)
Discussion started by: old_mike
6 Replies
5. Shell Programming and Scripting
Hey all, I have a list in the format ;
variable length with spaces
more variable information
some more variable information
and I would like to transform that 'column' into rows ;
variable length with spaces more variable information some more variable information
Any... (8 Replies)
Discussion started by: TAPE
8 Replies
6. Shell Programming and Scripting
Hi,
I have a requirement to remove certain spaces from a table of information, but I'm unsure where to start.
A typical table will be like this:
ABCDE 1 Elton John 25 12 15 9 3
ABCDE 2 Oasis 29 13 4 6 9
ABCDE 3 The Rolling Stones 55 19 3 8 6The goal is to remove only the spaces between... (11 Replies)
Discussion started by: danhodges99
11 Replies
7. Shell Programming and Scripting
Hi All
I've a file which is similar to the one given below
column1 coulmn2 column3 column4
A B C D
X Y
F G H
I would like to get it in this format
A|B|C|D
||X|Y
F||G|H
Is... (4 Replies)
Discussion started by: Celvin VK
4 Replies
8. Shell Programming and Scripting
Hi i have an input " load /appss/asdfas/...
I want to take the string present between first / / i.e appss
Input is "load /appss/asdfas/..."
Expected output is appss
Thanks in advance
Ananth (9 Replies)
Discussion started by: Ananthdoss
9 Replies
9. Shell Programming and Scripting
Hi guru's,
I am trying to write a script to generate a csv file by connecting to database run a query and put the values into csv file.
But the problem i face is i am getting lot of space after one value.how can i remove those values?.
Please help.
#!/bin/bash
export... (2 Replies)
Discussion started by: karingulanagara
2 Replies
10. Shell Programming and Scripting
Hi,
I'm using awk to print columns from a tab delimited text file:
awk '{print " "$2" "$3" $6"}' file
The problem I have is column 6 contains text with spaces etc which means awk only prints the first word.
How can I tell awk to print the whole column content as column 6?
Thanks, (10 Replies)
Discussion started by: keenboy100
10 Replies
LEARN ABOUT NETBSD
licensecheck
LICENSECHECK(1) LICENSECHECK(1)
NAME
licensecheck - simple license checker for source files
SYNOPSIS
licensecheck --help|--version
licensecheck [--no-conf] [--verbose] [--copyright] [-l|--lines=N] [-i|--ignore=regex] [-c|--check=regex] [-m|--machine] [-r|--recursive]
list of files and directories to check
DESCRIPTION
licensecheck attempts to determine the license that applies to each file passed to it, by searching the start of the file for text
belonging to various licenses.
If any of the arguments passed are directories, licensecheck will add the files contained within to the list of files to process.
OPTIONS
--verbose, --no-verbose
Specify whether to output the text being processed from each file before the corresponding license information.
Default is to be quiet.
-l=N, --lines=N
Specify the number of lines of each file's header which should be parsed for license information. (Default is 60).
-i=regex, --ignore=regex
When processing the list of files and directories, the regular expression specified by this option will be used to indicate those which
should not be considered (e.g. backup files, VCS metadata).
-r, --recursive
Specify that the contents of directories should be added recursively.
-c=regex, --check=regex
Specify a pattern against which filenames will be matched in order to decide which files to check the license of.
The default includes common source files.
--copyright
Also display copyright text found within the file
-m, --machine
Display the information in a machine readable way, i.e. in the form <file><tab><license>[<tab><copyright>] so that it can be easily
sorted and/or filtered, e.g. with the awk and sort commands. Note that using the --verbose option will kill the readability.
--no-conf, --noconf
Do not read any configuration files. This can only be used as the first option given on the command-line.
CONFIGURATION VARIABLES
The two configuration files /etc/devscripts.conf and ~/.devscripts are sourced by a shell in that order to set configuration variables.
Command line options can be used to override configuration file settings. Environment variable settings are ignored for this purpose. The
currently recognised variables are:
LICENSECHECK_VERBOSE
If this is set to yes, then it is the same as the --verbose command line parameter being used. The default is no.
LICENSECHECK_PARSELINES
If this is set to a positive number then the specified number of lines at the start of each file will be read whilst attempting to
determine the license(s) in use. This is equivalent to the --lines command line option.
LICENSE
This code is copyright by Adam D. Barratt <adam@adam-barratt.org.uk>, all rights reserved; based on a script of the same name from the KDE
SDK, which is copyright by <dfaure@kde.org>. This program comes with ABSOLUTELY NO WARRANTY. You are free to redistribute this code under
the terms of the GNU General Public License, version 2 or later.
AUTHOR
Adam D. Barratt <adam@adam-barratt.org.uk>
Debian Utilities 2013-12-23 LICENSECHECK(1)