Fetching values in CSV file based on column name Post: 302871871

9 More Discussions You Might Find Interesting

1. 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. Shell Programming and Scripting

Check to identify duplicate values at first column in csv file

Hello experts, I have a requirement where I have to implement two checks on a csv file: 1. Check to see if the value in first column is duplicate, if any value is duplicate script should exit. 2. Check to verify if the value at second column is between "yes" or "no", if it is anything else...

3. Shell Programming and Scripting

Script for extracting data from csv file based on column values.

Hi all, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm....

4. Shell Programming and Scripting

Fetching columns from .csv file except last column

Hi, i have below list of files so i just want the name of the files in one parameter and not the timestamp. i want only GIDW_Dy_Tm_Seg_Sls_legacy_PL_0_0_ in variable of all files. GIDW_Dy_Tm_Seg_Sls_legacy_PL_0_0_20131001101800.csv GIDW_Dly_Sls_legacy_RO_0_0_20131001172001.csv ...

5. Linux

Filter a .CSV file based on the 5th column values

I have a .CSV file with the below format: "column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10 "12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""...

6. Shell Programming and Scripting

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

7. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this?

8. Shell Programming and Scripting

Identify duplicate values at first column in csv file

Input 1,ABCD,no 2,system,yes 3,ABCD,yes 4,XYZ,no 5,XYZ,yes 6,pc,noCode used to find duplicate with regard to 2nd column awk 'NR == 1 {p=$2; next} p == $2 { print "Line" NR "$2 is duplicated"} {p=$2}' FS="," ./input.csv Now is there a wise way to de-duplicate the entire line (remove...

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

LEARN ABOUT DEBIAN

canto-fetch

Canto-fetch(1)							    Canto-fetch 						    Canto-fetch(1)

NAME

       Canto-fetch - A quiet feed fetcher.

DESCRIPTION

       Canto-fetch  is	designed  to  be run through a cron job, every minute. Every time it's run, it checks the timestamp on each index file and
       updates the feed, if necessary. The format it produces is a simple UTF-8 encoded, NULL delimited text file on disk, readable by	the  canto
       client.

GETTING STARTED

       Canto-fetch is meant to be used through a cron, adding this line to your crontab will cause canto-fetch to poll every minute.

       * * * * * canto-fetch

       Alternatively,  if  you're unable/uncomfortable using cron, canto-fetch has a background daemon mode so you can invoke it in your X session
       scripts. Just use

       canto-fetch -b

USAGE

       These options correspond to options to the canto client.

       -h / --help
	      Print usage and quit.

       -v / --version
	      Print version and quit.

       -V / --verbose
	      Output status while updating.

       -d / --daemon
	      Continue to check for updates every minute. Mostly for debugging with -V, users probably want -b to background.

       -b / --background
	      Detach from the terminal (implies -d)

       -f / --force
	      Force updates on all feeds, ignoring timestamps.

       -s / --sysfp
	      Use feedparser on system instead of builtin copy.

       -C / --conf [PATH]
	      Set path to configuration file (default: ~/.canto/conf)

       -F / --fdir [PATH]
	      Set path to feed directory (default: ~/.canto/feeds/)

       -L / --log [PATH]
	      Set path to log (default: ~/.canto/fetchlog)

       -S / --sdir [PATH]
	      Set the path to execurl scripts (default ~/.canto/scripts/)

FILES

       ~/.canto/fetchlog
	      Canto-fetch log file.

       ~/.canto/feeds/
	      This is the directory where canto-fetch records stories.

BUGS

       None known, but it's not outside of the realm of possibility =P.

HOMEPAGE

       http://codezen.org/canto

AUTHOR

       Jack Miller <jack@codezen.org>

Version 0.7.10							   27 July 2010 						    Canto-fetch(1)