I have date that looks like this:
1212-M-BSS DEFAULT=1000
1212-M-PSS DEFAULT=1000
1212-W-BSS DEFAULT=1000
1212-W-PSS DEFAULT=1000
1212-X-BSS DEFAULT=1000
1212-X-PSS DEFAULT=1000
That I want it to look like this:
1212-M-BSS DEFAULT=1000
1212-M-PSS DEFAULT=1000
1212-W-BSS DEFAULT=1000
1212-W-PSS DEFAULT=1000
1212-X-BSS DEFAULT=1000
1212-X-PSS DEFAULT=1000
So I want to target all the PSS and insert a row after that. And also there are other columns in a row that has PSS.
Making sure that it only insert one blank row per any found PSS in a row.
All helps are appreciated in advance.
Bookmarks