Sponsored Content
Top Forums Shell Programming and Scripting Help needed: Adding columns in csv file in loop Post 302480649 by smap007 on Wednesday 15th of December 2010 11:48:18 AM
Old 12-15-2010
Thank you.. It helped..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl: adding columns in CSV file with information in each

Hi Wise UNIX Crew, I want to add 3 different columns to the file in which: 1. The first new column pulls in today's date and time 2. Second column one has a '0' 3. Third column has the word 'ANY' going down the column If my file content is as follows: "7","a","abc",123"... (1 Reply)
Discussion started by: dolo21taf
1 Replies

2. UNIX for Advanced & Expert Users

Adding columns in csv

I have the following data in FILE1.CSV: code: Amount1: Amount2: xxxxx ,, 200 ,,400 yyxxa ,,200 bbcgu ,,2500 ,,300 i want to be able to produce the following FILE2.CSV: code: Amount xxxxx ,, 600... (7 Replies)
Discussion started by: chachabronson
7 Replies

3. UNIX for Dummies Questions & Answers

Adding columns to a file

I want to select the first column from a daily file called foo.csv. The result is written to file foo.txt. Currently the following script is used for that: cut -d, -f 1 foo.csv > foo.txt A typical result would yield : A12 A45 B11 B67 What needs to happen in addition is that two columns... (5 Replies)
Discussion started by: figaro
5 Replies

4. UNIX for Advanced & Expert Users

Unix Bash: substitute columns in .csv using other .csv columns

Hi All, I have two .csv's input.csv having values as (7 columns) ABC,A19907103,ABC DEV YUNG,2.17,1000,2157,07/07/2006 XYZ,H00213850,MM TRUP HILL,38.38,580,23308,31/08/2010 output.csv having (25 columns) A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y... (4 Replies)
Discussion started by: abhivyas
4 Replies

5. UNIX for Advanced & Expert Users

Help in adding in csv file

