Modify csv-files with awk Post: 303021680

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

csv files (with quoted commas) and awk

I have a file as follows: 1,"This is field 2",3,4,5 2,"This is field 2 it can contain one , comma",3,4,5 3,"This is field 2 it also, can, contain, more",3,4,5 4,"This is field 2 without extra commas",3,4,5 and i pass this through to awk: awk -F, ' { if (...

2. Shell Programming and Scripting

Need to modify csv-file with bash script

Hi Guys, I need to write a script, that exports the "moz_places" table of the "places.sqlite"-file (firefox browser history) into a csv-file. That part works. After the export, my csv looks like this: ... 4429;http://www.sqlite.org/sqlite.html;"Command Line Shell For...

3. Shell Programming and Scripting

Merge 2 csv files with awk

I have 2 files pipe delimted and want to merge them based on a key e.g file 1 123$aaa$yyy$zzz 345$xab$yzy$zyz 456$sss$ttt$foo 799$aaa$ggg$dee file 2 123$hhh 345$ddd 456$xxx 888$zzz so if the key is the first field, and the result should be the common key between file 1 and 2

4. Shell Programming and Scripting

Read data from .csv file through shell script & modify

I need to read data from a file called "test.csv" through shell script where the file contains values like name,price,descriptor etc. There are rows where descriptor (& in some rows name) are written as string & other characters like "car_+" OR "bike*" etc where it should contains strings like...

5. Shell Programming and Scripting

Calling Pl/sql function in shell script to modify csv

I need to 1.Open a csv 2.Process the csv i.e. Modify 2 column in the csv. To modify the column the value needs to be passed to a pl/sql function and the return value should be updated For eg: If column 2 E,then E will be passed in database function which will return Employee. 3. Write a...

6. Shell Programming and Scripting

Perl script to modify csv file

Hi Friends, I want to convert a csv file into a ordinary .txt file. I am able to convert but I want the output to look as shown below in the .txt file table findhost= { {"xyz","abc"}, {"rxz","mmz"}, {"vrr","nnz"}, } default={"NONE"} My current perl script #!/usr/bin/env perl...

7. Shell Programming and Scripting

Modify CSV file

Hi, I would like to change my CSV file by adding " and : and moving some of the information around. the CSV file looks as follows: 501254424;500440257;PE PACKS;300467279;PREP;;276476070;655031001867176;Two Block;Olga;25/12/2015 00:00:00;Olga I would like to move the field 7 to the front "...

8. Shell Programming and Scripting

Filter using awk in CSV files

Hello Gentlemen, Finding difficulties to play with my Input files:confused: . Your guidance will certainly help as always. After converting to csv file from XLSM file, I am getting some extra ""(double quote) characters which I want to terminate inside shell script and process it further. ...

9. UNIX for Beginners Questions & Answers

awk assistance - Comparing 2 csv files

Hello all, I have searched high and low for a solution to this, many have come really close but not quite what I'm after. I have 2 files. One contains GUID's, for example: 8121E002-96FE-4C9C-BC5A-6AFF20DACECD 84468F30-F3B7-418B-81F0-0908E80792BF A second file, contains a path to the...

10. UNIX for Beginners Questions & Answers

awk on csv files

wk on csv files Hi I have two csv files 1 ) keys.csv with data as below XX1,offsite XX2,offsite XX8,none XX3,offsite XX4,onsite XX7,none XX5,onsite XX6,onsite XX15,none 2) source.csv file with data like 1,0123,ppp,XX1 2,0122,sss,XX2 3,1239,yyy,XX8 4,567,kkk,XX5

LEARN ABOUT DEBIAN

weather::com::dayforecast

Weather::Com::DayForecast(3pm)				User Contributed Perl Documentation			    Weather::Com::DayForecast(3pm)

NAME

       Weather::Com::DayForecast - class representing a forecast for one day

SYNOPSIS

	 [...]

	 my @locations = $weather_finder->find('Heidelberg');

	 my $forecast = $locations[0]->forecast();
	 my $tomorrow = $forecast->day(1);

	 print "Forecast for tomorrow:
";
	 print " - tomorrow it's the ", $tomorrow->date()->date(), "
";
	 print " - sunrise will be at ", $tomorrow->sunrise()->time(), "
";
	 print " - maximum temperature will be ", $tomorrow->high(), "
";

DESCRIPTION

       Via Weather::Com::DayForecast objects one can access the weather forecast for one specific day.

       This class will not be updated automatically with each call to one of its methods. You need to call a method of your Weather::Com::Forecast
       object to get updated objects.

CONSTRUCTOR

       You usually would not construct an object of this class yourself.  This is implicitely done when you call the "day(number of day)" or the
       "all()" method of a Weather::Com::Forecast object.

METHODS

       date()

       Returns a Weather::Com::DateTime object containing the date the forecast is for.

       high()

       Returns the maximum temperature that will be reached at daytime.

       For day 0 (today), this will be 'N/A' when it's after noon...

       There is a bug in weather.com's date and time mathematics: If you are asking for a location's forecast day 0 and it's short after midnight,
       day 0 will be "yesterday" and you'll get both, yesterday's daytime forecast and night forecast!

       I have not investigated this issue further, yet. If anyone has, please inform me!

       low()

       Returns the minimum temperature that will be reached at night.

       sunrise()

       Returns a Weather::Com::DateTime object containing the time of sunrise.

       sunset()

       Returns a Weather::Com::DateTime object containing the time of sunset.

       day()

       Returns a Weather::Com::DayPart object with all data belonging to the daytime.

       For day 0 (today), this will be "undef" when it's after noon...

       There is a bug in weather.com's date and time mathematics: If you are asking for a location's forecast day 0 and it's short after midnight,
       day 0 will be "yesterday" and you'll get both, yesterday's daytime forecast and night forecast!

       I have not investigated this issue further, yet. If anyone has, please inform me!

       night()

       Returns a Weather::Com::DayPart object with all data belonging to the night.

AUTHOR

       Thomas Schnuecker, <thomas@schnuecker.de>

COPYRIGHT AND LICENSE

       Copyright (C) 2004-2007 by Thomas Schnuecker

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       The data provided by weather.com and made accessible by this OO interface can be used for free under special terms.  Please have a look at
       the application programming guide of weather.com (<http://www.weather.com/services/xmloap.html>)!

perl v5.8.8							    2007-07-09					    Weather::Com::DayForecast(3pm)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

csv files (with quoted commas) and awk

Discussion started by: Cranie

2. Shell Programming and Scripting

Need to modify csv-file with bash script

Discussion started by: Sebi0815

3. Shell Programming and Scripting

Merge 2 csv files with awk

Discussion started by: loloAix

4. Shell Programming and Scripting

Read data from .csv file through shell script & modify

Discussion started by: raj100