powershell - Merging CSV files -



powershell - Merging CSV files -

i trying merge number of csv files big csv file. wrote powershell script create individual csv files each tag names. when added get-content @ end, error:

get-content : object @ specified path c:\htd2csv\output_files\*.csv not exist, or has been filtered -include or -exclude parameter. @ c:\htd2csv\extract.ps1:30 char:20 + $temp = get-content <<<< "$destinationpath\*.csv" #| set-content $destinationpath\merged.csv + categoryinfo : objectnotfound: (system.string[]:string[]) [get-content], exception + fullyqualifiederrorid : itemnotfound,microsoft.powershell.commands.getcontentcommand

but have csv files in output_files folder. entering get-content .\output_files\*.csv worked fine on command line, apparently not in script. code looks this:

$currentpath = [system.io.path]::getdirectoryname($myinvocation.mycommand.definition) $sourcepath = "c:\program files (x86)\proficy\proficy ifix\htrdata" $destinationpath = "$currentpath\output_files" @( "ppp_ve0963a", "ppp_ve0963b", "ppp_ve0964a", "ppp_ve0964b", "ppp_ve0967a", "ppp_ve0967b", "ppp_ze0963a", "ppp_ze0963b", "ppp_ze0964a", "ppp_ze0964b" ) | foreach-object { .\htd2csv.exe ` ppp:$_.f_cv ` /dur:00:23:59:00 ` /int:00:01:00 ` /sd:05/01/14 ` /st:00:00:00 ` /sp:$sourcepath ` /dp:$destinationpath\$_.csv ` /dtf:0 ` /dbg:0 } get-content "$destinationpath\*.csv" | set-content "$destinationpath\merged.csv"

don't utilize get-content/set-content merging csvs (assuming have csvs , not peculiarly named flat text files). utilize import-csv , export-csv:

get-childitem '*.csv' | % { import-csv $_.fullname | export-csv 'c:\path\to\merged.csv' -notype -append }

or (to avoid appending):

get-childitem '*.csv' | % { import-csv $_.fullname } | export-csv 'c:\path\to\merged.csv' -notype

powershell csv

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more