I have a file with some date columns in MM/DD/YYYY format:
SMPBR|DUP-DO NOT USE|NEW YORK||16105|BA5270715|6/6/2007 |MWERNER|109||||JOHN||SMITH|MD|72211118||||||74559|21 WILMINGTON RD||D|11/6/2003|SL# MD CONTACT-LIZ RICHARDS|||0|Y|N||1411458|
And I want to convert the date format to:
... (5 Replies)
In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY.
Thanks. (8 Replies)
Hello,
I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10)
To extract the dates, I am using shell substrings, i.e.:
read line
... (4 Replies)
Hi all,
i had a code where in user will enter a date in yyyymmdd format.. i didnt use any validation for the date and now the problem is if a user enters date instead of month after year it is proceeding with the code..
like if the date is 20120426 and if the user enters 20122604 it... (4 Replies)
Hi I have a problem with Date format in my code.
1st I am trying to convert today's date to yesterday's using
YESTERDAY3=`perl -e '@y=localtime(time()-86400); printf "%04d/%02d/%02d",$y+1900,$y+1,$y;$y;'`
And once it is done I am trying to using the yesterday date in a grep command to... (3 Replies)
Hi All,
I have line
,A,FDRM0002,12/21/2017,,0.961751583,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
it contains date in mm/dd/yyyy format i want to change this to yyyymmdd format using perl.
Use code tags, thanks. (8 Replies)
Hi All
I need help in converting a string of YYYYMMDD format to date in Sun OS and then find out if the day is a Wednesday or not. The "date -d" option is not working and your help is much appreciated.
The date command usage from the operating system we use here is as follows:
usage: ... (1 Reply)
Hi All
I need help in converting a string of YYYYMMDD format to date in Sun OS and then find out if the day is a Wednesday or not. The "date -d" option is not working and your help is much appreciated.
The date command usage from the operating system we use here is as follows:
Thanks,
SK (11 Replies)
Discussion started by: SK123
11 Replies
LEARN ABOUT DEBIAN
geoip
geoip(3) Version 0.2 geoip(3)NAME
geoip - A Tcl extension for geographic or organisational lookup of IP addresses and hostnames.
SYNOPSIS
geoip open [-type TYPE ] [-flags FLAG ]
geoip open [-file PATH ] [-flags FLAG ]
geoip [COMMAND]
geoip [QUERY] arg1
DESCRIPTION
This Tcl extension encapsulates most of GeoIP C API functions into tcl commands.
OPEN OPTIONS
open takes either a file path and a set of flags, or a type and a set of flags. Supported types and flags are described below.
TYPE Looks under the standard installation share directory, eg /usr/local/share/GeoIP/ for a GeoIP database according to type.
PATH Absolute/relative path to GeoIP database.
FLAG Flags seperated by ':', eg memory_cache:memory_check
COMMAND
Individual singular commands can be one of:
close Close the currently open database.
db_info
Get information about the current database.
db_edition
Returns edition of opened database.
db_avail
Test the availability of databases in your system in known locations. e.g db_avail country_edition
QUERY
Commands that query the database. All commands return N/A if a result cannot be found. If none already open, a command will attempt to open
a suitable database. country commands will open a country_edition database. region commands will open a region_edition_rev1 one. name com-
mands will open an org_edition one, and the record_edition will open a city_edition_rev1 database. The commands are:
country_code_by_addr
Takes an IP address and returns the ISO-3166-1 Alpha-2 code of the country.
country_code3_by_addr
Takes an IP address and returns the ISO-3166-1 Alpha-3 code the country.
country_code_by_name
Takes a hostname and returns the ISO-3166-1 Alpha-2 code the country.
country_code3_by_name
Takes a hostname and returns the ISO-3166-1 Alpha-3 code the country.
country_name_by_addr
Takes an IP address and returns the country name.
country_name_by_name
Takes a hostname and returns the country name.
name_by_addr
Takes an IP address and returns the organisation name (or ISP/ASnum according to the opened database)
name_by_name
Takes a hostname and returns the organisation name.
region_by_addr
Takes an IP address and returns these region attributes as in an associative array: country, region
region_by_name
Takes a hostname and returns the region attributes.
record_by_addr
Takes an IP address and returns these record attributes as in an associative array: code, code3, region, country, city, postcode,
latitude, longitude, dma(dma code), and area (area code)
record_by_name
Takes a hostname and returns the record attributes.
TYPES
Relevant types of databases are: country_edition, org_edition, isp_edition, city_edition_rev1, region_edition_rev1, geoip_asnum_edition.
"open -type" will accept their unambiguous abbreviations.
FLAGS
Valid flags are: standard, memory_cache, check_cache, index_cache.
FILES
./share/GeoIP.dat
GeoIP country_edition database.
./share/GeoIPOrg.dat
GeoIP org_edition database.
./share/GeoIPCity.dat
GeoIP region_city_rev1 database.
./share/GeoIPRegion.dat
GeoIP region_edition_rev1 database.
./share/GeoIPASNum.dat
GeoIP asnum_edition database.
BUGS
Please report to author.
AUTHOR
Djihed Afifi <djihed@gmail.com>.
SEE ALSO
GeoIP C API documentation <www.maxmind.com>
Tcl extension April 2007 geoip(3)