Sponsored Content
Top Forums Shell Programming and Scripting Output first unique record in csv file Post 302882728 by Chris LAU on Thursday 9th of January 2014 12:04:06 AM
Old 01-09-2014
Hi Kurumi,

I don't have Ruby on my system. Is there any other solution please?

Regards,
Chris
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to delete a record from a csv file

Hi Guys I have downloaded a table from oracle database in .csv format. it has many fields as Title, First Name, Last Name etc. I have to download distinct titles from database and now i have to check all those titles from data of First Name one by one. and then i have to delete matched record.... (1 Reply)
Discussion started by: Rajeev Agrawal
1 Replies

2. Shell Programming and Scripting

Record count of a csv file

Hello Gurus, We have a requirement to count the valid number of records in a comma delimited file with double quotes. The catch here is..few records have a new line carriage within the double quotes,,say for ex:we have a file called accounts the record count is 4827..but the actual valid count... (5 Replies)
Discussion started by: ajaykk
5 Replies

3. Shell Programming and Scripting

Split long record into csv file

Hi I receive a mainframe file which has very long records (1100 chars) with no field delimiters. I need to parse each record and output a comma delimited (csv) file. The record layout is fixed. If there weren't so many fields and records I would read the file into Excel, as a "fixed width"... (10 Replies)
Discussion started by: wvdeijk
10 Replies

4. Shell Programming and Scripting

return a list of unique values of a column from csv format file

Hi all, I have a huge csv file with the following format of data, Num SNPs, 549997 Total SNPs,555352 Num Samples, 157 SNP, SampleID, Allele1, Allele2 A001,AB1,A,A A002,AB1,A,A A003,AB1,A,A ... ... ... I would like to write out a list of unique SNP (column 1). Could you... (3 Replies)
Discussion started by: phoeberunner
3 Replies

5. Shell Programming and Scripting

csv file - adding total to a trailer record

Hi, I have a script which creates and modifies a csv file. I have managed to do everything I need to do apart from 1 thing. I need to append a trailer record to the file. I need this line to hold the total of an entire column of the csv file (skipping the 1st line which is a header). Can... (2 Replies)
Discussion started by: mcclunyboy
2 Replies

6. Shell Programming and Scripting

List unique values and count instances in .csv file

I need to take the second column of a .csv file and count the number of instances of each unique value in that same second column. I'd like the output to be value,count sorted by most instances. Thanks for any guidance! Data example: 317476,317756,0 816063,318861,0 313123,319091,0... (4 Replies)
Discussion started by: batcho
4 Replies

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? (1 Reply)
Discussion started by: sanvel
1 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

10. Shell Programming and Scripting

CSV File:Filter duplicate records from column1 & another column having unique record

Hi Experts, I have csv file with 30, 40 columns Pasting just 2 column for problem description. Need to print error if below combination is not present in file check for column-1 (DocumentNumber) and filter columns where value in DocumentNumber field is same. For all such rows, the field... (7 Replies)
Discussion started by: as7951
7 Replies
RUBY-BUILD(1)															     RUBY-BUILD(1)

NAME
ruby-build - compile and install Rubies SYNOPSIS
ruby-build [-v|--verbose] [-k|--keep] definition prefix ruby-build --definitions ruby-build --version ruby-build [-h|--help] rbenv install [-k|--keep] definition DESCRIPTION
ruby-build provides a simple way to compile and install different versions of Ruby on UNIX-like systems. ruby-build downloads, builds and installs the Ruby version specified in a definition into a prefix directory. Definitions can be chosen from the list of installed definitions or by specifying a file path for a definition. rbenv(1) users can also use the provided rbenv install command, which installs Rubies into the rbenv directory. OPTIONS
--definitions List available definitions. -k, --keep Don't delete source code after installation. -v, --verbose Display compiler messages on standard output. --version Show ruby-build version and exit. -h, --help Show usage information and exit. EXAMPLES
Install Ruby 1.9.3 (MRI, patch level 0) to ~/rubies/mri-1.9.3 $ ruby-build 1.9.3-p0 ~/rubies/mri-1.9.3 Install Ruby Enterprise Edition 1.8.7 (patch level 2011.03) for rbenv(1): $ rbenv install ree-1.8.7-2011.03 Install Ruby from a custom definition into ~/your-ruby: $ rbenv install /path/to/your/own/ruby/definition ~/your-ruby ENVIRONMENT
CC Sets the path to the C compiler. CONFIGURE_OPTS Options that are passed to configure when building a Ruby. MAKE_OPTS Options that are passed to make when building a Ruby. MAKEOPTS Used instead of MAKE_OPTS when MAKE_OPTS is not defined. TMPDIR Sets the location where ruby-build stores temporary files. RUBY_BUILD_BUILD_PATH Sets the location in which sources are downloaded and built. AUTHORS
ruby-build is developed by Sam Stephenson <sam@37signals.com>. This man page was written for the Debian GNU/Linux distribution by Sebastian Boehm <sebastian@sometimesfood.org> but may be used by others. SEE ALSO
rbenv(1) June 2012 RUBY-BUILD(1)
All times are GMT -4. The time now is 01:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy