How to split rows into column by specific delimiter
Hello. Good afternoon! Well, being direct: The question of the output of the ";" to "," I solved it... I have a routine that generates a CSV file, and it looks like this: A B C D E F G 1,2,3,4,5a 5b 5c 5d,6,7 I would like it to look like this: A B C D E F G 1,2,3,4,5a,6,7 1,2,3,4,5b,6,7 1,2,3,4,5c,6,7 1,2,3,4,5d,6,7 But the fundamental issue is that I need to preserve the contents of the other columns, replicating them to the rows... As in the situation... While column E is 5a, 5b, 5c... Columns A, B, C and D must repeat their contents... To achieve this scenario, I have opened it in Excel and done the "data transformation", asking it to divide the column by the space delimiter. This operation, due to manual intervention, ends up taking longer than it should... Via Powershell, how could I do this?
