03-29-2011
Need to remove some value in CSV file
Hi All
A .csv file containing multiple value on it. i need to remove some value from it. Please advise how can i find multiple value from that and remove itself. Please provide solution for this.
Thanks in advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to remove the ita from this file:
"1234ita","john","smith"
"56789ita","jim","thomas"
the command i am using is:
sed '/^ita/d' infile.csv > outfile.csv
it is running but doing nothing, very rarely use sed so trying to learn it any help would be appreciated (2 Replies)
Discussion started by: Pablo_beezo
2 Replies
2. Shell Programming and Scripting
Hello everyone I'm new here and this is my first post so first of all I want to say that this is a great forum and I have managed to found most of my answers in these forums : )
So with that I ask you my first question:
I have an excel file which I saved as a csv. However the excel file... (3 Replies)
Discussion started by: Spunkerspawn
3 Replies
3. Shell Programming and Scripting
Hi,
I need help to remove blank rows at the end of file.
Sample data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga Kino SF",Tønsberg,202-1,Tønsberg SF 4,202-1-4
,,,,
,,,,
,,,,
,,,,
Expected data:
"Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
"Tønsberg, Brygga... (6 Replies)
Discussion started by: cnraja
6 Replies
4. Shell Programming and Scripting
Hi Experts,
My requirement is to read the csv file and need to remove if any line break in it.
sample data:
Row1: "Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91
Row2:"Tønsberg, Brygga Kino SF",Tønsberg,202-1,
Tønsberg SF 4,202-1-4
Expected data:
Row1: "Oslo, Symra... (6 Replies)
Discussion started by: cnraja
6 Replies
5. Shell Programming and Scripting
Hi All,
My requirement is to remove line (3 Replies)
Discussion started by: r_t_1601
3 Replies
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
Hi All ,
I am facing a small challenge i need unix command to remove space as well as replace "|" to "," in a csv file .
original file :
A | B | c | D
E | F | G | H
I | J | K | L
P | M | N | O
Expected o/p:
A,B,c,D
E,F,G,H
I,J,K,L
P,M,N,O (4 Replies)
Discussion started by: Sweety532
4 Replies
9. Shell Programming and Scripting
I'm a newbie to shell scripting.
Can anyone help with the below requirement ?
The leading and trailing date of a files to be removed.
2017-07-12_gmr_tag_log_20170711.csv
2017-07-12_gmr_call_log_20170711.csv
2017-07-12_gmr_outgoing_log_20170711.csv
I'm looking for output like... (7 Replies)
Discussion started by: shivamayam
7 Replies
10. Shell Programming and Scripting
how to remove unwanted commas from a .csv file
Input file format
"Server1","server-PRI-Windows","PRI-VC01","Microsoft Windows Server 2012, (64-bit)","Powered On","1,696.12","server-GEN-SFCHT2-VMS-R013,server-GEN-SFCHT2-VMS-R031,server-GEN-SFCHT2-VMS-R023"... (5 Replies)
Discussion started by: ranjancom2000
5 Replies
LEARN ABOUT DEBIAN
pytags
PYTAGS(1) [FIXME: manual] PYTAGS(1)
NAME
pytags - set and remove tags on media files from filename and options
SYNOPSIS
pytags [OPTIONS] file [file...]
DESCRIPTION
pytags is a simple, general-purpose tool for setting and removing media file tags. With no options, pytags prints a tag summary for all
files specified on the command line. Options can be used to set and remove tags on files.
Using --format, it is easy to change or create tags on by parsing metadata from filenames according to an arbitrary format string. This
makes it simple to tag files that are consistently named.
Additionally, tags can be manipulated directly with the --add, --set, and --remove options. These options are processed in order, so
options specified later on the command-line may cause values set by earlier options to be overwritten. These options must appear after the
--format, if it is used.
OPTIONS
--add=EXPR
Append a tag value all files according to EXPR. EXPR should be an expression like "artist=Foo". May be specified multiple times to add
multiple values.
--format=FORMAT
Tag files with metadata extrapolated from filenames using format string FORMAT; see the section called "FORMAT STRINGS". This option
must be specified before --add, --set, or --remove.
--set=EXPR
Set a single tag on all files according to EXPR. EXPR should be an expression like "artist=Foo". May be specified multiple times to set
multiple tags. --set cannot be used to specify multiple values for a single tag. To do that, use --remove followed by multiple --add
options.
--remove=TAG
Remove tags named TAG. May be specified more than once to remove multiple tags.
-h, --help
Show summary of options and exit.
-v, --version
Show version of program and exit.
FORMAT STRINGS
The format string expected by --format is the same as that for pytagsfs. See the pytagsfs manual page for more information.
EXAMPLES
Remove the genre tag from all .ogg files in the current directory.
$ pytags --remove genre *.ogg
Set the artist and album tag on all .mp3 files, and remove the genre tag.
$ pytags --set artist=Foo --set album=Bar --remove genre *.mp3
Tag all of the .flac files in the current directory. All such files are assumed to be in the format "tracknum artist - trackname
[album].flac".
$ pytags --format '%n %a - %t [%l].flac' *.flac
BUGS
Please report bugs on launchpad at http://launchpad.net/products/pytagsfs/+bugs.
pytags relies on mutagen (the underlying Python tags library) to choose an appropriate tag format for the files being tagged. This cannot
currently be overridden.
SEE ALSO
pytagsfs(1)
AUTHOR
Forest Bond
Author.
COPYRIGHT
Copyright (C) 2007, 2008, 2009
[FIXME: source] 2009-12-04 PYTAGS(1)