powershell - Re-format numerous dates (each different) in .txt file -


i have numerous .txt files output handle.exe run of several days. need reorganize data relational database. first thing need dates re-formatted.

each file has in excess of 800 dates, disbursed unevenly throughout file. dates formatted:

june 29, 2016 12:05:45 pm , need 06-29-16 12:05:45.

i'm working on single file now, things dialed in. i've tried replace dates in situ (using array original dates) get-date , got nowhere. tried -replace , didn't work.

i've spent 3 or 4 days on , think i've broken head. i've tried many permutations of stuff don't know anymore.

the last thing tried below. attempt use hashtable, old date , new date in table.

##to set "|" separator arrays $ofs = '|'  ##to original dates array $a = @(sls .\hp.txt -pattern '(june 29|june 30|july 1|july 2|july 3|july 4)' | select -expandproperty line)  ##to dates corrected format array $b = @($a | foreach {$_ | get-date -format "mm-dd-yy hh:mm:ss"})  ##to old , new dates hash table $dates = @{$a = $b}  ##to bring in content file $file = (get-content c:\hp.txt)  ##to replace "name" "value" hash table file foreach ($d in $dates) {   $file = $file -replace $d.name, $d.value }  ##to save corrected file new file name set-content -path c:\hpnew.txt -value $file

the $a array contains (in small part):

june 29, 2016 12:04:51 pm june 29, 2016 12:05:58 pm june 29, 2016 12:07:00 pm [note: lots more dates here] june 30, 2016 12:01:17 june 30, 2016 12:02:19 june 30, 2016 12:04:22 [note:continuing end]

the $b array contains:

06-29-16 12:04:51 06-29-16 12:05:58 06-29-16 12:07:00 [note: lots more dates ] 06-30-16 12:01:17 06-30-16 12:02:19 06-30-16 12:04:22 [note: continuing end]

there simpler, more elegant solution. help/direction great.

use regular expression extract date strings text, pass matches callback function parse them actual datetime values , format according requirements:

$re = '((?:january|february|...|december) \d{1,2}, \d{4} \d{1,2}:\d{2}:\d{2} [ap]m)'  $input_fmt  = 'mmmm d, yyyy h:mm:ss tt' $output_fmt = 'mm-dd-yy hh:mm:ss' $culture    = [globalization.cultureinfo]::invariantculture $options    = [text.regularexpressions.regexoptions]::ignorecase  $callback = {   [datetime]::parseexact($args[0].groups[1].value, $input_fmt, $culture).tostring($output_fmt) }  $txt = get-content '.\hp.txt' -raw [regex]::replace($txt, $re, $callback, $options) | set-content '.\hpnew.txt'

Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more