awk to format file and combine two fields using comma Post: 302994979

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove whitespaces between comma separated fields from file

Hello all, I am a unix dummy. I am trying to remove spaces between fields. I have the file in the following format 12332432, 2345 , asdfsdf ,100216 , 9999999 12332431, 2341 , asdfsd2 ,100213 , 9999999 &...

2. UNIX for Dummies Questions & Answers

Sort the fields in a comma delimited file

Hi, I have a comma delimited file. I want to sort the fields alphabetically and again store them in a comma delimited file. For example, My file looks like this. abc,aaa,xyz,xxx,def pqr,ggg,eee,iii,qqq zyx,lmo,pqr,abc,fff and I want my output to look like this, all fields sorted...

3. Shell Programming and Scripting

How to combine first,second and third fields in a file

Hi Guys, I have a file as follows: 1 2 3 There are 5 spaces between 1 and 2 and one space between 2 and 3. I want: 123 How can I do this using awk? I tried using:

4. Shell Programming and Scripting

awk print - fields separated with comma's need to ignore inbetween double quotes

I am trying to re-format a .csv file using awk. I have 6 fields in the .csv file. Some of the fields are enclosed in double quotes and contain comma's inside the quotes. awk is breaking this into multiple fields. Sample lines from the .csv file: Device Name,Personnel,Date,Solution...

5. UNIX for Dummies Questions & Answers

Awk: Wondering how to format numbers with comma

I have tried the following commands and can't get a number to format with commas: echo 1234567.12 |awk '{printf("%-12s %20s\n", $0, comma($0)) }' This prints out value 50000 without a comma for i in *13*; do (cd $i && du -sk . && echo $i);done|grep -v 0000|gawk -F OFS="," ' {SUM += $1}...

6. Shell Programming and Scripting

Awk: Combine multiple lines based on number of fields

If a file has following kind of data, comma delimited 1,2,3,4 1 1 1,2,3,4 1,2 2 2,3,4 My required output must have only 4 columns with comma delimited 1,2,3,4 111,2,3,4 1,222,3,4 I have tried many awk command using ORS="" but couldnt progress

7. Shell Programming and Scripting

Combine two Fields if there's a comma between

Hi All, Seeking for your assistance on how to combine two fields if there's a comma between them. What i did was, extract the records from database. file1.csv(extracted from db) 82|Supplies Station, Inc.|112012|KARISSA APPAREL, INC. - 112012|NON TRADE F/A AND...

8. Shell Programming and Scripting

awk to combine matches and use a field to adjust coordinates in other fields

Trying to output a result that uses the data from file to combine and subtract specific lines. If $4 matches in each line then the last $6 value is added to $2 and that becomes the new$3. Each matching line in combined into one with $1 then the original $2 then the new$3 then $5. For the cases...

9. Shell Programming and Scripting

awk to combine all matching fields in input but only print line with largest value in specific field

In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited, that are in $1 of gene which is just a single column of text. However only the line with the greatest $9 value in input needs to be printed. So in the example below all the MECP2 and LTBP1...

10. UNIX for Beginners Questions & Answers

How to extract fields from a CSV i.e comma separated where some of the fields having comma as value?

can anyone help me!!!! How to I parse the CSV file file name : abc.csv (csv file) The above file containing data like abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different...

LEARN ABOUT MOJAVE

vm_stat

VM_STAT(1)						    BSD General Commands Manual 						VM_STAT(1)

NAME

     vm_stat -- show Mach virtual memory statistics

SYNOPSIS

     vm_stat [[-c count] interval]

DESCRIPTION

     vm_stat displays Mach virtual memory statistics.  If the optional interval is specified, then vm_stat will display the statistics every
     interval seconds.	In this case, each line of output displays the change in each statistic (an interval count of 1 displays the values per
     second).  However, the first line of output following each banner displays the system-wide totals for each statistic.  If a count is pro-
     vided, the command will terminate after count intervals.  The following values are displayed:

     Pages free
	     the total number of free pages in the system.

     Pages active
	     the total number of pages currently in use and pageable.

     Pages inactive
	     the total number of pages on the inactive list.

     Pages speculative
	     the total number of pages on the speculative list.

     Pages throttled
	     the total number of pages on the throttled list (not wired but not pageable).

     Pages wired down
	     the total number of pages wired down.  That is, pages that cannot be paged out.

     Pages purgeable
	     the total number of purgeable pages.

     Translation faults
	     the number of times the "vm_fault" routine has been called.

     Pages copy-on-write
	     the number of faults that caused a page to be copied (generally caused by copy-on-write faults).

     Pages zero filled
	     the total number of pages that have been zero-filled on demand.

     Pages reactivated
	     the total number of pages that have been moved from the inactive list to the active list (reactivated).

     Pages purged
	     the total number of pages that have been purged.

     File-backed pages
	     the total number of pages that are file-backed (non-swap)

     Anonymous pages
	     the total number of pages that are anonymous

     Uncompressed pages
	     the total number of pages (uncompressed) held within the compressor

     Pages used by VM compressor:
	     the number of pages used to store compressed VM pages.

     Pages decompressed
	     the total number of pages that have been decompressed by the VM compressor.

     Pages compressed
	     the total number of pages that have been compressed by the VM compressor.

     Pageins
	     the total number of requests for pages from a pager (such as the inode pager).

     Pageouts
	     the total number of pages that have been paged out.

     Swapins
	     the total number of compressed pages that have been swapped out to disk.

     Swapouts
	     the total number of compressed pages that have been swapped back in from disk.

     If interval is not specified, then vm_stat displays all accumulated statistics along with the page size.

Mac OS X							  August 13, 1997							  Mac OS X