However, to load this into a database I would like to reformat the dates (column 2) from the yyyymmdd format to the yyyy-mm-dd format. I have come up with the following:
But that leads to:
Can someone tell me how to correct this regex?
UPDATE: Also tried the following, which is also syntactically correct:
but that left the file unchanged.
Last edited by figaro; 08-21-2011 at 06:50 AM..
Reason: Updated with new code
i am trying to reformat a floppy i am using solaris 9 when i run this:
rmformat -F quick /vol/dev/aliases/floppy0
it tells me that it cannot perform the operation on a mounted device.
how do i unmount the device and format the floppy? (1 Reply)
Hi,
How can I reformat a file (text file) using unix command.
This file was FTP'd from Mainframe and contains some garbage character at the end of each line.
Each line contains special characters '<soh>' at the end which should have been spaces when I view it in emacs or nedit. I couldnt do find... (2 Replies)
Dear AWK Users,
I have a data set that is so large (Gigabytes) that it cannot be opened in the vi editor in its entirety. But I can manipulate the entire thing in AWK. It is formatted in a regular manner such that it has the variable descriptions or listings preceeding the variables. The latter... (13 Replies)
I have a command that gives me the output below:
JAVA_HOME = C:/jdk1.5.0_11
Broker Performance Report for server 'app1'
RMI_URL = rmis://
Parameter Kintana ItgDS DashboardDS
---------------------------- ------- ----- -----------
Connections count 41 ... (4 Replies)
I currently have the following file containing sample values for a number of dates:
Loc1 04 Jan 2007 0.95 0.9532
Loc1 05 Jan 2007 0.95 0.9513
Loc1 06 Jan 2007 0.95 0.9535
This continues for all months of the year and spans across several years.
I am trying to reformat the dates so that... (2 Replies)
I have been reformatting dates from a data file to make them mysql compliant.
31-10-2011 Loc1
1-11-2011 Loc2
The first can be captured by this:
sed -i '' -e "s#\(..\)-\(..\)-\(....\)#\3-\2-\1#" data.txt
and leads to:
2011-10-31 Loc1
The second line is captured as follows:
sed -i... (2 Replies)
Hi!
I have a list with a lot of records that I need to work with. The problem is that the list is populated successive one record at the time in a text file, and to gain anything from these records I need them to be put out in a table.
This is an example of what the list looks like:
(145)... (5 Replies)
Hi ,
I am trying to create a function with below requirements
1. It will take two parameters as Input. Date and Date format
2. Output will be in YYYYMMDD format.
Example 1:
Input: fn_date_reformatter('01-AUG-2014','DD-MON-YYYY')
Output: 20140801
Example 2:
Input:... (4 Replies)
Hi
i want to print line which is mentioned as below
615213:1;20150725;20250722;0|11;20150831;20150831;100|14;20150725;20160723;2
in below format.
'
615213: 1;20150725;20250722;0
615213: 11;20150831;20150831;100
615213: 14;20150725;20160723;2
please help me and suggest me how to... (9 Replies)
Hello UNIX experts,
I'm stumped finding a method to reformat a column. Input file is a two column tab-delimited file. Essentially, for every term that appears in column 2, I would like to summarize whether that term appears for every entry in column 1. In other words, make a header for each term... (2 Replies)
Discussion started by: torchij
2 Replies
LEARN ABOUT DEBIAN
locale::script
Locale::Script(3perl) Perl Programmers Reference Guide Locale::Script(3perl)NAME
Locale::Script - standard codes for script identification
SYNOPSIS
use Locale::Script;
$script = code2script('phnx'); # 'Phoenician'
$code = script2code('Phoenician'); # 'Phnx'
$code = script2code('Phoenician',
LOCALE_CODE_NUMERIC); # 115
@codes = all_script_codes();
@scripts = all_script_names();
DESCRIPTION
The "Locale::Script" module provides access to standards codes used for identifying scripts, such as those defined in ISO 15924.
Most of the routines take an optional additional argument which specifies the code set to use. If not specified, the default ISO 15924
four-letter codes will be used.
SUPPORTED CODE SETS
There are several different code sets you can use for identifying scripts. The ones currently supported are:
alpha
This is a set of four-letter (capitalized) codes from ISO 15924 such as 'Phnx' for Phoenician.
This code set is identified with the symbol "LOCALE_SCRIPT_ALPHA".
The Zxxx, Zyyy, and Zzzz codes are not used.
This is the default code set.
numeric
This is a set of three-digit numeric codes from ISO 15924 such as 115 for Phoenician.
This code set is identified with the symbol "LOCALE_SCRIPT_NUMERIC".
ROUTINES
code2script ( CODE [,CODESET] )
script2code ( NAME [,CODESET] )
script_code2code ( CODE ,CODESET ,CODESET2 )
all_script_codes ( [CODESET] )
all_script_names ( [CODESET] )
Locale::Script::rename_script ( CODE ,NEW_NAME [,CODESET] )
Locale::Script::add_script ( CODE ,NAME [,CODESET] )
Locale::Script::delete_script ( CODE [,CODESET] )
Locale::Script::add_script_alias ( NAME ,NEW_NAME )
Locale::Script::delete_script_alias ( NAME )
Locale::Script::rename_script_code ( CODE ,NEW_CODE [,CODESET] )
Locale::Script::add_script_code_alias ( CODE ,NEW_CODE [,CODESET] )
Locale::Script::delete_script_code_alias ( CODE [,CODESET] )
These routines are all documented in the Locale::Codes man page.
SEE ALSO
Locale::Codes
Locale::Constants
http://www.unicode.org/iso15924/
Home page for ISO 15924.
AUTHOR
See Locale::Codes for full author history.
Currently maintained by Sullivan Beck (sbeck@cpan.org).
COPYRIGHT
Copyright (c) 1997-2001 Canon Research Centre Europe (CRE).
Copyright (c) 2001-2010 Neil Bowers
Copyright (c) 2010-2011 Sullivan Beck
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2011-09-26 Locale::Script(3perl)