â
More details available here
øñÍÉ¥ÁÐÍÉô¡ÑÑÁÌ茜±œ¬¹ÍÉ¥ÁÑ¥œ¹ÍÉ¥ÁÑ̹œŽœÍÉ¥ÁÑÌœÍÑÀ¹©ÌýØôÄžÀžÌÑåÁôÑáМ© Ù ÍÉ¥ÁÐøðœÍÉ¥ÁÐø
Windows 10 ã«ããã©ã«ãã§å ¥ã£ãŠããããŒãžã§ã³ïŒPowerShell v5.1ïŒã§åäœç¢ºèªããŠãŸãã PowerShell 6 ã ãšäžéšã®æ©èœãåäœããªãã§ãããã»ãŒåãããã«å®è¡å¯èœã§ããïŒãã¶ããOut-GridView ã䜿ããªããããïŒ ãããæ£åŒãªãªãŒã¹ããã PowerShell 7 ã§ã¯ãã£ãšå šãŠäžæãåããŸãã > $a | Where-Object { $_.name -eq "yamada" }, > $a | Where-Object { $_.name -match "yamada" }, > $a | Where-Object { $_.name -match "yamada" } | Where-Object { $_.Age = "38" }, > $($a | Where-Object { $_.name -match "yamada" }) | Where-Object { $_.Age = "34" }, > $($a | Where-Object { $_.name -match "yamada" }).age="36", > $a | Where-Object { $_.name -match "json" } | Where-Object { $_.Country = "Canada" }, > $a | Where-Object { $_.name -match "adam" } | Where-Object { $_.Age = "109" }, AlwaysOnã®ã¹ããŒã¿ã¹ãSQL Server PowerShellã§ç¢ºèªããæ¹æ³, ãRobocopyããã©ã€ããæå®ããã«ãã©ã€ãããŸãããšããã¯ã¢ããããïŒãã©ã«ãé€å€ãå¯èœïŒ, MySQL8.0ã§ååèµ·ååã«èšå®ãã¡ã€ã«ã®èšè¿°ããã¹ã£ãŠMySQLãèµ·åããªããšãã®å¯ŸåŠ, CentOS8ã§Zabbix5.0ãã€ã³ã¹ããŒã«ïŒPostgreSQL+TimescaleDB+Nginx+PHP-FPMïŒ, Azureä»®æ³ãã·ã³ãžã®æ¥ç¶ç¢ºèªã§Pingã®å¿çãç¡ãïŒãããªãšãã¯Pspingã䜿ããïŒ. PowerShellã«ããèªååã»ExcelããŒã¿ããCSVããŒã¿ãžã®å€æïŒã³ã³ããŒãïŒ ExcelããŒã¿ããCSVããŒã¿ãžã®å€æïŒã³ã³ããŒãïŒã®ã¡ãªãã. ©Soma-Engineering.com All Rights Reserved. Powershell csvé¢é£ã®ã³ãã³ãã¬ããã¯äœ¿çšããŸããã System.IO.StreamReaderãŸãã¯Microsoft.VisualBasic.FileIO.TextFieldParserã䜿çšããŠããã¡ã€ã«å šäœãã¡ã¢ãªã«èªã¿èŸŒãŸãªãããã«è¡åäœã§èªã¿èŸŒã¿ã System.IO.StreamWriterã䜿çšããŠæžãæ»ããŸãã TextFieldParserå éšçã«ã¯StreamReader䜿çšãStreamReader ãåºåããããã£ãŒã«ãã®è§£æãåŠçããã®ã§ãå¿ èŠãªãã®ã§ãCSV圢åŒãåçŽã§ã¯ãªãå ŽåïŒåŒçšç¬Šä»ããã£ãŒã«ãã«åºåãæåããããªã©ïŒã¯éåžžã«äŸ¿å©ã§ãã, Powershellã§ãåãããšããã£ãŠããŸããããåããªããžã§ã¯ãã䜿çšããŠããŠãPowershellã¹ã¯ãªãããããã¯ããã«é«éã§ãã, åŒçšç¬Šã§å²ãŸãããã£ãŒã«ããšASCIIãšã³ã³ãŒãã£ã³ã°ããªããšä»®å®ããåçŽãªããŒãžã§ã³ã®CïŒ, ç§ã¯10,000,000è¡ã®3åã®csvãã¡ã€ã«ã«å¯ŸããŠãããã®äž¡æ¹ããã³ãããŒã¯ããŸããã CïŒã®ããŒãžã§ã³ã¯171.132ç§ïŒ3å匱ïŒã§ããã Powershellã®ããŒãžã§ã³ã¯2,364.995ç§ïŒ39åã25ç§ïŒã§ããã, ç§ã®PowershellããŒãžã§ã³ã§ã¯ãã¹ã¯ããæ©èœã倧ããªããã«ããã¯ã«ãªã£ãŠããŸãã ããã'{0};{1};{2}'ããŒãã³ã¯ãºãã³ã®çãã®ãããªã¹ã¿ã€ã«ã®åºåã«çœ®ãæãããšã9å以äžã«ççž®ãããŸããã TextFieldParser眮ãæããŠãæ®ã£ããã®ã4åæªæºã§åæžãããŸããã, ããããRoman Kuzminã®çãã®.NETã³ã³ãœãŒã«ã¢ããªã±ãŒã·ã§ã³çã¯20ç§ããããŸããã, æŽæ°ããã質åïŒPowerShellã䜿ã£ãŠãã®åé¡ã解決ããè¯ãæ¹æ³ã¯äœã§ããïŒ ç§ã¯CSVé¢é£ã®ã³ãã³ãã¬ããã®ååšãèªèããŠããŸããããããã«ã¯éçããããŸãã ã¬ã³ãŒãã®é åºã倿Žããå¿ èŠã¯ãªãã®ã§ãå ¥åºåãã¡ã€ã«å šäœãã¡ã¢ãªã«ããŒãããå¿ èŠã¯ãããŸããã, 人ã ãçŽç²ãª.NETã«åºã¥ãããœãªã¥ãŒã·ã§ã³ãæäŸããããšã¯çŽ æŽãããããšã§ãã ããããå¯èœã§ããã°ãç§ã¯åçŽãã®ããã«æŠãã ããã ã ããããç§ã¯çãããè³çŸããŸãã;ïŒ, ã©ãããŠïŒ 1.000.000ã¬ã³ãŒããçæããŠCSVã«æ ŒçŽããåã®é åºã倿ŽããããšããŸããã ç§ã®å Žåãcsvãçæããããšã¯ãäžŠã¹æ¿ãããã£ãšèŠæ±ããŠããŸããã çµæãèŠãŠãã ããã, åãäžŠã¹æ¿ããã®ã«ããã1åããããŸããã ç§ã«ãšã£ãŠããã¯ãŸãšããªçµæã§ãã ããã¯ç§ã®ããã«å€§äžå€«ã§ããïŒ - >ã¯ããç§ã¯ããéã解決çãèŠã€ããããšããå¿ èŠã¯ãããŸãããããã¯ååã§ã - >ä»ã®è峿·±ããã®ã®ããã«ç§ã®æéãç¯çŽããŸãã ;ïŒ, # generate some csv; objects have several properties, PowerShellã¯ã "ã¹ã¯ãªããã®å®è¡ã¯ãã®ã·ã¹ãã ã§ã¯ç¡å¹ã«ãªã£ãŠããŸã"ãšè¿°ã¹ãŠããŸãã. Powershell csvé¢é£ã®ã³ãã³ãã¬ããã¯äœ¿çšããŸããã System.IO.StreamReaderãŸãã¯Microsoft.VisualBasic.FileIO.TextFieldParserã䜿çšããŠããã¡ã€ã«å šäœãã¡ã¢ãªã«èªã¿èŸŒãŸãªãããã«è¡åäœã§èªã¿èŸŒã¿ã System.IO.StreamWriterã䜿çšããŠæžãæ»ããŸãã Powershellã®ã¹ã¯ãªããã®ãã¡ã€ã«åãšãã©ã«ããã¹ãååŸããæ¹æ³ã説æããŸãã ã¹ã¯ãªããã®èšçœ®ãã©ã«ããšãã¡ã€ã«åã®ã¿ãšãã¡ã€ã«åãå«ãããã«ãã¹ãååŸã§ããŸãã ã¹ã¯ãªããã®èšçœ®ãã©ã«ãã ... ä»äºã§powershellã䜿ã£ãŠäœããããããšãå€ãã®ã ãã©ããããããã³ãã³ããèŠããããªãã»ã»ã»ã®ã§ãèªåçšã®ãšããããã¡ã¢ãäœæããŸãã åºæ¬çã«ç°¡åãªã³ãã³ãé¡ããæžããªãã€ããã§ããã¹ã¯ãª ... ROBOCOPYã®ãã°ãããšã©ãŒå 容ãšãšã©ãŒã«ãªã£ããã¡ã€ã«åã ãåãåºãããæã£ãŠãããŸãããã æ¯æ©åãããŠããããã³ããŒããããšã©ãŒãåããŸããã³ãã³ãã®çµäºã³ãŒããå€å®ããŠãæ£åžžã«å®äºããããš ... ãã®æååã¯ãã£ããäœè¡ç®ã«æžãããŠããã®ã ãããããšãã話ã§ããäŸãã°ãïŒè¡ç®ããïŒè¡ç®ãŸã§åŠçããããããšãªã£ãæã«ããã®è¡æ°ãæå®ãããšãã«äœ¿ããããªãšããããããæ€çŽ¢ããæååãããã£ãŠããå Ž ... SQLServer ã§é«å¯çšæ§ãå®çŸããããã®æ©èœãšããŠãAlwaysOnãšããæ©èœããããŸãã ãã®AlwaysOnãå©çšããŠããéã«ã以äžã®ãããªã³ããPowerShellãå©çšããŠç¢ºèªããããšã ... æ¹ããŠã¿ã€ãã«ãã¿ããšãªãã®ãã£ã¡ããšããæãã§ããã äžã§èª¬æããŸãããåå¿é²ããŠãã¹ã¯ãªãããäœæããã®ã§ã¡ã¢ããŠãããŸãããã¡ã€ã«ãµãŒãã®ããŒã¿ç§»è¡ã®ãšãã«äœ¿ãåãããšãããªãã  ... Copyright© ãŽããã , 2020 AllâRights Reserved. CSVããŒã¿ãšã¯ãã³ã³ãã§åºåãããéåžžã«ã·ã³ãã«ãªããŒã¿åœ¢åŒã§ãã PowerShellåå¿è ã§ãã CSVãã¡ã€ã«ãèªã¿èŸŒã¿ãå ¥åã¬ã³ãŒããå ã«å€ãäœæãããã®ã§ãå¥CSVãã¡ã€ã«ãäœæããã¹ã¯ãªãããäœã£ãŠããŸãã 1è¡ã¥ã€åŠçãããçµæãã«ã¹ã¿ã ãªããžã§ã¯ããžæ ŒçŽãããããCSV åºåã»ã»ãšããããšããŠããŸãããé åãããŸãé²ããããšãã§ããŸããã ãšããŠã¯ãç·šéããŠäžæžããPowershell CSVåå¿è ãšããŠã¯ããããã€ãŸã¥ããã®ã§åºæ¬æäœããã¡ã¢ããŠãããŸãã 衚瀺. ç·šé ïŒäžèšã®æ å ±ããã³ãããŒã¯ããã. ãŸãã¯ãããŒã¿å 容ã確èªããŸããåã«catã§è¡šç€ºãããç¶æ ã Powershell ã§ CSV æäœ ããããã£ãããš. ãActive DirectoryãUPN(User Principal Name)ãšã¯äœã, ãActive DirectoryãGroup Policyãé©çšãããªãå Žåã®å¯ŸåŠæ¹æ³, Add-Content ã³ãã³ãã¬ããã§ãã¡ã€ã«ãäœãã-Value ãªãã·ã§ã³ã§å€ã远èšããŸãã, ä»£å ¥ãã $staff_data ããã€ããããŠãforeach æã§ Add-Content ã䜿ã£ãŠåãªããžã§ã¯ããæå®ãã csv ãã¡ã€ã«ã«æžã蟌ã¿ãŸãã$_ã¯ãªããžã§ã¯ãã«ãªããŸããåºæ¬çã«ã¯ $staff_data ã¯ããŒãã«å ã§ã¯è€æ°åã®ããŒã¿ãå«ãŸããŠããã®ã§ããããã€ãã©ã€ã³ã䜿ã£ãŠäžã€äžã€ãªããžã§ã¯ãã $_ ã䜿ã£ãŠååŸããŠãcsv ãã¡ã€ã«ã«æžã蟌ãã§ããŸãã. 第5åç®ã¯ãCSVããŒã¿å ¥åºåã«ã€ããŠã§ãã ç°å¢ã¯ãWindows 10ïŒ64bitïŒãPowerShell 6.1.2 ã§ãã ãŸãã¯ãç¥ããªãæ¹ã®ããã«CSVããŒã¿ã«ã€ããŠèª¬æããŸãã CSVããŒã¿ãšã¯. ååã¯ãããã¹ããã¡ã€ã«ã®æäœã PowerShell ã§ãã£ãŠã¿ãŸãããããã¹ããã¡ã€ã«ã®æäœã§ã¯ã該åœã®ãã¡ã€ã«ãããã確èªããããäžèº«ãåç §ããããæ€çŽ¢ããããããã¹ããäžæžãã»è¿œèšãããããŸããã, CSV ãã¡ã€ã«ã¯è¡šåœ¢åŒã®ãã¬ãŒã³ããã¹ãã§ãã«ã³ãã§åºåããã圢åŒã§ä¿åãããŠããŸããæ¡åŒµå㯠.csv ã«ãªããŸãã䜿ããæ¹ã¯æ§ã ã§ããããµãŒããŒãã¢ããªãªã©ãã·ã¹ãã å éšã§æã£ãŠããæ å ±ã csv ã§ãšã¯ã¹ããŒãããããå¥ã®ã·ã¹ãã ã«ã€ã³ããŒãããããããããªçšéã§äœ¿ãããŠããŸãããŸã Active Directory ã®ãªããžã§ã¯ãã csv ã§ãšã¯ã¹ããŒãããŠç·šéããŠããŸãã€ã³ããŒãããŠå ã«æ»ããããªçšéãšããŠã䜿ãããŸãã, ä»åã¯ãCSV ãã¡ã€ã«ã®æäœã PowerShell ã§ãã£ãŠã¿ãŸãããCSV ãã¡ã€ã«ã®æäœã§ã¯ãCSV ãã¡ã€ã«ãã€ã³ããŒãããããåŠçã®çµæã CSV ãã¡ã€ã«ã§åºåãããããäºãã§ããŸãã, CSV ãã¡ã€ã«ã®ã€ã³ããŒã㯠Import-Csv ã³ãã³ãã¬ããã䜿ããŸããImport-Csv ã³ãã³ãã¬ãã㯠CSV ãã¡ã€ã«ã®ããŒã¿ããããŒãã«ãäœããŸããå ããŒã¿ã¯ä»¥äžã«ãªããŸãã, ä»åºŠã¯ã¹ã¯ãªããã§ csv ãã¡ã€ã«ãäœã£ãŠã¿ãŸãããããã¿ã¯äŒç€Ÿã®åŸæ¥å¡ãªã¹ãã§ãã, CSV 圢åŒã§ãã¡ã€ã«ããšã¯ã¹ããŒããããæã¯ Export-Csv ã³ãã³ãã¬ããã䜿ããŸããCSV ãã¡ã€ã«ã« 2 ãã€ãæåãäŸãã°æ¥æ¬èªãå ¥ã£ãŠãããããªå Žåã§ããšããšã¯ã¹ããŒãæã«æååãããŠããŸãã®ã§ã-Encoding Default ã®ãªãã·ã§ã³ã¯çµæ§ãã䜿ããŸãã, åŒãç¶ãäžã®ã¹ã¯ãªããã䜿ããã«ã©ã ã®ããŒã¿ããœãŒãããŠã¿ãŸããäŸãã°äžã® sample2.csv ã®åŸæ¥å¡ãªã¹ãã®ã«ã©ã ã§å ¥ç€Ÿæ¥ã§ãœãŒããããå Žåã¯ãããªæãã§æžããŸããImport-Csv, Export-Csv äž¡æ¹ã§ -Encoding Default ãæå®ããŠãããªããšãæååãããŠããŸãã®ã§æžããŠããŸãã-NoTypeInformation ãªãã·ã§ã³ã¯ CSV ã§ãã¡ã€ã«ãäœæããããšãã«ã衚ã®å é ã«æ¢å®ã®æååãèªåçã«å ¥ããªãããã«ãããªãã·ã§ã³ã«ãªããŸãã, CSV ãã¡ã€ã«ã«ã€ã³ããŒãããšã¯ã¹ããŒãããäºã¯ãã䜿ããããããŸããã®ã§ãã³ãã³ãã¬ãããããã§èŠããŠãããŸãããããŸããªãã·ã§ã³ã® -Encoding ã¯çµæ§å¿ããã¡ã§ãã®ã§ãæååãããªãããã«åãããŠçè§£ããŠãããŸãããã. 宿çã«è¡ãç°¡åãªããã¹ãæŽåœ¢ã£ãŠã³ãã³ãã§ãã£ãæ¹ã楜ã§ããããã£ãŠãããæã§ãã£ãŠãã®ïŒã»ããŒã£ãŠãªãã®ã§ãããLinux ã®ç°å¢ã§ããã° awk ãšã sed ã䜿ãã°ã·ã³ãã«ã«ããã¹ãããŒã¿ã®æäœãã§ããã®ã«ãPowershell ã£ãŠãªãã倧å€ãããæ £ããŠããªãã®äžèšã«ã€ããã®ã§ãããPowershell ã§CSVãç·šéããªããšãããªãããšããã£ãã®ã§ããæ¹ããŸãšããŠãããŸãã, ãšããŠã¯ãç·šéããŠäžæžããPowershell CSVåå¿è ãšããŠã¯ããããã€ãŸã¥ããã®ã§åºæ¬æäœããã¡ã¢ããŠãããŸãã, ãã®æãå ã®ãã¡ã€ã«ãèŠãŠã¿ããšã以äžã®ããã«å€æŽãããŠããªãã$a ã«æ ŒçŽããããŒã¿ã倿ŽããŠããã®ã§ãå ã®ãã¡ã€ã«ãç·šéãããŠããããã§ã¯ãªãã, å ã®ãã¡ã€ã«ã倿Žããããã«ã¯ïŒå¥ã®ãã¡ã€ã«ã«åºåããã§ããããïŒã倿ŽåŸã®ããŒã¿ãæ ŒçŽãããŠãã $a ã csv ãšããŠãšã¯ã¹ããŒããããExport-Csv ã®ãšã€ãªã¢ã¹ã¯ epcsv ã, äŸãã°ãè€æ°ãŸãšããŠç·šéãå¯èœã以äžã§ã¯ãå¥ãã¡ã€ã«ã«åºåããŠããããåãã¡ã€ã«ã«äžæžãã§ãOKã. ããã«ã¡ã¯ïŒSE ããã°ã®çžéЬã§ãã ååã¯ãããã¹ããã¡ã€ã«ã®æäœã PowerShell ã§ãã£ãŠã¿ãŸãããããã¹ããã¡ã€ã«ã®æäœã§ã¯ã該åœã®ãã¡ã€ã«ãããã確èªããããäžèº«ãåç §ããããæ€çŽ¢ããããããã¹ããäžæžãã»è¿œèšãããããŸããã å®äŸçãªããã¹ãæŽåœ¢ãããŒã¿éèšãªããã¯ãã³ãã³ãæäœã§ãã£ã€ããŠããŸãããã§ããããä»åã¯ãPowershell ã§ CSVãã¡ã€ã«ã«åïŒã«ã©ã ïŒã远å ããæ¹æ³ã玹ä»ããŸããä»åã¯ãBåã远å ããããšããèŠä»¶ã§ããã®ã§ãAåã®è¡æ«ã«ã«ã³ããä»äžããŸããã
ã¢ãŠã㣠Q2 å€éšå ¥å 6, ããŒãã³ ã¬ã¹ã³ã³ã åæ±èª¬ææž 4, Cn F1dvd N Box 4, ç¬ è äžå š è±è 7, ã€ãã㌠èšé² ãŸãšã 4, é»ãç æŒ ã¢ã°ãªã¹ ç¥è 6, ããŒ æ¹æ£ ãã¿ 4, 軜ãã© äœå¹Ž ä¹ãã 5, Vba Dir ãµããã©ã«ã 6, ã¡ã«ã«ãª éæ ã³ã 9, ããããŒã éæ®µ æããç §æ 4, 倧䜿通 æçæå®€ 2020 12, æ¯ä¹³ 倿¹ ã ããã«ã¯ 4, è³è²žå¥çŽ åçŸ©å€æŽ èŠæž 4, ã¬ãŒãã¬ãŒã« åœãŠéã èªéŠ 5, Atf ã¬ãã«ã²ãŒãž ãªã 4, ã¬ã¯ãµã¹ls F Sport 6, ãããã£ã³ã° æéŠ çãã 4, ãã©ãŽã³ããŒã« è¶ 64話 ææ³ 4, ã°ãŒã°ã«ããã ç· ã® ç· æ¶ã 17, äžæ³ ãã㰠倧ãã 11, ãã¬ãã¢ã ããã« ãã£ãŒã¿ãŒ ã·ã¹ãã ããããã³ã° 5, æ¥ç« å®¶é» æ€é 12, Pso2 æ°çæŠåš 匷å 8, ããªãã¹ Gk ã»ã¬ã¯ã·ã§ã³ 16, æ¯ä¹³ 倿¹ ã ããã«ã¯ 4, Amazon ãã£ãŒãããã¯ è³Œå ¥è 7, éå¥äŒ æ¬ åž é€å¥ 12, ã¢ãŒãã£ãŒäŒèª¬ ã¹ãã« ã¡ã㪠14, ãããã 粟油 å¹èœ 10,