07-20-2011
Delimiters in awk
Line from input file
a : b : c " d " e " f : g : h " i " j " k " l
output
k b a
Its taking 7th word when " is the delimiter, 2nd and 1st word when : is the delimiter and returning all in one line.... I am on solaris
Thanks.....
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Is there anyway to get awk to treat multiple delimiters as one? Particularly spaces... (6 Replies)
Discussion started by: peter.herlihy
6 Replies
2. Shell Programming and Scripting
Hello,
I need use comma and spaces as field delimiters, but I can't:
text:
hello myfriend,I need,some help
I need something like:
awk -F"<blank>|," '{print $1, $3}'
Thanks (3 Replies)
Discussion started by: albertogarcia
3 Replies
3. Shell Programming and Scripting
I have the following string sample:
bla bla bla bla bla
I would like to extract the "123" using awk.
I thought about awk -F"]" '{ print $1 }' but it doesn't work
Any ideas ? (7 Replies)
Discussion started by: gdub
7 Replies
4. Shell Programming and Scripting
Hello,
this thread is more about scripting style than a specific issue.
I've to grep from a output some lines and from them obtain a specific entry delimited by < and >.
This is my way :
1) grep -i user list | awk '{FS="<";print $NF}' | sed -e 's/>//g'
2) grep -i user list | cut -d","... (10 Replies)
Discussion started by: gogol_bordello
10 Replies
5. UNIX for Dummies Questions & Answers
hi,
i have a file called file1.txt and it's contents are as below:
file1.txt:
-------
abc,123, thomas
dab,234,muller
gab,456,ram
The lookup file's contents are as below:
lookup.txt
----------
abc|japan
dcd|US
dab|china
gab|brazil (3 Replies)
Discussion started by: amar1003
3 Replies
6. Shell Programming and Scripting
I have a file having lines like:
14: <a="b" val="c"/>
18: <a="x" val="d"/>
54: <a="b" val="c"/>
58: <a="x" val="e"/>
I need to create a file with output:
14
d
54
e
So basically, for every odd line I need 1st word if delimiter is ':' and for every even... (14 Replies)
Discussion started by: shekhar2010us
14 Replies
7. Shell Programming and Scripting
Hi Folks,
This is the first time I ever encountered this situation
My input file is of this kind
cat input.txt
1 PAIXAF 0 1 1 -9 0 0 0 1 2 0 2 1 2 1
7 PAIXEM 0 7 1 -9 1 0 2 0 1 2 2 1 0 2
9 PAKZXY 0 2 1 -9 2 0 1 1 1 0 1 2 0 1
Till the sixth column (which is -9), I want my columns to... (4 Replies)
Discussion started by: jacobs.smith
4 Replies
8. UNIX for Dummies Questions & Answers
Code :
echo "1,2,3,4"|awk -F "," 'NR==n{$3=a}1' n=1 a=45
Output :
1 2 45 4
Expected :
1,2,45,4 (4 Replies)
Discussion started by: Rajesh_us
4 Replies
9. Shell Programming and Scripting
What to know the way to count the number of delimiters in each record by ignoring the escape delimiters.
Sample Data:
12345678|ABN\|XYZ MED CHEM PTY. LTD.|C||100.00|22|AB"C\|Corp|"XYZ|CDEF"|
I'm using awk -F'|' '{ print NF-1 }' command to find the number of delimiters. this command... (8 Replies)
Discussion started by: BrahmaNaiduA
8 Replies
10. Shell Programming and Scripting
I have a file which is separated by delimiter "|", but the prob is one of my column do contain delimiter as description so how can i differentiate it?
PS : the delmiter does have backslash coming before it, if occurring in column
Annual|Beleagured|Desc|Denver... (2 Replies)
Discussion started by: nikhil jain
2 Replies
LEARN ABOUT DEBIAN
mdb-tables
MDBTools(1) MDBTools(1)
NAME
mdb-tables - Get listing of tables in an MDB database
SYNOPSIS
mdb-tables [-S] [-1 | -d delimiter] database
DESCRIPTION
mdb-tables is a utility program distributed with MDB Tools.
It produces a list of tables contained within an MDB database in a format suitable for use in shell scripts.
OPTIONS
-S Show system tables. System tables are generally those beginning with 'MSys'
-1 specifies that the tables should be listed 1 per line.
-d delimiter
specifies an alternative delimiter. If no delimiter is specified, table names will be delimited by a tab character, or by newline if
the -1 option was specified.
NOTES
ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
HISTORY
mdb-tables first appeared in MDB Tools 0.3.
SEE ALSO
gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1)
AUTHORS
The mdb-tables utility was written by Brian Bruns.
BUGS
Access allows for tables to have spaces embeded in the table name.
You must specify a delimiter (-d) if you intend on piping the output of mdb-tables to a program such as awk or cut.
0.7 13 July 2013 MDBTools(1)