Conditional replacement in CSV files Post: 302911658

10 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. UNIX for Dummies Questions & Answers

conditional renaming of files

Hello, I want to rename all the files in my directory according to the following criterion: IF the original filename does not end in 0 THEN rename the file to "original filname" but with the last character preceded by the string: _copy IF the original filename ends in 0 THEN take the...

3. Shell Programming and Scripting

HELP Need in SED/PERL conditional line replacement

Hi , I need some help on perl/sed conditional replacement The situation is like below . I have a file contents like below . AAA|BBB|CCC|DDD AAA|BCF|CCC|HHH AAA|BVF|JJJ|KKK Here in the above file . I know my second column value (taking "|" as my delimited ) Basically I have to...

4. Shell Programming and Scripting

Conditional tab replacement sed/awk

Hi I am struggling to find a solutions to this problem: I have a directory full of files and I wish to: read each line of each file and if any one line in those files is longer than 72 characters I want to replace any tab characters with a space character. Ive been...

5. Shell Programming and Scripting

conditional replacement

Hi all, I need a bash, sed, awk script or one liner to do the following task: This is the format of a text file: 2010-06-11 20:01 902656 HOP-W-100412-1.doc 2010-11-05 18:01 364447 NEX-W-101104-1 2010-07-06 10:01 64512 Cerintele 2010-07-06 10:01 599420 content 2010-07-19 14:01 1785344...

6. Shell Programming and Scripting

Conditional replacement of a delimiter

Hello, I'm new to this forum but this seems like the place to ask this question. I have a pipe delimited data file with the fields except for the header being encased in double quotes. I found out that some of the fields have an trash pipe within the data itself. I'd like to conditionally...

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

8. Shell Programming and Scripting

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

9. Shell Programming and Scripting

Conditional replacement of columns in a text file

Hello scriping expert friends, I have 2 requirements on replacing fields of text files: I have lot of data with contents like below: Requirement-1: The digit after 0 should always be changed to 1

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

LEARN ABOUT OSX

rwbytype.d

rwbytype.d(1m)							   USER COMMANDS						    rwbytype.d(1m)

NAME

       rwbytype.d - read/write bytes by vnode type. Uses DTrace.

SYNOPSIS

       rwbytype.d

DESCRIPTION

       This program identifies the vnode type of read/write activity - whether that is for regular files, sockets, character special devices, etc.
       This is measuring at the application level, so file activity may well be cached by the system.

       Since this uses DTrace, only users with root privileges can run this command.

EXAMPLES

       This samples until Ctrl-C is hit.
	      # rwbytype.d

FIELDS

       PID    process ID

       CMD    process name

       VNODE  vnode type (describes I/O type)

       DIR    direction, Read or Write

       BYTES  total bytes

DOCUMENTATION

       See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver-
       bose descriptions explaining the output.

EXIT

       rwbytype.d will sample until Ctrl-C is hit.

AUTHOR

       Brendan Gregg [Sydney, Australia]

SEE ALSO

       rwbypid.d(1M), rwbbypid.d(1M), dtrace(1M)

version 0.70							   Jan 11, 2006 						    rwbytype.d(1m)