Hi experts I have a .csv file which contains the csv is comma seperated file col1 col2 1 2 3 4 5 6 7 8 I want the colums to be added and the output must be col1 col2 col3 1 2 3 3 4 7 5 6 11 7 8 15 Please help:( (1 Reply)
Discussion started by: mariselvam
1 Replies

6. UNIX for Advanced & Expert Users

Help in Deleting columns and Renaming Mutliple columns in a .Csv File

Hi All, i have a .Csv file in the below format startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues 11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0,... (9 Replies)
Discussion started by: mahi_mayu069
9 Replies

7. Shell Programming and Scripting

Adding Extra Commas to a CSV file

Trying in this forum. Not sure if it is permitted.... but in need of help. Please find the requirements in the below link. https://www.unix.com/unix-dummies-questions-answers/191503-add-extra-commas-csv-file-2.html#post302665179 Thanks in Advance. (1 Reply)
Discussion started by: chillblue
1 Replies

8. Shell Programming and Scripting

Deleting all the fields(columns) from a .csv file if all rows in that columns are blanks

Hi Friends, I have come across some files where some of the columns don not have data. Key, Data1,Data2,Data3,Data4,Data5 A,5,6,,10,, A,3,4,,3,, B,1,,4,5,, B,2,,3,4,, If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies

9. Shell Programming and Scripting

Adding a new column to a csv file

Hi, Can anyone please explain me how can I add a new column to a Csv file ? Actaully I am setting one set of commands and creating a CSV file with 4 columns. I am executing another command and it's output should be added as column 5 with a column heading ? Can anyone explain how can... (26 Replies)
Discussion started by: rrb2009
26 Replies

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... (10 Replies)
Discussion started by: djoseph
10 Replies
Wiki::Toolkit::Plugin::Locator::Grid(3pm)		User Contributed Perl Documentation		 Wiki::Toolkit::Plugin::Locator::Grid(3pm)

NAME
Wiki::Toolkit::Plugin::Locator::Grid - A Wiki::Toolkit plugin to manage co-ordinate data. DESCRIPTION
Access to and calculations using co-ordinate metadata supplied to a Wiki::Toolkit wiki when writing a node. Note: This is read-only access. If you want to write to a node's metadata, you need to do it using the "write_node" method of Wiki::Tool- kit. We assume that the points are located on a flat, square grid with unit squares of side 1 metre. SYNOPSIS
use Wiki::Toolkit; use Wiki::Toolkit::Plugin::Locator::Grid; my $wiki = Wiki::Toolkit->new( ... ); my $locator = Wiki::Toolkit::Plugin::Locator::Grid->new; $wiki->register_plugin( plugin => $locator ); $wiki->write_node( "Jerusalem Tavern", "A good pub", $checksum, { x => 531674, y => 181950 } ) or die "argh"; # Just retrieve the co-ordinates. my ( $x, $y ) = $locator->coordinates( node => "Jerusalem Tavern" ); # Find the straight-line distance between two nodes, in metres. my $distance = $locator->distance( from_node => "Jerusalem Tavern", to_node => "Calthorpe Arms" ); # Find all the things within 200 metres of a given place. my @others = $locator->find_within_distance( node => "Albion", metres => 200 ); # Maybe our wiki calls the x and y co-ordinates something else. my $locator = Wiki::Toolkit::Plugin::Locator::Grid->new( x => "os_x", y => "os_y", ); METHODS
new # By default we assume that x and y co-ordinates are stored in # metadata called "x" and "y". my $locator = Wiki::Toolkit::Plugin::Locator::Grid->new; # But maybe our wiki calls the x and y co-ordinates something else. my $locator = Wiki::Toolkit::Plugin::Locator::Grid->new( x => "os_x", y => "os_y", ); x_field my $x_field = $locator->x_field; An accessor, returns the name of the metadata field used to store the x-coordinate. y_field my $y_field = $locator->y_field; An accessor, returns the name of the metadata field used to store the y-coordinate. coordinates my ($x, $y) = $locator->coordinates( node => "Jerusalem Tavern" ); Returns the x and y co-ordinates stored as metadata last time the node was written. distance # Find the straight-line distance between two nodes, in metres. my $distance = $locator->distance( from_node => "Jerusalem Tavern", to_node => "Calthorpe Arms" ); # Or in kilometres, and between a node and a point. my $distance = $locator->distance( from_x => 531467, from_y => 183246, to_node => "Duke of Cambridge", unit => "kilometres" ); Defaults to metres if "unit" is not supplied or is not recognised. Recognised units at the moment: "metres", "kilometres". Returns "undef" if one of the endpoints does not exist, or does not have both co-ordinates defined. The "node" specification of an end- point overrides the x/y co-ords if both specified (but don't do that). Note: Works to the nearest metre. Well, actually, calls "int" and rounds down, but if anyone cares about that they can send a patch. find_within_distance # Find all the things within 200 metres of a given place. my @others = $locator->find_within_distance( node => "Albion", metres => 200 ); # Or within 200 metres of a given location. my @things = $locator->find_within_distance( x => 530774, y => 182260, metres => 200 ); Units currently understood: "metres", "kilometres". If both "node" and "x"/"y" are supplied then "node" takes precedence. Croaks if insufficient start point data supplied. SEE ALSO
* Wiki::Toolkit * OpenGuides - an application that uses this plugin. AUTHOR
Kake Pugh (kake@earth.li). The Wiki::Toolkit team (http://www.wiki-toolkit.org/) COPYRIGHT
Copyright (C) 2004 Kake L Pugh. All Rights Reserved. Copyright (C) 2006 the Wiki::Toolkit Team. All Rights Reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. CREDITS
This module is based heavily on (and is the replacement for) Wiki::Toolkit::Plugin::Locator::UK. The following thanks are due to people who helped with Wiki::Toolkit::Plugin::Locator::UK: Nicholas Clark found a very silly bug in a pre- release version, oops :) Stephen White got me thinking in the right way to implement "find_within_distance". Marcel Gruenauer helped me make "find_within_distance" work properly with postgres. perl v5.8.8 2007-10-23 Wiki::Toolkit::Plugin::Locator::Grid(3pm)
All times are GMT -4. The time now is 10:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy