Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

AWK multiple fields separators

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting AWK multiple fields separators
# 1  
Old 03-14-2010
AWK multiple fields separators
I need to print the second field of a file, taking spaces, tab and = as field separators.

Code:
; for 16-bit app support
[fonts]
[extensions]
[mci extensions]
[files]
[Mail]
MAPI=1
CMC=1
CMCDLLNAME32=mapi32.dll
CMCDLLNAME=mapi.dll
MAPIX=1
MAPIXVER=1.0.0.1
OLEMessaging=1
[MCI Extensions.BAK]
asf=MPEGVideo
asx=MPEGVideo
ivf=MPEGVideo
m3u=MPEGVideo
mp2v=MPEGVideo
mp3=MPEGVideo
mpv2=MPEGVideo
wax=MPEGVideo
wm=MPEGVideo
wma=MPEGVideo
wmv=MPEGVideo
wvx=MPEGVideo
[WinZip]
Note-1=This section is required only to install the optional WinZip Internet Browser Support build 0231.
Note-2=Removing this section of the win.ini will have no effect except preventing installation of WinZip Internet Browser Support build 0231.
win32_version=R6.3-8.0
[OLFax Ports]
OLFModem=C:\Archivos de programa\Microsoft Office\Office\3082\WFXMSRVR.EXE,WFXMSRVR,WFXOUTLOOKSMTPPOP3, 60
[Remedy]
AppName=ARUSER-SERVER
ProgramPath=C:\ARCHIV~1\Remedy\aruser.exe DDECall C:\ARCHIV~1\Remedy
AppName=ARUSER-SERVER
ProgramPath=c:\APPS\remedy\aruser.exe DDECall c:\APPS\remedy
AppName=ARUSER-SERVER
ProgramPath=c:\APPS\remedy\aruser.exe DDECall c:\APPS\remedy
AppName=ARUSER-SERVER
ProgramPath=c:\APPS\remedy\aruser.exe DDECall c:\APPS\remedy
[Solitario]
Opciones=91
[SciCalc]
layout=0
[winvoid]
SpaceOK=No
WriteOK=No
[MAPI 1.0 Time Zone]
Bias==168
StandardName==Hora estándar central
StandardBias==0
StandardStart==00000400010002000000000000000000
DaylightName==Hora de verano central
DaylightBias==0
DaylightStart==00000400010002000000000000000000
ActiveTimeBias==168
DisableAutoDaylightTimeSet==1

I tried with
Code:
nawk "BEGIN {FS = [\ \t\=]+/} {print $2}" file

but it doesn't separate the fields with =, only does it with whitespaces. I just need to print a String per register using = and withspaces as field separators.
I want to print something like this:

Code:
for


extensions]


1
1
mapi32.dll
mapi.dll
1
1.0.0.1
1
Extensions.BAK
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo
MPEGVideo

This
Removing
R6.3-8.0

C:\Archivos de programa\Microsoft Office\Office\3082\WFXMSRVR.EXE,WFXMSRVR,WFXOUTLOOKSMTPPOP3,

ARUSER-SERVER
C:\ARCHIV~1\Remedy\aruser.exe
ARUSER-SERVER
c:\APPS\remedy\aruser.exe
ARUSER-SERVER
c:\APPS\remedy\aruser.exe
ARUSER-SERVER
c:\APPS\remedy\aruser.exe

91

0

No
No
1.0
168
Hora
0
00000400010002000000000000000000
Hora
0
00000400010002000000000000000000
168
1

Last edited by Franklin52; 03-16-2010 at 03:49 AM.. Reason: Please use code tags!
# 2  
Old 03-14-2010
Code:
awk -F "[ =\t]" '{print $2}' file

Check if this helps,
PL
# 3  
Old 03-16-2010
ty it worked just as i wanted =DSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print multiple fields with awk

so its common knowledge one can print multiple fields with simple commands like this: echo 12 44 45 552 24 | awk '{print $1,$4,$3}' but suppose i want to avoid specifying the "$" symbol. is that possible? can something like this be done: echo 12 44 45 552 24 | awk '{print $(1,4,3)}' ... (9 Replies)
Discussion started by: SkySmart
9 Replies

