Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need a piece of shell scripting to remove column from a csv file
Top Forums Shell Programming and Scripting Need a piece of shell scripting to remove column from a csv file Post 302974989 by Samah on Tuesday 7th of June 2016 01:21:18 AM
Old 06-07-2016
I have tried below piece of codes so far
1.
Code:
FILE="Mytest.csv"

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

2.
Code:
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
Last edited by Don Cragun; 06-07-2016 at 05:01 AM.. Reason: Add CODE tags.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script to remove extra commas from CSV outp file

Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location -----------------------,------------------------------------------------,-------,-----,---------------------------------,------------------------------------ ----... (1 Reply)
Discussion started by: sreenath1037
1 Replies

2. Shell Programming and Scripting

Remove line feed from csv file column

Hi All, My requirement is to remove line (3 Replies)
Discussion started by: r_t_1601
3 Replies

3. Shell Programming and Scripting

Remove line feed from csv file column

Hi All, i have a csv file . In the 7th column i have data that has line feed in it. Requirement is to remove the line feed from the 7th column whenever it appears There are 11 columns in the file C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11 The value in C7 contains line feed ( Alt + Enter ),... (2 Replies)
Discussion started by: r_t_1601
2 Replies

4. Shell Programming and Scripting

How to insert a sequence number column inside a pipe delimited csv file using shell scripting?

Hi All, I need a shell script which could insert a sequence number column inside a dat file(pipe delimited). I have the dat file similar to the one as shown below.. |A|B|C||D|E |F|G|H||I|J |K|L|M||N|O |P|Q|R||S|T As shown above, the column 4 is currently blank and i need to insert sequence... (5 Replies)
Discussion started by: nithins007
5 Replies

5. Shell Programming and Scripting

Remove line breaks in csv file using shell script

Hi All, I've a csv file in which the record is getting break into 1 line or more than one line. I want to combine those splits into one line and remove the unwanted character existing in the record i.e. double quote symbol ("). The line gets break only when the record contains double... (4 Replies)
Discussion started by: rajak.net
4 Replies

6. Shell Programming and Scripting

Shell scripting:from text file to CSV

Hello friends, I have a file as follows: "empty line" content1 content2 content3 content1 content2 content3 content1 content2 content3 It starts with an empty line, how can i get a csv like this: (12 Replies)
Discussion started by: kraterions
12 Replies

7. Shell Programming and Scripting

Remove the values from a certain column without deleting the Column name in a .CSV file

(14 Replies)
Discussion started by: dhruuv369
14 Replies

8. Shell Programming and Scripting

How to calculate avg values of csv file using shell scripting .?

hi all i have a reporting work and i want it to be automated using shell scripting kindly let me know how can i make that possibe . eg data are :... (2 Replies)
Discussion started by: Avinash shaw
2 Replies

9. Shell Programming and Scripting

Read csv file, convert the data and make one text file in UNIX shell scripting

I have input data looks like this which is a part of a csv file 7,1265,76548,"0102:04" 8,1266,76545,"0112:04" I need to make the output data should look like this and the output data will be part of text file: 7|1265000 |7654899 |A| 8|12660000 |76545999 |B| The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies

LEARN ABOUT OPENDARWIN

apple_dump

APPLE_DUMP(1)                                                      Netatalk 2.2                                                      APPLE_DUMP(1)

NAME

       apple_dump - Dump AppleSingle/AppleDouble format file

SYNOPSIS

       apple_dump [-a] FILE | DIR
                                                          apple_dump -f FILE
                                                          apple_dump -d FILE
                                                          apple_dump -h | -help | --help
                                                          apple_dump -v | -version | --version

DESCRIPTION

       apple_dump dump AppleSingle/AppleDouble format file.

OPTIONS

       -a FILE|DIR
           This is default. Dump a AppleSingle/AppleDouble file for FILE or DIR automatically. Extrapolate FinderInfo type from absolute path. If
           FILE is not AppleSingle/AppleDouble format, look for .AppleDouble/FILE and ._FILE. If DIR, look for DIR/.AppleDouble/.Parent and ._DIR.

       -f FILE
           Dump FILE. Assume FinderInfo to be FileInfo.

       -d FILE
           Dump FILE. Assume FinderInfo to be DirInfo.

       -h, -help, --help
           Display the help and exit

       -v, -version, --version
           Show version and exit

NOTE

       There is no way to detect whether FinderInfo is FileInfo or DirInfo. By default, apple_dump examins whether file or directory, a parent
       directory is .AppleDouble, filename is ._*, filename is .Parent, and so on.

       If setting option -f or -d, assume FinderInfo and doesn't look for another file.

SEE ALSO

       ad(1)

Netatalk 2.2                                                        02 Sep 2011                                                      APPLE_DUMP(1)
All times are GMT -4. The time now is 12:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy