How to delete a columns of a CSV file which has cell values with a string enclosed in " , "? Post: 302902025

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to add two values in the same cell of CSV file

I need help to create a csv file with Unix command. In csv file, i need to put two values in the same cell. Rite now, whts happening is, if i put 2 values in the same cell, its comming as " asd, zxc" but i want it in different line but in same cell. asd zxc Please reply me ASAP.

2. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone...

3. UNIX for Dummies Questions & Answers

replace "," with "." only in specific columns of a file?

Hi all, I have this text file containing 9 columns separated by space. The 8th columns contains the numbers. C1 C2 C3 C4 C5 C6 C7 C8 C9 er rt yt gh iu nk il 0.07 xs yt lr ty bg iu zk nh 0,0005 lt ...etc. I want to replace the comma with full stop only in 8th coloumn. the output...

4. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz

5. Shell Programming and Scripting

How to delete a column/columns of a CSV file which has cell values with a string enclosed in " , "?

How can I delete a column from a CSV file which has comma separated value with a string enclosed in double quotes and a comma in between? I have a file 44.csv with 4 lines including the header like the below format: column1, column2, column3, column 4, column5, column6 12,455,"string with...

6. Shell Programming and Scripting

Working with CSV files values enclosed with ""

I have a CSV file as shown below "1","SANTHA","KUMAR","SAM,MILLER","DEVELOPER","81,INDIA" "2","KAPIL","DHAMI","ECO SPORT","DEVELOPER","82,INDIA" File is comma delimited.All the field values are enclosed by double quotes. But while using awk or cut, it interprets the comma which is present in...

7. Shell Programming and Scripting

How to delete the commas in a .CSV file that are enclosed in a string with double quotes?

Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote. Please see the sample file as below: column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10...

8. Shell Programming and Scripting

Delete all log files older than 10 day and whose first string of the first line is "MSH" or "<?xml"

Dear Ladies & Gents, I have a requirement to delete all the log files in /var/log/test directory that are older than 10 days and their first line begin with "MSH" or "<?xml" or "FHS". I've put together the following BASH script, but it's erroring out: for filename in $(find /var/log/test...

9. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing...

LEARN ABOUT LINUX

cvs-debuild

CVS-DEBUILD(1)                                                General Commands Manual                                               CVS-DEBUILD(1)

NAME

       cvs-debuild - build a Debian package using cvs-buildpackage and debuild

SYNOPSIS

       cvs-debuild [debuild options] [cvs-buildpackage options] [--lintian-opts lintian options]

DESCRIPTION

       cvs-debuild  is  a  wrapper  around cvs-buildpackage to run it with debuild as the package-building program.  (This cannot simply be accom-
       plished using the -C option of cvs-buildpackage, as it does not know how to handle all of the special debuild options.)

       The program simply stashes the debuild and lintian options, and passes them to debuild when it is called by cvs-buildpackage.  All  of  the
       standard debuild options may be used (as listed below), but note that the root command specified by any --rootcmd or -r command-line option
       will be passed as an option to cvs-buildpackage.  The first non-debuild option detected will  signal  the  start  of  the  cvs-buildpackage
       options.

       The  selection  of  the  root  command is slightly subtle: if there are any command-line options, these will be used.  If not, then if cvs-
       buildpackage is set up to use a default root command, that will be used.  Finally, if neither of these are the case, then debuild will  use
       its procedures to determine an appropriate command, as described in its documentation.

       See the manpages for debuild(1) and cvs-buildpackage for more information about the behaviour of each.

OPTIONS

       The  following are the debuild options recognised by cvs-debuild.  All cvs-buildpackage and lintian options are simply passed to the appro-
       priate program.  For explanations of the meanings of these variables, see debuild(1).

       --no-conf, --noconf

       --rootcmd=gain-root-command, -rgain-root-command

       --preserve-env

       --preserve-envvar=var, -evar

       --set-envvar=var=value, -evar=value

       --lintian, --no-lintian

       --ignore-dirname, --check-dirname
              These should not be needed, but it is provided nevertheless.

SEE ALSO

       cvs-buildpackage(1), debuild(1), dpkg-buildpackage(1) and lintian(1).

AUTHOR

       This program was written by Julian Gilbey <jdg@debian.org>.

DEBIAN                                                           Debian Utilities                                                   CVS-DEBUILD(1)