02-05-2019
Hi Arun,
Welcome to the UNIX.com forums.
Whenever you start a thread here, it always helps us if you tell us what operating system and shell you're using. Various systems and shells have many similar, but not always identical tools and options. If we don't know what shell and operating system you're using, we are likely to make suggestions that will not work in your environment.
Please also show us what you have tried, what errors you are getting, what output you're getting, and tell us where you are stuck. We are here to help you learn how to do things for yourself; not to act as your unpaid programming staff.
When you say you're using a csv file, that can mean several things. Usually, it is a file containing fields that are separated by a comma. Sometimes it is a file containing fields that are separated by some other single character such as a <tab>, a <colon>, a <semicolon>, or some other single character. The sample data you've shown us seems to use a <tab> character to separate some fields and a <tab> and a varying number of <space>s for other fields. We need a clear description of what file format you are actually using.
You also need to clearly describe the output you are trying to produce. Saying that the count field should be 2,2,2,2,2 seems to be saying that you want each line of output to contain identical data that indicates the number of data points in each column that contains a value greater than .3, but that doesn't match the sample data you have supplied. Please clearly describe, in English, what the data in the count field should be for each input line AND please show us the exact output that you hope to produce from the sample input file you have supplied (in CODE tags).
Note also that if every line of input in your sample data has identical data in the fields that are being investigated, it makes it hard to know if any code that we might write for you is actually performing the checks you want to perform.
Please help us help you.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
(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
(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
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
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
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
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