2. Shell Programming and Scripting

awk multiple filed separators

There is an usual ifconfig output vlan30 Link encap:Ethernet HWaddr inet addr:192.168.0.1 Bcast:192.168.0.255 Mask:255.255.255.0 inet6 addr: 2407:4c00:0:1:aaff::1/64 Scope:Global inet6 addr: fe80::224:e8ff:fe6b:cc4f/64 Scope:Link UP BROADCAST... (1 Reply)
Discussion started by: urello
1 Replies

3. Shell Programming and Scripting

Replace 0 with 1 in multiple fields with awk

Hello, I have the following input file: 1 3 3 2 3 3 4 0 4 0 5 4 5 2 2 0 5 3 4 0 6 0 3 2 I am trying to remove all zeroes in fields 2 and 4 and replace them with "1's" I tried the following, but it's not working awk -F"\t" '{ if (($2==0) || ($4==0) $2=1; $4=1; print $0 ) }' input ... (8 Replies)
Discussion started by: Rabu
8 Replies

4. Shell Programming and Scripting

awk multiple fields separators

Can you please help me with this .... Input File share "FTPTransfer" "/v31_fs01/root/FTP-Transfer" umask=022 maxusr=4294967295 netbios=NJ09FIL530 share "Test" "/v31_fs01/root/Test" umask=022 maxusr=4294967295 netbios=NJ09FIL530 share "ENR California" "/v31_fs01/root/ENR California"... (14 Replies)
Discussion started by: greycells
14 Replies

5. Shell Programming and Scripting

Multiple long field separators

How do I use multiple field separators in awk? I know that if I use awk -F"", both a and b will be field separators. But what if I need two field separators that both are longer than one letter? If I want the field separators to be "ab" and "cd", I will not be able to use awk -F"". The ... (2 Replies)
Discussion started by: locoroco
2 Replies

6. Shell Programming and Scripting

awk gsub multiple fields

Hi, I am trying to execute this line awk -F ";" -v OFS=";" '{gsub(/\./,",",$6); print}' FILE but for multiple fields $6 $7 $8 Do you have a suggstion? Tried: awk -F ";" -v OFS="";"" "function GSUB( F ) {gsub(/\./,\",\",$F); print} { GSUB( 6 ); GSUB( 7 ); GSUB( 8 ) } 1"... (2 Replies)
Discussion started by: nakaedu
2 Replies

7. UNIX for Dummies Questions & Answers

Multiple field separators in awk? (First a space, then a colon)

How do I deal with extracting a portion of a record when multiple field separators are involved. Let's say I have: Mike Harrington;(555) 555-5555:250:100:175 Christian Dobbins;(555) 555-2358:155:90:201 Susan Dalsass;(555) 555-6279:250:60:50 Archie McNichol;(555) 555-1348:250:100:175 Jody... (3 Replies)
Discussion started by: doubleminus
3 Replies

8. Shell Programming and Scripting

Multiple input field Separators in awk.

I saw a couple of posts here referencing how to handle more than one input field separator in awk. I figured I would share how I (just!) figured out how to turn this line in a logfile: 90000000000000000000010001 name... (4 Replies)
Discussion started by: kinksville
4 Replies

9. Shell Programming and Scripting

I need help counting the fields and field separators using Nawk

I need help counting the fields and field separators using Nawk. I have a file that has multiple lines on it and I need to read the file 1 at a time and then count the fields and field separators and then store those numbers in variables. I then need to delete the first 5 fields and the blank... (3 Replies)
Discussion started by: scrappycc
3 Replies

10. Shell Programming and Scripting

Awk Multiple Field Separators

Hi Guys, I'm tying to split a line similar to this:YO6-2000-30.htm: (3 properties found).......into separate columns, so effectively I need to check for a -, ., :, a tab and a space in the statement. Any help would be appreciated Thanks! (7 Replies)
Discussion started by: Tonka52
7 Replies
Login or Register to Ask a Question