我有一个列长度固定的输入文件,我需要将文件转换为 csv。
当前代码将其转换为 csv,但列会根据不同长度的空格进行偏移。
如何删除多余的逗号以使列数统一?
C#、Visual Studio 和 CSV
using System;
using System.IO;
using System.Linq;
namespace write_csv
{
class Program
{
static void Main(string[] args)
{
string csvfilePath = @"C:\Users\ai_hacker\Desktop\output.csv";
string[] lines = System.IO.File.ReadAllLines(@"C:\Users\ai_hacker\Desktop\orsc1827.ot2");
foreach (string line in lines)
{
var parts = line.Split(' ');
string csvLine = string.Join(',', parts);
Console.WriteLine(csvLine);
File.AppendAllText(csvfilePath, csvLine + Environment.NewLine);
}
}
}
}
输入:
439790 6806991 4700 NORTH AMERICAN 04/18/19 08161895 P90947L6 - O076GG7F
91921221 6835746 1385 GALLAGHER POWER04/18/19 09024922 P90948G0 - O076GHAR
当前输出:
439790,,,,,,,,,,,,,,,,6806991,,,4700,,,,,,,NORTH,AMERICAN,04/18/19,,08161895,,P90947L6,-,O076GG7F
91921221,,,,,,,,,,,,,,6835746,,,1385,,,,,,,GALLAGHER,POWER04/18/19,,09024922,,P90948G0,-,O076GHAR
需要列对齐:
439790,6806991,4700,NORTH,AMERICAN,04/18/19,08161895,P90947L6,-,O076GG7F
91921221,6835746,1385,GALLAGHER,POWER04/18/19,09024922,P90948G0,-,O076GHAR
千巷猫影
拉莫斯之舞
慕侠2389804
MM们
相关分类