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)
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)
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)
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)
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)
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)
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
LEARN ABOUT ULTRIX
diffmk
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 Alsocmp(1), comm(1), diff(1), nroff(1), join(1), sccsdiff(1), troff(1), uniq(1)diffmk(1)