I went back and read your first post and the example you posted could be a problem if it is not an exact representation of your csv file.
Code:
,750,0000000000000000GCJR, ,06/22/2016 14:48:44
Could you confirm that lines in your file contains ONLY lines EXACTLY like this?
If this is not the case, could you post a complete portion of your file, showing real complete lines.
Hi All,
this is my second post, last post reply was very helpful.
I have a data that has date in DD/MM/YYYY (07/11/2008) format i want to replace the backslash by a dot(.) so that my awk script can read it inside the C shell script that i have written.
i want to change 07/11/2008 to... (3 Replies)
So I have a csv file where the 3rd field is a date string in the format yyyy-mm-dd. I need to change it to mm/dd/yyyy. So each line in the csv file looks like:
StringData,StringData,2009-02-17,12.345,StringData
StringData,StringData,2009-02-16,65.789,StringData
Any idea how I can keep... (5 Replies)
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
I have a CSV file with a date format like this;
11/19/2012 17:37:00,1.372,121.6
11/19/2012 17:38:00,0.743,121.6
Want to change the time stamp to seconds after 1970 so I can get the data in rrdtool. For anyone interested, this is data from a TED5000 unit and is Kwatts and volts.
Needs to... (3 Replies)
Hi Unix Gurus,
I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Hi, I am extracting a date string from the source file like this :
06/05/2014 16:04:00
I want to change it to 05-JUN-14 04.05.00.000000000 PM
I basically store the date in a variable. I got solutions to change date in dd-mmm-yyyy format using tr but I guess it works only with the "date"... (8 Replies)
Hi,
I need help to convert the date format in .DAT file in unix.
I want to convert
10@@|SWIFT MT568 Extract@@|Apr 14 2014 5:47:52:563PM@@|Apr 14 2014 4:33:47:663PM@@||##|
into
10@@|SWIFT MT568 Extract@@|04/14/2014/ 5:47:52:563PM@@|04/14/2014 4:33:47:663PM@@||##|
Appreciate... (18 Replies)
I have a csv file formatted like this:
2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07and I'm trying to change it to MM/DD/YYYY HH:MM for both occurances.
I have got this:
awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csvThis... (6 Replies)
Hi,
We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places
But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script.
Please let us know how can we achieve the same. (16 Replies)
Discussion started by: dholea
16 Replies
LEARN ABOUT DEBIAN
viewperl
VIEWPERL(1) User Commands VIEWPERL(1)NAME
viewperl - quickly view syntax highlighted Perl code
SYNOPSIS
viewperl [OPTION]... FILE...
DESCRIPTION
View a Perl source code file, syntax highlighted.
-c, --code=CODE
view CODE, syntax highlighted
-l, --lines
display line numbers
-L, --no-lines
supress display of line numbers (default)
-m, --module=FILE
consider FILE the name of a module, not a file name
-n, --name
display the name of each file (default)
-N, --no-name
supress display of file names (implied by --no-reset)
-p, --pod
display inline POD documentation (default)
-P, --no-pod
hide POD documentation (line numbers still increment)
-r, --reset
reset formatting and line numbers each file (default)
-R, --no-reset
supress resetting of formatting and line numbers
-s, --shift=WIDTH
set tab width (default is 4)
-t, --tabs
translate tabs into spaces (default)
-T, --no-tabs
supress translating of tabs into spaces
--help display this help and exit
Note that module names should be given as they would appear after a Perl `use' or `require' statement. `Getopt::Long', for example.
Each string given using -c is considered a different file, so line number and formatting resets will apply.
View a Perl source code file, syntax highlighted.
-c, --code=CODE
view CODE, syntax highlighted
-l, --lines
display line numbers
-L, --no-lines
supress display of line numbers (default)
-m, --module=FILE
consider FILE the name of a module, not a file name
-n, --name
display the name of each file (default)
-N, --no-name
supress display of file names (implied by --no-reset)
-p, --pod
display inline POD documentation (default)
-P, --no-pod
hide POD documentation (line numbers still increment)
-r, --reset
reset formatting and line numbers each file (default)
-R, --no-reset
supress resetting of formatting and line numbers
-s, --shift=WIDTH
set tab width (default is 4)
-t, --tabs
translate tabs into spaces (default)
-T, --no-tabs
supress translating of tabs into spaces
--help display this help and exit
Note that module names should be given as they would appear after a Perl `use' or `require' statement. `Getopt::Long', for example.
Each string given using -c is considered a different file, so line number and formatting resets will apply.
viewperl August 2007 VIEWPERL(1)