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 @clupasq:
Unlock 3 remaining solutions by signing in and submitting your own entry