Đã hoàn thành

csv manipulation (with powershell)

I have a csv file with 8 columns, one column contains multiple values delimited by ";"

I'd like to split those entries into one row each.

INPUT:

Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8

"test1","test2a;test2b;test2c","test3","test4","test5","test6","test7","test8"

OUTPUT:

Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8

"test1","test2a","test3","test4","test5","test6","test7","test8"

"test1","test2b","test3","test4","test5","test6","test7","test8"

"test1","test2c","test3","test4","test5","test6","test7","test8"

Kĩ năng: Powershell

Xem nhiều hơn: web form output xml file, python script output text file, sort number output text file, export-csv powershell, powershell import-csv foreach, powershell export to csv with headers, powershell read csv file line by line, powershell import-csv select column, powershell lookup value in csv, powershell convertfrom-csv, powershell script to read and write csv file, file input struct, file input output programs visual basic, visual basic input output text file, excel file input output, mips file input output, file input output macro excel, input file gui output text file, want gui file input output, gui front end user input output vbs file

Về Bên Thuê:
( 4 nhận xét ) london, United Kingdom

ID dự án: #26115606

Được trao cho:

writingapp

Hi. So splitting column 2 to new rows right? I have written many automation PowerShell scripts. Ready to write your project. Will complete within 1 day

£20 GBP trong 1 ngày
(4 Đánh Giá)
3.0