replace 2nd column blanks with values in same column if blank
Where ,SOMELOGB and ,SOMELOGC replaces each /r carriage return if 2nd column is blank. The replace only happens if 2nd column is blank though and should replace up to the non blank row.
Start file
TEST,SOMELOG TESA,SOMELOGA TESB TESC TESD,SOMELOGB TESE TESF TESG,SOMELOGC
End file
TEST,SOMELOG TESA,SOMELOGA TESB,SOMELOGB TESC,SOMELOGB TESD,SOMELOGB TESE,SOMELOGC TESF,SOMELOGC TESG,SOMELOGC
View Diff
3,4c3,4 < TESB < TESC --- > TESB,SOMELOGB > TESC,SOMELOGB 6,7c6,7 < TESE < TESF --- > TESE,SOMELOGC > TESF,SOMELOGC
Solutions by @assaflavie:
Unlock 4 remaining solutions by signing in and submitting your own entry