Sponsored Content
Full Discussion: Modify csv-files with awk
Top Forums Shell Programming and Scripting Modify csv-files with awk Post 303021680 by elRonaldo on Tuesday 14th of August 2018 01:22:17 PM
Old 08-14-2018
Thank you RudiC. I'm going to try this tomorrow.
 

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

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

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 (6 Replies)
Discussion started by: loloAix
6 Replies

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

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

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

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

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

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 (2 Replies)
Discussion started by: zozoo
2 Replies
Jifty::DateTime(3pm)					User Contributed Perl Documentation				      Jifty::DateTime(3pm)

NAME
Jifty::DateTime - a DateTime subclass that knows about Jifty users SYNOPSIS
use Jifty::DateTime; # Get the current date and time my $dt = Jifty::DateTime->now; # Print out the pretty date (i.e., today, tomorrow, yesterday, or 2007-09-11) Jifty->web->out( $dt->friendly_date ); # Better date parsing my $dt_from_human = Jifty::DateTime->new_from_string("next Saturday"); DESCRIPTION
Jifty natively stores timestamps in the database in GMT. Dates are stored without timezone. This class loads and parses dates and sets them into the proper timezone. To use this DateTime class to it's fullest ability, you'll need to add a "time_zone" method to your application's user object class. This is the class returned by "user_object" in Jifty::CurrentUser. It must return a value valid for using as an argument to DateTime's "set_time_zone()" method. new ARGS See "new" in DateTime. If we get what appears to be a date, then we keep this in the floating datetime. Otherwise, set this object's timezone to the current user's time zone, if the current user's user object has a method called "time_zone". now ARGS See "now" in DateTime. If a time_zone argument is passed in, then this wrapper is effectively a no-op. OTHERWISE this will always set this object's timezone to the current user's timezone. Without this, DateTime's "now" will set the timezone to UTC always (by passing "time_zone => 'UTC'" to "Jifty::DateTime::new". We want Jifty::DateTime to always reflect the current user's timezone (unless otherwise requested, of course). from_epoch ARGS See "from_epoch" in DateTime and "now" in Jifty::DateTime. This handles the common mistake of "from_epoch($epoch)" as well. current_user [CURRENTUSER] When setting the current user, update the timezone appropriately. If an "undef" current user is passed, this method will find the correct current user and set the time zone. current_user_has_timezone Return timezone if the current user has one. This is determined by checking to see if the current user has a user object. If it has a user object, then it checks to see if that user object has a "time_zone" method and uses that to determine the value. set_current_user_timezone [DEFAULT_TZ] set_current_user_time_zone [DEFAULT_TZ] Set this Jifty::DateTime's timezone to the current user's timezone. If that's not available, then use the passed in DEFAULT_TZ (or GMT if not passed in). Returns the Jifty::DateTime object itself. If your subclass changes this method, please override "set_current_user_timezone" not "set_current_user_time_zone", since the latter is merely an alias for the former. new_from_string STRING[, ARGS] Take some user defined string like "tomorrow" and turn it into a "Jifty::Datetime" object. If a "time_zone" argument is passed in, that is used for the input time zone. If the string appears to be a _date_, the output time zone will be floating. Otherwise, the output time zone will be the current user's time zone. As of this writing, this uses Date::Manip along with some internal hacks to alter the way Date::Manip normally interprets week day names. This may change in the future. friendly_date Returns the date given by this "Jifty::DateTime" object. It will display "today" for today, "tomorrow" for tomorrow, or "yesterday" for yesterday. Any other date will be displayed in "ymd" format. We currently shift by "24 hours" to detect yesterday and tomorrow, rather than "1 day" because of daylight saving issues. "1 day" can result in invalid local time errors. is_date Returns whether or not this "Jifty::DateTime" object represents a date (without a specific time). Dates in Jifty are in the floating time zone and are set to midnight. get_tz_offset Returns the offset for a time zone. If there is no current user, or the current user's time zone is unset, then UTC will be used. The optional datetime argument lets you calculate an offset for some time other than "right now". jifty_serialize_format This returns a DateTime (or string) consistent with Jifty's date format. WHY
? There are other ways to do some of these things and some of the decisions here may seem arbitrary, particularly if you read the code. They are. These things are valuable to applications built by Best Practical Solutions, so it's here. If you disagree with the policy or need to do it differently, then you probably need to implement something yourself using a DateTime::Format::* class or your own code. Parts may be cleaned up and the API cleared up a bit more in the future. SEE ALSO
DateTime, DateTime::TimeZone, Jifty::CurrentUser LICENSE
Jifty is Copyright 2005-2010 Best Practical Solutions, LLC. Jifty is distributed under the same terms as Perl itself. perl v5.14.2 2011-01-24 Jifty::DateTime(3pm)
All times are GMT -4. The time now is 03:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy