Sponsored Content
Full Discussion: awk csv using a loop
Top Forums Shell Programming and Scripting awk csv using a loop Post 302789201 by RudiC on Wednesday 3rd of April 2013 09:26:07 AM
Old 04-03-2013
Does it have to be a for loop? With awk, try:
Code:
$ awk 'FNR==NR {GOOD[","$0]="Good"; next} {print GOOD[$0] $0}' file1 file2
Good,SysA,10.123.456.789
,SysB,10.123.456.785
Good,SysD,10.123.456.787
Good,SysD,10.123.456.787
Good,SysE,10.123.456.786

There's no SysC line in your input, so I'm surprised there's one in your output, and there is a duplicate for SysD in your output even though you insisted on NO duplicates...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Work CSV file with awk loop

I need to converts a CSV file from Format "A" into Format "B", where the first field is repeated in a loop with a counter. I'am quite sure that this is with AWK possible burt the "Forum Search Function" doesn't work at the moment. Format "A" A1;B1 ;B2 ;B3 A2;C1 ;C2 ;C3 ... (2 Replies)
Discussion started by: frieling
2 Replies

2. Shell Programming and Scripting

Comparison and editing of files using awk.(And also a possible bug in awk for loop?)

I have two files which I would like to compare and then manipulate in a way. File1: pictures.txt 1.1 1.3 dance.txt 1.2 1.4 treehouse.txt 1.3 1.5 File2: pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244 dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2... (1 Reply)
Discussion started by: linuxkid
1 Replies

3. Shell Programming and Scripting

Help needed: Adding columns in csv file in loop

Hi Everyone: My shell script creates multiple csv files (~30) in for loop. I want to compile (or merge) 3rd column from each (all) of these files to another file (in loop). Please help. Thanks. (3 Replies)
Discussion started by: smap007
3 Replies

4. Shell Programming and Scripting

Merge 2 csv files with awk

I have 2 files pipe delimted and want to merge them based on a key e.g file 1 123$aaa$yyy$zzz 345$xab$yzy$zyz 456$sss$ttt$foo 799$aaa$ggg$dee file 2 123$hhh 345$ddd 456$xxx 888$zzz so if the key is the first field, and the result should be the common key between file 1 and 2 (6 Replies)
Discussion started by: loloAix
6 Replies

5. Shell Programming and Scripting

Sorting a .csv using awk or other

Hello all, I am new here and *relatively* new to Unix. I have a bit of an emergency. I have a three column file that I need to sort: sample name, miRNA, reads per million (RPM) There are multiple samples, and for each sample name there are multiple miRNAs and associated RPMs. Some of these... (6 Replies)
Discussion started by: dunnybocter
6 Replies

6. Shell Programming and Scripting

CSV to SQL insert: Awk for strings with multiple lines in csv

Hi Fellows, I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem: I have csv files in the following pipe-delimited format: Column1|Column2|Column3|Column4|NEWLINE Address Type|some descriptive... (4 Replies)
Discussion started by: khayal
4 Replies

7. Shell Programming and Scripting

awk read column csv and search in other csv

hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance (8 Replies)
Discussion started by: giankan
8 Replies

8. Shell Programming and Scripting

awk loop using array:wish to store array values from loop for use outside loop

