English 中文(简体)
能否在对非引用字符串保持透明的同时,将引用的字符串投放到整数上?
原标题:Is it possible to cast a quoted string to an integer in awk, while being transparent to non-quoted strings?
  • 时间:2012-05-21 23:44:36
  •  标签:
  • awk
  • gawk

假设我输入文件的一行是这样的:

7162    "cw_107373" 65  65  0.197606944 328.935809057398    "91.67" "11/12" "0.89"  "47/53" 0   N/A Active

You ll observe that some of the numerical fields are quoted, and some are not. I d like to be able to do numerical comparisons with them, while ignoring the quotes.

例如,我目前不能做

awk "$7 > 90{print}" Input.tsv

因为 7 美元是一个引用的数字字符串

我知道,我可以提前处理文件,删除所有引号,但我想知道,直接使用awk是否更优雅。

问题回答

您需要脱去引号。 您可以使用 gsub (”), 来做到这一点。 这将影响整个行。 您可以指定这样的字段 : gsub ("""), ",", "7"





相关问题
awk save command ouput to variable

I need to execute a command per line of some file. For example: file1.txt 100 4 file2.txt 19 8 So my awk script need to execute something like command $1 $2 $3 and save the output of command $1 $2 ...

awk and bash script

I have a tgz file which contains a version file, version.txt. This file has only one line "version=1.0.0". This tgz file is present in two different directories and has the same name. My requirement ...

awk - how to specify field separator as binary value 0x1

Is it possible to specify the separator field FS in binary for awk? I have data file with ascii data fields but separated by binary delimiter 0x1. If it was character 1 it would look like this: ...

Awk - print next record following matched record

I m trying to get a next field after matching field using awk. Is there an option to do that or do I need to scan the record into array then check each field in array and print the one after that? ...

Using Unix Tools to Extract String Values

I wrote a small Perl script to extract all the values from a JSON formatted string for a given key name (shown below). So, if I set a command line switch for the Perl script to id, then it would ...

how to use sed, awk, or gawk to print only what is matched?

I see lots of examples and man pages on how to do things like search-and-replace using sed, awk, or gawk. But in my case, I have a regular expression that I want to run against a text file to extract ...

Bulk Insert Code Before </body> Tag in 100 Files

I d like to insert <?php include_once( google_analytics.php ); ?> before the closing body tag of about 100 php files. Unfortunately the person who made the site didn t make a header or ...

热门标签