Timeline for search column 2 in csv file for value, if value, then insert "invalid" and shift cells right
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 26, 2018 at 5:13 | comment | added | RomanPerekhrest | @SSDdude, your new conditions seem to be unclear. My approach provides the current expected output. Extend your question with full input fragment and respective output. | |
| Jun 25, 2018 at 20:26 | comment | added | SSDdude | Hey Roman thanks again... this works great for everything but the first record (new test had bad line as first line).. I tried modifying your awk statement but couldn't figure out how to NOT IGNORE the first records if the second cell contains .app... Thoughts? THANKS! | |
| Jun 25, 2018 at 20:10 | comment | added | RomanPerekhrest | @SSDdude, see my update | |
| Jun 25, 2018 at 20:10 | history | edited | RomanPerekhrest | CC BY-SA 4.0 | updated solution |
| Jun 25, 2018 at 20:08 | comment | added | SSDdude | Hey Roman thanks for the answer but this doesn't shift biz.app to the right it replaces the value with INVALD but does not align the other columns. Any idea how I can do this? Thanks! | |
| Jun 25, 2018 at 20:06 | history | edited | RomanPerekhrest | CC BY-SA 4.0 | added 141 characters in body |
| Jun 25, 2018 at 19:57 | history | answered | RomanPerekhrest | CC BY-SA 4.0 |