Here's my code: awk -F '' 'NR==FNR { if (/time/ && $5>10) A=$2" "$3":"$4":"($5-01) else if (/time/ && $5<01) A=$2" "$3":"$4-01":"(59-$5) else if (/time/ && $5<=10) A=$2" "$3":"$4":0"($5-01) else if (/close/) { B=0 n1=n2; ... (2 Replies)
Discussion started by: klane
2 Replies

9. Shell Programming and Scripting

awk programming -Passing variable to awk for loop

Hi All, I am new to AWK programming. I have the following for loop in my awk program. cat printhtml.awk: BEGIN -------- <some code here> END{ ----------<some code here> for(N=0; N<H; N++) { for(M=5; M<D; M++) print "\t" D ""; } ----- } ... (2 Replies)
Discussion started by: ctrld
2 Replies

10. UNIX for Beginners Questions & Answers

awk on csv files

wk on csv files Hi I have two csv files 1 ) keys.csv with data as below XX1,offsite XX2,offsite XX8,none XX3,offsite XX4,onsite XX7,none XX5,onsite XX6,onsite XX15,none 2) source.csv file with data like 1,0123,ppp,XX1 2,0122,sss,XX2 3,1239,yyy,XX8 4,567,kkk,XX5 (2 Replies)
Discussion started by: zozoo
2 Replies
STRFMON(3P)						     POSIX Programmer's Manual						       STRFMON(3P)

