Sponsored Content
Full Discussion: Awk help required
Top Forums Shell Programming and Scripting Awk help required Post 302398279 by ajay547 on Wednesday 24th of February 2010 06:33:46 AM
Old 02-24-2010
Awk help required

Hi All,

I have 2 .csv files as below

File1.csv
Code:
name1,20,30,date1
name2,30,40,date1

File2.csv
Code:
name1,25,35,date1
name2,45,55,date1

Can any one help me to add the 2nd and 3rd column of file1 and file2 and write the output into a new file as below

Code:
name1,45,65,date1
name2,75,95,date1

Thanks in advance.
Ajay

Last edited by Franklin52; 02-24-2010 at 07:35 AM.. Reason: Please use code tags!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help required on AWK command

I have two questions: (Q1) I am using a loop and want to print a particular field of a table using the AWK command by accessing one row at a time by validating NR with the loop counter. I am using a command like this but it isn't working! count=1 NAWK -F"|" -v var=$count 'NR == var { printf... (13 Replies)
Discussion started by: udiptya
13 Replies

2. Shell Programming and Scripting

Help required on awk

Hi, I have a fixed with file, which have almost 10 records Sample File: ------------ AR 100 TTT BC 200 SSS DA 199 YYY AR 500 RRR PO 300 QQQ PB 800 PPP PC 150 OOO AR 111 CCC AD 321 LLL I Have to check for first two charactors and if its 'AR' i have to save those records to one... (3 Replies)
Discussion started by: meetavin
3 Replies

3. Shell Programming and Scripting

AWK script help required

Hello every one i have a very long file 'file1' like this <K>1</K> </Condition> <Tariff>Rate <Price>1.27</Price> <Interval>30</Interval> </Tariff> </Node> <Node>NonFaF <Tariff>Rate <Price>1.9</Price> <Interval>30</Interval> </Tariff> </Node> </Node> </Node> <Node>FaF (9 Replies)
Discussion started by: Dastard
9 Replies

4. Shell Programming and Scripting

Help required in sed or awk.

Hi All, I need to pick up data on both sides of "=" sign. For eg, following is the context that I have. 125.156.125.147=machine1 147.125.185.156=machine2 147.125.185.159=machine3 Can I have the ip address in one variable and machine name in another variable using sed or awk. ... (1 Reply)
Discussion started by: nua7
1 Replies

5. Shell Programming and Scripting

Help required with awk/sed

Hi I have a file, with format like: column1|coulumn2|column3|column4 A|X|K|18 L|O|R|31,42,25 G|H|I|55,66 L|E|Q|25,31,94 output required: column1|coulumn2|column3|column4 A|X|K|18 L|O|R|31,25 L|E|Q|25,31 Input File Format: All columns are seperated using |, last column... (8 Replies)
Discussion started by: New to awk
8 Replies

6. Shell Programming and Scripting

Searching using awk - Help required

Hi... I am working on script to search some records in a file based on certain fields and each record is a ASCII fixed size. I was using awk to search based on certain condition. But the length of the record is too much that awk is giving syntax error near unexpected token `(' Request... (5 Replies)
Discussion started by: ysrikanth
5 Replies

7. Shell Programming and Scripting

awk script required

File 1 ################### TRAIU DSKDL; SLLA ;LAKJA KJAJA NSAJAN JANAL AJKJA JAJALA KAKAK JA AKA AKA AJ A A PPIN TRY1 SANT1 PPIN TRY2 SANT2 PPIN TRY3 SANT3 PPIN TRY4 SANT4 PPIN TRY5 SANT5 AJJA NA ANA ANHDJLD ALJALJA AJLJAJD LALJAL ALJALJA ALJALJA (4 Replies)
Discussion started by: jaita
4 Replies

8. Shell Programming and Scripting

Awk help required for formatting digits.

Hi experts, I have two values in the file : For example : partcamt = 72.90 partdamt=27.9 I need to convert these values into 6 digits and ignore the "." sign so that the desired desired output is : total value= 0072000027900 Currently I am using the following code : ... (3 Replies)
Discussion started by: nua7
3 Replies

9. Shell Programming and Scripting

awk help required

Hello, I am trying to get an output from awk and have been unsuccessful so far. There is an input file which contains certain segments, that needs to be read and append with another data after matching the segment... Input file is as shown below ISA*00* *00* *01*781495650... (2 Replies)
Discussion started by: rakeshv
2 Replies

10. Shell Programming and Scripting

REGEX help required and some sed/awk help as well

Hi guys, I am coding a bash script that makes use of php scripts to pull URL's from a website. These url links will have numbers in them like 0.2.3 I want to make a regex that will yield me such numbers if I use a command like preg_grep. Question1: I need a regex that will tell my preg_grep... (2 Replies)
Discussion started by: mojoman
2 Replies
link(2) 							System Calls Manual							   link(2)

Name
       link - link to a file

Syntax
       link(name1, name2)
       char *name1, *name2;

Description
       A hard link to name1 is created; the link has the name name2.  The name1 must exist.

       With  hard links, both name1 and name2 must be in the same file system.	Unless the caller is the superuser, name1 must not be a directory.
       Both the old and the new share equal access and rights to the underlying object.

Return Values
       Upon successful completion, a value of 0 is returned.  Otherwise, a value of -1 is returned, and errno is set to indicate the error.

Diagnostics
       The system call fails and no link is created under the following conditions:

       [ENOTDIR]      A component of either path prefix is not a directory.

       [ENAMETOOLONG] A component of either pathname exceeded 255 characters, or the entire length of either pathname exceeded 1023 characters.

       [ENOENT]       A component of either path prefix does not exist.

       [ENOENT]       The file named by name1 does not exist.

       [ENOENT]       When name1 or name2 point to an empty string and the environment defined is POSIX or SYSTEM_FIVE.

       [EACCES]       A component of either path prefix denies search permission.

       [EACCES]       The requested link requires writing in a directory with a mode that denies write permission.

       [EEXIST]       The link named by name2 does exist.

       [EPERM]	      The file named by name1 is a directory, and the effective user ID is not that of superuser or  the  environment  defined	is
		      POSIX.

       [EXDEV]	      The link named by name2 and the file named by name1 are on different file systems.

       [EROFS]	      The requested link requires writing in a directory on a read-only file system.

       [EFAULT]       One of the pathnames specified is outside the process's allocated address space.

       [ELOOP]	      Too many symbolic links were encountered in translating one of the pathnames.

       [ENOSPC]       The  directory  in which the entry for the new link is being placed cannot be extended because there is no space left on the
		      file system containing the directory.

       [EDQUOT]       The directory in which the entry for the new link is being placed cannot be extended because the user's quota of disk blocks
		      on the file system containing the directory has been exhausted.

       [EIO]	      An I/O error occurred while reading from or writing to the file system to make the directory entry.

       [ESTALE]       The  file  handle  given	in the argument is invalid.  The file referred to by that file handle no longer exists or has been
		      revoked.

       [ETIMEDOUT]    A connect request or remote file operation failed because the connected party did not properly respond  after  a	period	of
		      time that is dependent on the communications protocol.

       [EMLINK]       The number of links to the file named by path1 would exceed {LINK_MAX}.

Environment
       In the POSIX environment, linking to directories is not allowed.

See Also
       symlink(2), unlink(2)

																	   link(2)
All times are GMT -4. The time now is 04:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy