Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need to modify csv-file with bash script
Top Forums Shell Programming and Scripting Need to modify csv-file with bash script Post 302394638 by Sebi0815 on Friday 12th of February 2010 06:29:42 AM
Old 02-12-2010
@Franklin52
I already saw that the fieldseparator was missing...

But, even if I use the fieldseparator, there's still the probleme which i tried to translate. It seems that there's a problem with the date syntax, or something like that.

BTW:
If I write this at the commandline

echo "1265911223 www.google.com"|awk '{str="date -d @"$1; print system(str)}'
this is the result
Code:
Do 11. Feb 19:00:23 CET 2010
0





@pludi

Hey pludi,

also an interesting way. But also in your example there's a problem modifying the date. If I try your code, the result is this

Code:
date: ungültiges Datum „@126364422;http://www.google.de/“

date: ungültiges Datum „@126364535;http://www.google.de/“

date: ungültiges Datum „@126364535;http://www.google.de/#hl=de&source=hp&q=unix+forum&btnG=Google-Suche&meta=&aq=f&oq=unix+forum&fp=749e75dee4f1c52f“

date: ungültiges Datum „@126364536;https://www.unix.com/“

date: ungültiges Datum „@126364538;https://www.unix.com/shell-programming-scripting/“

date: ungültiges Datum „@126364547;http://www.google.de/“

date: ungültiges Datum „@126364556;http://www.google.de/“

By the way. It seems that you know the firefox databases. Do you know where exactly the visit date is stored. I've searched a long time, but I didn't get the right answer. In my moz_places in places.sqlite is a value called last_visit_date. In your example, you used the visit_date from the moz_historyvisit table. Is there an difference between these two values? The problem is, that I didn't found any information about last_visit_date at all, but I found information about the value you used (visit_date in moz_historyvisit). If yours is the right one, I would prefer your way to extract the date and URL...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash Script: modify bash

Hey guys, i'm having trouble complete one of my bash scripts I'm hoping to --- 1. Modify bash so that then the user types "ls" the command that is executed is "ls -al" 2. Modify the point of entry in bash when the user accesses it, moving the initial location to /var I've somewhat done #2,... (9 Replies)
Discussion started by: LibRid
9 Replies

2. Shell Programming and Scripting

Bash script to reorder csv

hi guys, im fairly new to unix and bash scripts and therefore your help would really be appreciated. i need to write a bash script that will take a csv file, and reorder the data and output to another csv file. The source csv file will look something like this: HEAD,671061,Add,SS... (3 Replies)
Discussion started by: daz_20
3 Replies

3. 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... (3 Replies)
Discussion started by: raj100
3 Replies

4. 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... (5 Replies)
Discussion started by: Chinky23
5 Replies

5. Shell Programming and Scripting

Bash script help - removing certain rows from .csv file

Hello Everyone, I am trying to find a way to take a .csv file with 7 columns and a ton of rows (over 600,000) and remove the entire row if the cell in forth column is blank. Just to give you a little background on why I am doing this (just in case there is an easier way), I am pulling... (3 Replies)
Discussion started by: MrTuxor
3 Replies

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... (12 Replies)
Discussion started by: dbashyam
12 Replies

7. Shell Programming and Scripting

Csv download in a bash script

I am attempting to download a url in csv format. When I download this url in a browser excel opens up and automatically populates with comma separated values. When I try to use curl or wget I get nothing or garbage. This on the command line just hangs wget -b... (2 Replies)
Discussion started by: bash_in_my_head
2 Replies

8. 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 "... (13 Replies)
Discussion started by: omuhans123
13 Replies

9. Shell Programming and Scripting

Modify csv-files with awk

Hello everyone! I have thousands of csv files I have to import into a Database table. As usually the files aren't perfect. For example they have a different number of columns and some weird columns. The second problem is, that I have to add 3 parts of the filename into 3 rows in the... (6 Replies)
Discussion started by: elRonaldo
6 Replies

10. UNIX for Beginners Questions & Answers

Sed, awk or another bash command to modify string with the content of another file

Hello everybody, I would like modify some strings using sed or another command line with the content file. For example: - {fqdn: "server-01" , ip: "server-01"} - {fqdn: "server-02" , ip: "server-02"} - {fqdn: "server-03" , ip: "server-03"} - {fqdn: "server-04" , ip: "server-04"} My... (4 Replies)
Discussion started by: dco
4 Replies

LEARN ABOUT DEBIAN

finance::quotehist::google

Finance::QuoteHist::Google(3pm) 			User Contributed Perl Documentation			   Finance::QuoteHist::Google(3pm)

NAME

       Finance::QuoteHist::Google - Site-specific class for retrieving historical stock quotes.

SYNOPSIS

	 use Finance::QuoteHist::Google;
	 $q = Finance::QuoteHist::Google->new
	    (
	     symbols	=> [qw(IBM UPS AMZN)],
	     start_date => '01/01/1999',
	     end_date	=> 'today',
	    );

	 foreach $row ($q->quotes()) {
	   ($symbol, $date, $open, $high, $low, $close, $volume) = @$row;
	   ...
	 }

DESCRIPTION

       Finance::QuoteHist::Google is a subclass of Finance::QuoteHist::Generic, specifically tailored to read historical quotes from the Google
       web site (http://finance.google.com/).

       Google does not currently provide information on dividends or splits.

       Please see Finance::QuoteHist::Generic(3) for more details on usage and available methods. If you just want to get historical quotes and
       are not interested in the details of how it is done, check out Finance::QuoteHist(3).

METHODS

       The basic user interface consists of a single method, as shown in the example above. That method is:

       quotes()
	   Returns a list of rows (or a reference to an array containing those rows, if in scalar context). Each row contains the Symbol, Date,
	   Open, High, Low, Close, and Volume for that date. Quote values are pre-adjusted for this site.

REQUIRES

       Finance::QuoteHist::Generic

DISCLAIMER

       The data returned from these modules is in no way guaranteed, nor are the developers responsible in any way for how this data (or lack
       thereof) is used. The interface is based on URLs and page layouts that might change at any time. Even though these modules are designed to
       be adaptive under these circumstances, they will at some point probably be unable to retrieve data unless fixed or provided with new
       parameters.  Furthermore, the data from these web sites is usually not even guaranteed by the web sites themselves, and oftentimes is
       acquired elsewhere.

       Details for Googles's terms of use can be found here:

	 http://www.google.com/accounts/TOS?loc=us

       If you still have concerns, then use another site-specific historical quote instance, or none at all.

       Above all, play nice.

AUTHOR

       Matthew P. Sisk, <sisk@mojotoad.com>

COPYRIGHT

       Copyright (c) 2007-2010 Matthew P. Sisk. All rights reserved. All wrongs revenged. This program is free software; you can redistribute it
       and/or modify it under the same terms as Perl itself.

SEE ALSO

       Finance::QuoteHist::Generic(3), Finance::QuoteHist(3), perl(1).

perl v5.12.4							    2010-06-07					   Finance::QuoteHist::Google(3pm)
All times are GMT -4. The time now is 11:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy