Need a piece of shell scripting to remove column from a csv file

Shell Programming and Scripting
1

Hi,

I need to remove first column from a csv file and i can do this by using below command.

cut -f1 -d, --complement Mytest.csv

I need to implement this in shell scripting, Whenever i am using the above command alone in command line it is working fine.

I have 5 files in my directory and i need to find this file and then need to remove the first column from the file and i have to use the updated file which doesn't contain the removed column for later use in the script.

I tried few ways but no luck, its is just displaying the data which is there in Mytest.csv.

Thanks in advance.

Samah

2

Please show us your "few ways" so we can analyze and point out why and where they fail.

EDIT:
When you say

how do you identify it? What makes it stand out from the others?

3

Where are you sending the output to your cut command. Output from commands will typically go to your std out device, most often your screen. That is, unless you redirect your output.

What is the rest of your script?

4

I have tried below piece of codes so far
1.

FILE="Mytest.csv"

if [ -f "$FILE" ];
then
cut -f1 -d, "Mytest.csv`
   echo " FILE UPDATED "
else
   echo "File $FILE does not exist" 
fi

FILE="Mytest.csv"

if [ -f "$FILE" ];
then
cut -f1 -d, "Mytest.csv`
   echo " FILE exist | `cut -f1 -d, Mytest.csv` "
else
   echo "File $FILE does not exist" 
fi

Thanks,
Samah