02-29-2012
Inverse of Cut
Hi List,
I have a CSV file which I am manipulating. Each time I receive the CSV for processing, there will be extra columns of data.
Here's what I want to do; I want to be able to remove specific columns from the CSV data file, but keep the remaining columns, where the remaining columns are variable in how many columns there are. (there will be more columns each time the script is run on new data)
Lets say I want to remove columns 2,3,4,5,10 and keep the rest
Normally, in a fixed length CSV, which has the same amount of columns every time it is processed, say 20 columns each time, I would use the following command to achieve this: (thereby specifying columns I do want)
cut -d"," -f 1,6,7,8,9,11,12,13,14,15,16,17,18,19,20
But since the amount of columns will increase each time I have to run this process, then I need a means of specifying columns that I don't want (inverse cut) rather than what I do want. Perhaps this could be achieved in sed or awk..
Has anyone got any ideas?
Any help much appreciated.
thanks,
land
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am trying to discover the sequence of escape characters that I need to pass ksh in order to turn inverse video on and off. I need this information for two reasons:
* I want to include inverse video text in some shell scripts
* I wish to highlight a section of an /etc/motd file
Thanks for... (2 Replies)
Discussion started by: sam_pointer
2 Replies
2. UNIX for Dummies Questions & Answers
I have few days to complete my awk homework. But I'm stucked. i hope some1 will help me out.
I have to inverse n x n matrix, but I have problems with finding the determinant of the matrix.
I found the algoritm, how to find a determinant of n x n matrix:... (0 Replies)
Discussion started by: vesyyr
0 Replies
3. Shell Programming and Scripting
I need to inverse a matrix given in a file.
The problem is I'm stuck with writing determinant finding algoritm into code.
I found this algoritm about finding determinant of nxn matrix. This is what i need:
Matrices and Determinants
and here:
a11 a12 a13
a21 a22 a23
a31 a32 a33... (0 Replies)
Discussion started by: vesyyr
0 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
Is there an option for 'rm' to "remove everything but these files"?
For instance if I have:
a.txt <-- I just want to remove this one
a_1.txt
a_2.txt
Is there an option ? for this:
rm -? *_*.txt
Thanks,
ScKaSx (4 Replies)
Discussion started by: ScKaSx
4 Replies
5. Shell Programming and Scripting
Hi,
I'm trying to wtite a script which actually print the text which doesn't contain a word , i mean to say.
eg:- if a file contains the follwoing data
Hello how ru ???
What ru doing ?
what is the % of data contained ???
I want to write a script such that it prints the line excluding... (1 Reply)
Discussion started by: nagios
1 Replies
6. Shell Programming and Scripting
I am totally unexperienced in writing scripts of any kind.
I am working on Mac OS X and would like to run a shell script to find files in a directory that do not conform to a specific naming convention and print to a text file in the same directory.
For example, I have a folder called... (9 Replies)
Discussion started by: j_alicea
9 Replies
7. Programming
I ask of you but yet another simplistic question that I hope can be answered. Its better explained showing my code. Here is my list(tmp_pkglist), which contains a list of all Debian (Jessie) packages:
snippet
'zssh (1.5c.debian.1-3.2+b1 , 1.5c.debian.1-3.2 )',
'zsync (0.6.2-1)',
'ztex-bmp... (2 Replies)
Discussion started by: metallica1973
2 Replies
8. UNIX for Beginners Questions & Answers
I have an interactive script which sorts and processes a variety of filetypes from an unsorted folder into newly created directories.
The script works great, But I was wondering how I could generate a script with an inverse action so that I could unwind / undo the executed script and its sorting... (3 Replies)
Discussion started by: Braveheart
3 Replies
LEARN ABOUT DEBIAN
portabase
PORTABASE(1) General Commands Manual PORTABASE(1)
NAME
portabase - an easy-to-use personal database application
SYNOPSIS
portabase [ -h | --help | <file> ]
portabase command [ -p password ] [ options ] <fromfile> <tofile>
DESCRIPTION
PortaBase (portable database) is a personal database application that is available for many platforms, including Linux, Mac OS X, Windows,
and Maemo.
PortaBase's features include:
- One data table per file
- String, Integer, Decimal, Boolean, Note (multi-line text), Date,
Time, Calculation, Sequence, Image, and Enum column types
- Add, edit, and delete rows of data
- Custom data views (subsets of the columns in any order)
- Filter the displayed rows using sets of conditions
- Sort the rows by any combination of columns, each in ascending or
descending order
- Optional page navigation buttons, with a custom number of rows per page
- Add, delete, rearrange, and rename columns at any time
- Specify default values for columns
- View summary statistics for columns (total, average, min, max, etc.)
- Import data from CSV, XML, and MobileDB files
- Export data to CSV and XML files
- Command-line format conversions (to and from XML, from MobileDB)
- Data file encryption
- Unicode support
- Pick any available font to use throughout the application
COMMANDS
PortaBase uses the following commands to indicate a command-line file conversion:
fromxml
Create a new PortaBase file from the input XML file.
frommobiledb
Create a new PortaBase file from the input MobileDB file.
fromcsv
Add rows to an existing PortaBase file from the input CSV file.
toxml Create a new XML file from the input PortaBase file.
tocsv Create a new CSV file from the input PortaBase file.
If an encrypted PortaBase file is to be read or created, the following option can be used immediately after the command:
-p <password>
Open or create the encrypted PortaBase file using the given password
The toxml and tocsv commands accept the following options:
-v <view>
Apply the named view before exporting.
-s <sorting>
Apply the named sorting before exporting.
-f <filter>
Apply the named filter before exporting.
The fromcsv command supports one option:
-e <encoding>
Specifies the text encoding of the imported CSV file; options are UTF-8 (the default) and Latin-1.
OPTIONS
PortaBase accepts the following options:
-h, --help
Display usage instructions.
FILES
$HOME/.qt/portabaserc - user-specific settings. Stores information on font, checkbox editing, delete confirmations, etc.
AUTHOR
This manual page was written by Jeremy Bowman <jmbowman@alum.mit.edu>, for the Debian GNU/Linux system (but may be used by others).
April 16, 2010 PORTABASE(1)