Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: replacing column 3 in csv
Top Forums Shell Programming and Scripting replacing column 3 in csv Post 302702735 by mumbaiguy07 on Tuesday 18th of September 2012 07:12:55 PM
Old 09-18-2012
replacing column 3 in csv
sample csv
Code:
1234,abc,000,def,
5678,abc,010,def,
9012,abc,020,def,

desired output
Code:
1234,abc,0,def,
5678,abc,1,def,
9012,abc,2,def,

I need to change only the 2nd column from 000 to 0, 010 to 1 and 020 to 2 in shell. I tried using awk -F with if condition in column 3. It din help me
Last edited by Franklin52; 09-19-2012 at 05:03 AM.. Reason: Please use code tags for data and code samples
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Replacing characters in csv file

Hello all, This is my first post here, so please excuse me if this question is too obvious or has been asked before. I am new to Unix and although I tried to search your forum for the answer to my question, I could not find an answer that would help me. I have a 500MB csv file with numeric values... (1 Reply)
Discussion started by: finwhiz
1 Replies

2. Shell Programming and Scripting

Replacing column with another column of different file by awk

Hi All, I will really appreciate if you kindly lookinto my requirement below and provide me a solution First file format test1.txt qq ww rr tt ee ff qq ww rr tt ee ff Second file format text2.txt aa aa Now o/p I want as text1.txt's 4th column replaced... (5 Replies)
Discussion started by: Pratik4891
5 Replies

3. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

4. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

5. 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

6. Shell Programming and Scripting

Pick the column value based on another column from .csv file

My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated. Main imp point, in my .csv file, third column is having price value with comma (1,20,300), it has... (2 Replies)
Discussion started by: Ganesh L
2 Replies

7. Shell Programming and Scripting

Remove the values from a certain column without deleting the Column name in a .CSV file

(14 Replies)
Discussion started by: dhruuv369
14 Replies

8. Shell Programming and Scripting

Get maximum per column from CSV file, based on date column

Hello everyone, I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this: 20170628-23:25:01,1,0,0,1,1,1,1,55,55,1 20170628-23:30:01,1,0,0,1,1,1,1,56,56,1 20170628-23:35:00,1,0,0,1,1,2,1,57,57,2 20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies

9. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies

LEARN ABOUT DEBIAN

ecaccess-event-grant

ECACCESS-EVENT-GRANT(1p)				User Contributed Perl Documentation				  ECACCESS-EVENT-GRANT(1p)

NAME

       ecaccess-event-grant - Grant usage of an ECaccess Event

SYNOPSIS

       ecaccess-event-grant -version|-help|-manual

       ecaccess-event-grant [-debug] [-subscribe] [-notify] event-id user-list

DESCRIPTION

       Allow managing the Event permissions for a list of user(s).

       The permissions can be either subscribe, notify, both or none. In order to remove permissions to an Event for a list of users use this
       command with no -subscribe and -notify options.

ARGUMENTS

       event-id
	       The identifier of the Event to grant.

       user-list
	       The user(s) to give/remove the permissions. Multiple users should be separated by a column (e.g. abc,def).

OPTIONS

       -subscribe
	       The user(s) specified in the user-list will be allowed to subscribe to the event-id (e.g. with the -eventIds option of the
	       ecaccess-job-submit command).

       -notify The user(s) specified in the user-list will be allowed to send notifications to the event-id (e.g. with the ecaccess-event-send
	       command).

       -version
	       Display version number and exits.

       -help   Print a brief help message and exits.

       -manual Prints the manual page and exits.

       -debug  Display the SOAP messages exchanged.

EXAMPLES

       ecaccess-event-grant -subscribe 167 abc,def,jhi

       Allow the users abc, def and jhi to subscribe to this Event.

       ecaccess-event-grant 167 jkl

       Remove all rights to the Event for the user jkl.

SEE ALSO

       ecaccess-event-clear, ecaccess-event-delete, ecaccess-event-send, ecaccess-event-list, ecaccess-event-create and ecaccess.

perl v5.14.2							    2012-04-16						  ECACCESS-EVENT-GRANT(1p)
All times are GMT -4. The time now is 07:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy