Powershell converts text into a table.

Powershell converts text into a table.

 

$ Text = "1 fantasy westward journey 216406 2014-01-21 data piece 2 hearth stone legend 15905 Public Beta 3 new westward journey 214465 Public Beta 4 ask 11322 10094 10056 shenwu 10011 2010-09-17 Public Beta 8 man Q Chuan 9576 2014-06-27 internal Beta 9 goddess Three Kingdoms 9343 2014-06-28 internal beta 10 champion showdown 8809 2014-04-23 Public Beta 11 I want to seal a day 4447 2014-07-05 Public Beta 12 Taoyuan will star record 4324 2012-05-24 Public Beta 13 Feng Shen 3899 2011-11-24 public test 14 excellent spirit legend 3779 2013-07-20 internal test 15 fantasy Sui and Tang 3462 2014-07-11 public test 16 peach blossom source note 3289 2013-06-21 internal test 17 Condor Heroes 3112 2012-09-20 public test 18 westward journey community 2516 2012-08-31 limited internal test 19 fantasy legend 22421 fairy public test 20 Three Kingdoms 2313 2010-04-28 internal test "$ t1 = @() $ text. split ("'n'", [StringSplitOptions]: RemoveEmptyEntries) | % {$ game = "" | select ranking, game name, heat value, date, status, remarks $ game. ranking = $ _. split () [0] $ game. game name =$ _. split () [1] $ game. heat value = $ _. split () [2] $ game. date = $ _. split () [3] $ game. status = $ _. split () [4] $ t1 + = $ game} $ t1 | Export-Csv "games.csv"-not-Enc oem