PROLOG
This manual page is part of the POSIX Programmer's Manual. The Linux implementation of this interface may differ (consult the correspond- ing Linux manual page for details of Linux behavior), or the interface may not be implemented on Linux. NAME
strfmon - convert monetary value to a string SYNOPSIS
#include <monetary.h> ssize_t strfmon(char *restrict s, size_t maxsize, const char *restrict format, ...); DESCRIPTION
The strfmon() function shall place characters into the array pointed to by s as controlled by the string pointed to by format. No more than maxsize bytes are placed into the array. The format is a character string, beginning and ending in its initial state, if any, that contains two types of objects: plain characters, which are simply copied to the output stream, and conversion specifications, each of which shall result in the fetching of zero or more arguments which are converted and formatted. The results are undefined if there are insufficient arguments for the format. If the format is exhausted while arguments remain, the excess arguments are simply ignored. The application shall ensure that a conversion specification consists of the following sequence: * A '%' character * Optional flags * Optional field width * Optional left precision * Optional right precision * A required conversion specifier character that determines the conversion to be performed Flags One or more of the following optional flags can be specified to control the conversion: =f An '=' followed by a single character f which is used as the numeric fill character. In order to work with precision or width counts, the fill character shall be a single byte character; if not, the behavior is undefined. The default numeric fill character is the <space>. This flag does not affect field width filling which always uses the <space>. This flag is ignored unless a left precision (see below) is specified. ^ Do not format the currency amount with grouping characters. The default is to insert the grouping characters if defined for the cur- rent locale. + or ( Specify the style of representing positive and negative currency amounts. Only one of '+' or '(' may be specified. If '+' is speci- fied, the locale's equivalent of '+' and '-' are used (for example, in the U.S., the empty string if positive and '-' if negative). If '(' is specified, negative amounts are enclosed within parentheses. If neither flag is specified, the '+' style is used. ! Suppress the currency symbol from the output conversion. - Specify the alignment. If this flag is present the result of the conversion is left-justified (padded to the right) rather than right-justified. This flag shall be ignored unless a field width (see below) is specified. Field Width w A decimal digit string w specifying a minimum field width in bytes in which the result of the conversion is right-justified (or left-justified if the flag '-' is specified). The default is 0. Left Precision #n A '#' followed by a decimal digit string n specifying a maximum number of digits expected to be formatted to the left of the radix character. This option can be used to keep the formatted output from multiple calls to the strfmon() function aligned in the same columns. It can also be used to fill unused positions with a special character as in "$***123.45" . This option causes an amount to be formatted as if it has the number of digits specified by n. If more than n digit positions are required, this conversion specifi- cation is ignored. Digit positions in excess of those actually required are filled with the numeric fill character (see the =f flag above). If grouping has not been suppressed with the '^' flag, and it is defined for the current locale, grouping separators are inserted before the fill characters (if any) are added. Grouping separators are not applied to fill characters even if the fill character is a digit. To ensure alignment, any characters appearing before or after the number in the formatted output such as currency or sign symbols are padded as necessary with <space>s to make their positive and negative formats an equal length. Right Precision .p A period followed by a decimal digit string p specifying the number of digits after the radix character. If the value of the right precision p is 0, no radix character appears. If a right precision is not included, a default specified by the current locale is used. The amount being formatted is rounded to the specified number of digits prior to formatting. Conversion Specifier Characters The conversion specifier characters and their meanings are: i The double argument is formatted according to the locale's international currency format (for example, in the U.S.: USD 1,234.56). If the argument is +-Inf or NaN, the result of the conversion is unspecified. n The double argument is formatted according to the locale's national currency format (for example, in the U.S.: $1,234.56). If the argument is +-Inf or NaN, the result of the conversion is unspecified. % Convert to a '%' ; no argument is converted. The entire conversion specification shall be %% . Locale Information The LC_MONETARY category of the program's locale affects the behavior of this function including the monetary radix character (which may be different from the numeric radix character affected by the LC_NUMERIC category), the grouping separator, the currency symbols, and formats. The international currency symbol should be conformant with the ISO 4217:1995 standard. If the value of maxsize is greater than {SSIZE_MAX}, the result is implementation-defined. RETURN VALUE
If the total number of resulting bytes including the terminating null byte is not more than maxsize, strfmon() shall return the number of bytes placed into the array pointed to by s, not including the terminating null byte. Otherwise, -1 shall be returned, the contents of the array are unspecified, and errno shall be set to indicate the error. ERRORS
The strfmon() function shall fail if: E2BIG Conversion stopped due to lack of space in the buffer. The following sections are informative. EXAMPLES
Given a locale for the U.S. and the values 123.45, -123.45, and 3456.781, the following output might be produced. Square brackets ( "[]" ) are used in this example to delimit the output. %n [$123.45] Default formatting [-$123.45] [$3,456.78] %11n [ $123.45] Right align within an 11-character field [ -$123.45] [ $3,456.78] %#5n [ $ 123.45] Aligned columns for values up to 99999 [-$ 123.45] [ $ 3,456.78] %=*#5n [ $***123.45] Specify a fill character [-$***123.45] [ $*3,456.78] %=0#5n [ $000123.45] Fill characters do not use grouping [-$000123.45] even if the fill character is a digit [ $03,456.78] %^#5n [ $ 123.45] Disable the grouping separator [-$ 123.45] [ $ 3456.78] %^#5.0n [ $ 123] Round off to whole units [-$ 123] [ $ 3457] %^#5.4n [ $ 123.4500] Increase the precision [-$ 123.4500] [ $ 3456.7810] %(#5n [$ 123.45] Use an alternative pos/neg style [($ 123.45)] [$ 3,456.78] %!(#5n [ 123.45] Disable the currency symbol [( 123.45)] [ 3,456.78] %-14#5.4n [ $ 123.4500 ] Left-justify the output [-$ 123.4500 ] [ $ 3,456.7810 ] %14#5.4n [ $ 123.4500] Corresponding right-justified output [ -$ 123.4500] [ $ 3,456.7810] See also the EXAMPLES section in fprintf(). APPLICATION USAGE
None. RATIONALE
None. FUTURE DIRECTIONS
Lowercase conversion characters are reserved for future standards use and uppercase for implementation-defined use. SEE ALSO
fprintf(), localeconv(), the Base Definitions volume of IEEE Std 1003.1-2001, <monetary.h> COPYRIGHT
Portions of this text are reprinted and reproduced in electronic form from IEEE Std 1003.1, 2003 Edition, Standard for Information Technol- ogy -- Portable Operating System Interface (POSIX), The Open Group Base Specifications Issue 6, Copyright (C) 2001-2003 by the Institute of Electrical and Electronics Engineers, Inc and The Open Group. In the event of any discrepancy between this version and the original IEEE and The Open Group Standard, the original IEEE and The Open Group Standard is the referee document. The original Standard can be obtained online at http://www.opengroup.org/unix/online.html . IEEE
/The Open Group 2003 STRFMON(3P)
All times are GMT -4. The time now is 06:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy