I have a csv file that col 4 of contains a suffux of "_1" that I need to remove without disturbing the other columns in the csv that may or may not contain a suffix of "_1".
CSV FILE OUTPUT:
DOM, PRO, CONFIG, CONFIG_CALL, PATH
xyz.com, Num1, Num1-V, Asp_tent_1, /bin/home
abc.com, Vel1, Vell-V, Asp_App, /ai/rev/sand
123.com, Xall, X-V, X_all_time_1, /ai/test
321.com, Zall, Z-V, Z_all_1, /bin/usr/home
...
WANTED OUTPUT:
DOM, PRO, CONFIG, CONFIG_CALL, PATH
xyz.com, Num1, Num1-V Asp_tent, /bin/home
abc.com, Vel1, Vell-V, Asp_App, /ai/rev/sand
123.com, Xall, X-V, X_all_time, /ai/test
321.com, Zall, Z-V, Z_all, /bin/usr/home
I have tried some awk, grep, tr attempts but no luck.