mjhjmtu

I have csv file that is auto generated by a script but for some of the records (line items) received I need to search column 2 and if the values contains "*.app" I need to print "INVALID" into column 2 for all records matching and shift cells to the right.

Example Data File:

 DOM,PROJ,APP,USER,DATE,TIME,STATUS
 www,test,biz.app,bob,6-1-18,09:33,OK //Example of good line 
 www,biz.app,tony,7-11-17,06:22,ok //Example of bad line
 ...

 Wanted output:
 DOM,PROJ,APP,USER,DATE,TIME,STATUS
 www,test,biz.app,bob,6-1-18,09:33,OK 
 www,INVALID,biz.app,tony,7-11-17,06:22,ok //Example of fixed line
 ...

I have unsuccessfully tried awk, sed, and if statement but not getting the results I need

 e.g.

 if [ awk -F',' ' print $2 < FILE' ] == "*.app" ; then ; echo "INVALID"; fi

Which is obviously terrible... New to bash thanks all!

awk -F, -vOFS=, '$2 ~ /.app$/ for (i = NF + 1; i > 2; --i) $i = $(i-1); $2 = "INVALID" 1' file >newfile

This would create newfile from file. The awk command sets both the input and output field delimiter to a comma, then tests the value of column two against a regular expression which matches the string .app at the end of the value. If the test succeeds, the record's fields are shifted right one step to make place for the string INVALID as the new second field.

The trailing 1 could be replaced by print (it causes every line to be outputted).

With the given example data, the output file would contain

DOM,PROJ,APP,USER,DATE,TIME,STATUS
www,test,biz.app,bob,6-1-18,09:33,OK
www,INVALID,biz.app,tony,7-11-17,06:22,ok

Awk approach:

awk 'BEGIN FS = OFS = "," NR > 1 && $2 ~ /.*.app/ $2 = "INVALID" OFS $2 1' file

• 
  NR > 1 && $2 ~ /.*.app/ - if record number is greater than 1 (all but first) and the 2nd field $2 matchs the pattern /.*.app/
  

The output:

DOM,PROJ,APP,USER,DATE,TIME,STATUS
www,test,biz.app,bob,6-1-18,09:33,OK 
www,INVALID,biz.app,tony,7-11-17,06:22,ok

Using the GNU sed tool we can approach this problem as follows:

 sed -e '
 1!s/,/n&/2
 /.appn/s/,/,INVALID,/
 s/n//
 ' file.csv

To be read as:

 ° Only for lines that are not the first, meaning, skip the header from being considered for processing, whilst for the others, place a marker at the second occurrence of the comma.
 ° Any line that has the 2nd field terminating in a .app append the string INVALID after the first field.
 ° Now take away the marker.
 ° N. B. Lines whose 2nd field doesn't comprise *.app are passed on unmodified.