Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Unwanted field separation in awk
Top Forums Shell Programming and Scripting Unwanted field separation in awk Post 302285009 by ccox85 on Friday 6th of February 2009 07:03:12 PM
Old 02-06-2009
Unwanted field separation in awk
Hi everyone,

My problem is strange, I cannot think of why this is happening.

I have a set of data that looks like this:

Quote:
Trial:1 131983 2 (197,383) 1 515 389 7 986 0 0 0 1 computertower_c.jpg computertower_c.jpg
Trial:1 131983 2 (197,383) 2 206.7 378.7 1039 1621 0 0 0 1 computertower_c.jpg computertower_c.jpg
Trial:2 135077 4 (511,69) 1 513.9 390.1 7 992 0 1 0 1 bird_n.jpg bird_n.jpg
Trial:2 135077 4 (511,69) 2 498.9 107.6 1033 1290 0 1 0 1 bird_n.jpg bird_n.jpg
Although it does not look it, the fields are tab delimited. I have made sure of this, and awk does recognize them as such. However, it divides what I would expect to be $4, (x, y), into two fields at the comma. Even if I specify:
Code:
{FS="\t"}

the issue persists. Any ideas?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk - need to remove unwanted newlines on match

Context: I need to remove unwanted newlines from a data file listing books and associated data. Here is a sample listing ( line numbers included ): 1 360762| Skip-beat! 14 /| 9781421517544| nb | 2008.| Nakamura, Yoshiki.| NAKAMUR | Kyoko Mogami followed 2 her true love Sho to Tokyo to... (6 Replies)
Discussion started by: Bubnoff
6 Replies

2. Shell Programming and Scripting

awk, comma as field separator and text inside double quotes as a field.

Hi, all I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes. sample input: for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies

3. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

4. Shell Programming and Scripting

awk prints unwanted new lines

Hello, I need a little help with the following: I'm using AWK to read input from a comma-seperated value file, and only printing certain fields like so: awk -F "," '{print $1,$3,$6}' /list.csv | tail -1 Which outputs the following: server1 APPID OS I run into a problem... (8 Replies)
Discussion started by: LinuxRacr
8 Replies

5. Shell Programming and Scripting

Stripping unwanted characters in field

I wrote myself a small little shell script to clean up a file I have issues with. In particular, I am stripping down a fully qualified host/domain name to just the hostname itself. The script works, but from a performance standpoint, it's not very fast and I will be working with large data sets. ... (4 Replies)
Discussion started by: dagamier
4 Replies

6. Shell Programming and Scripting

awk to parse field and include the text of 1 pipe in field 4

I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close: awk so far: awk '{sub(/\|]+]++/, ""); print }' input.txt Input chr1 955543 955763 AGRN-6|pr=2|gc=75 0 + chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 + chr1 970621 ... (7 Replies)
Discussion started by: cmccabe
7 Replies

7. Shell Programming and Scripting

How can awk ignore the field delimiter like comma inside a field?

We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below. Current file (file.csv) ---------------------- empname,date_of_join,dept,date_of_resignation ram,08/09/2015,sales,21/06/2016 "akash,sahu",08/10/2015,IT,21/07/2016 ... (6 Replies)
Discussion started by: gopal.biswal
6 Replies

8. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
Discussion started by: cmccabe
3 Replies

9. Shell Programming and Scripting

awk to update field using matching value in file1 and substring in field in file2

In the awk below I am trying to set/update the value of $14 in file2 in bold, using the matching NM_ in $12 or $9 in file2 with the NM_ in $2 of file1. The lengths of $9 and $12 can be variable but what is consistent is the start pattern will always be NM_ and the end pattern is always ;... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple... (15 Replies)
Discussion started by: cotilloe
15 Replies

LEARN ABOUT DEBIAN

mcpmv

MRENAME(1)						      General Commands Manual							MRENAME(1)

NAME

       mrename - program to rename files

SYNOPSIS

       mrename 'pattern' prefix [option]

DESCRIPTION

       This  manual  page  documents  briefly the mrename command.  This manual page was written for the Debian GNU/Linux distribution because the
       original program does not have a manual page.

       mrename is a tool for easy and automatic renaming of many files.  The 'pattern' is the pattern to search files to rename (quoted  to  avoid
       that  bash  resolve  it),  and prefix is the prefix that will be added to the name of each file. The two alternative options for copying or
       moving files in the new name are explained below.  All parameters are needed, and you have to stay and launch the script in the same direc-
       tory of the files to be renamed. The program should be able to write in this directory.

OPTIONS

       There are only the following three options.

       -c     The option -c will copy each file with the new filename.

       -m     The option -m will move each file in the new filename.

       -h     Display help.

EXAMPLE

       If  you	have  a  directory  with two jpeg images prof.jpg and forp.jpg and you want to add them a prefix like item0, item1 etc..  (that is
       item0prof.jpg, item1forp.jpg etc..) do this:

	  cd /path/to/the/images
	  mrename '*.jpg' item -c

       to copy each matching file into another with the new name

	  mrename '*.jpg' item -m

       to rename each file without keeping a copy with the previous name

Word-Wide-Web:
       http://alfalinux.sourceforge.net/mrename.php3

AUTHOR
:
       Giancarlo -rofus- Erra
       e-mail: rofus@mindless.com

       This manual page was written by Dr. Guenter Bechly <gbechly@debian.org>, for the Debian GNU/Linux system (but may be used by others). It is
       distributed under the GPL just like mrename itself.

								 October  22, 2000							MRENAME(1)
All times are GMT -4. The time now is 04:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy