Sponsored Content
Full Discussion: Csv file editing
Top Forums UNIX for Beginners Questions & Answers Csv file editing Post 303030044 by vinnu0154 on Tuesday 5th of February 2019 10:12:49 AM
Old 02-05-2019
Csv file editing

Help me,

I have a csv file with following fields:

Code:
sim	  name1	name2	name3	name4	name5	count
file1	        0.1	  0.2   	0.3	          0.4	0.5	
file2	0.1	 0.2	        0.3	          0.4	0.5	
file3	0.1	 0.2	        0.3	          0.4	0.5	
file4	0.1	0.2	        0.3	          0.4	0.5	
file5	0.1	0.2	        0.3	          0.4	0.5

i need to get the count if the value of the row is >0.3. i.e. for example in the count column it has to show 2,2,2,2,2 . help me code this on shell.

Thanks,
Arun.

Last edited by vgersh99; 02-05-2019 at 11:23 AM.. Reason: Code tags, please!
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies

2. Shell Programming and Scripting

2 problems: Mailing CSV file / parsing CSV for display

I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out! I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies

3. Shell Programming and Scripting

csv file editing using KSH

I'm trying to write a shell script to extract useful fields in a csv file and copy them to a new file: the input file is as below when opened using notepad++: //////////////////////////////////////////////////////////// ZZZZZZZZZZZZZZZZZZZZZZ ,"A", , , ,24,18,0,0,42,0 , ,B, ,... (1 Reply)
Discussion started by: zekruss
1 Replies

4. Shell Programming and Scripting

Comparing 2 CSV files and sending the difference to a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 ... (1 Reply)
Discussion started by: Naresh101
1 Replies

5. Shell Programming and Scripting

Compare 2 csv files in ksh and o/p the difference in a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 The... (7 Replies)
Discussion started by: Naresh101
7 Replies

6. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies

7. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

8. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

9. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies
diffmk(1)						      General Commands Manual							 diffmk(1)

Name
       diffmk - mark differences between files

Syntax
       diffmk name1 name2 name3

Description
       The  command compares two versions of a file and creates a third file that includes ``change mark'' commands for or The name1 and name2 are
       the old and new versions of the file.  The command generates name3, which contains the lines of	name2  plus  inserted  formatter  ``change
       mark''  (.mc) requests.	When name3 is formatted, changed or inserted text is shown by | at the right margin of each line.  The position of
       deleted text is shown by a single *.

       The command can be used to produce listings of C (or other) programs with changes marked.  A typical command line for such use is the  fol-
       lowing:
       diffmk old.c new.c tmp; nroff macs tmp | pr
       In this example the file macs contains:

	      .pl 1
	      .ll 77
	      .nf
	      .eo
	      .nc `

       The  .ll request might specify a different line length, depending on the nature of the program being printed.  The .eo and .nc requests are
       probably needed only for C programs.

       If the characters | and * are inappropriate, a copy of can be edited to change them.  The command is a shell procedure.

Restrictions
       Aesthetic considerations may dictate manual adjustment of some output.  File differences involving only	formatting  requests  may  produce
       undesirable output, that is, replacing .sp by .sp 2 will produce a ``change mark'' on the preceding or following line of output.

See Also
       cmp(1), comm(1), diff(1), nroff(1), join(1), sccsdiff(1), troff(1), uniq(1)

																	 diffmk(1)
All times are GMT -4. The time now is 10:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy