CSV- add empty columns

-

hello

i have csv 1500 record

"cognome","numero 1","numero 2"

and need add empty columns

[empty col.][empty col.][empty col.][empty col.][cognome][empty col.]...[numero 1][empty col.][empty col.]...[numero 2][empty col.][empty col.]...

total 60 columns



just copy , paste ps console window, or ise:

$newheader = "azienda","titolo","nome","cognome","indirizzo","cap","citta","stato","email","url","note","nome 1","numero 1","numero breve 1","deviazione 1","note 1","nome 2","numero 2","numero breve 2","deviazione 2","note 2","nome 3","numero 3","numero breve 3","deviazione 3","note 3","nome 4","numero 4","numero breve 4","deviazione 4","note 4","nome 5","numero 5","numero breve 5","deviazione 5","note 5","nome 6","numero 6","numero breve 6","deviazione 6","note 6","nome 7","numero 7","numero breve 7","deviazione 7","note 7","nome 8","numero 8","numero breve 8","deviazione 8","note 8","nome 9","numero 9","numero breve 9","deviazione 9","note 9","nome 10","numero 10","numero breve 10","deviazione 10","note 10"  import-csv $inputfile | foreach {  $_ | select $newheader } | export-csv $outputfile

you'll need set $inputfile , $outputfile variables paths of old , new csv files.

[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "



Windows Server  >  Windows PowerShell



Comments

Post a Comment

Popular posts from this blog

Edit Group Policy

-
i have pc has power settings pushed out default domain policy in ad environment. of course on local machine "some settings managed system adminstrator". the machine temporarily no longer in contact domain controller (it's been physically moved , not on same network now) can't updated gpo settings. i believe if edit local group policy won't make difference because of group policy processing , precedence. since it's temporary away ad network, still want use settings of ad user. is there somewhere in registry stored can edit power plan manually until can sync domain? (i need prevent sleeping while plugged in - it's set 1 hour) thanks! allen crist i found site: http://gpsearch.azurewebsites.net/#7916 i able add policy to hkey_local_machine\software\policies\microsoft\power using specs found on site. looks solved issue. i'll report if didn't. thanks! allen crist ...
Read more

Hyper-V VM not reaching OS 'Logon' screen

-
i trying migrate vm vmware hyper-v. so far have done following (seemingly successfully): prepare vmware vm conversion hyper-v format (vhd) within vmware workstation 8.0 environment following steps guide: http://social.technet.microsoft.com/forums/en/winserverhyperv/thread/ef8c12f7-c45d-442e-9a30-c43cd87df3b3   (i.e. remove vm tools, add new ide hard disk…) use vmdk2vhd application convert individual vmdk files vhd ones create new vm in hyper-v exporting in 3 newly converted vhd files at point have checked settings , powered on vm in hyper-v find although windows begins load expected manages reach screen prior login screen saying either of following messages: “windows starting up…” “the active directory rebuilding indices… please wait” to knowledge, albeit limited in area, vm should present me login screen since appears in vmware. if start vm in safe mode can login not desired affect. below details of vm: operating system: windows server 2003 (enterprise edit...
Read more

DNS question...

-
i new setting dns server....my domain name expl. "domain.com"....i set "a" record in forward lookup for  www.domain.com itself...."server's local ip"....i've added no other zones , i seem able resolve names except own....www.domain.com.....also, do i put my isp's dns ip's....for external dns's server can't resolve?....forwarding or in nic setup?......i want setup in my dns server don't have include them on client side..... thanks mark     not put isp dsn server address in settings on nic dc or clients. should point local dns server on dc. set dns forward public dns, such isp. bill Windows Server  >  Network Infrastructure Servers
Read more