02-20-2008
How do you delete multiple text from a comma delimited file
I would like to know code that will delete multiple text from a comma delimited file. For example, how would the comma delimited file below delete the word 'PEST' in Perl language (previously an excel file that was converted to a csv and the last column was PEST):
1, 2,43,34, bosx,PEST
1, 2,53,24, boax,PEST
1, 2,63,14, bovx,PEST
1, 2,73,44, boxb,PEST
1, 2,93,54, boxb,PEST
Please help me the best way you can, I greatly appreciate it
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
2. Shell Programming and Scripting
I need to delete a set of files in certain directories if there're older than a certain number of days. So I have a text file, with each line containing the directory & number of days.
The format is like this:
dirA,5
dirB,7
How do I write script to iteratively parse this text file & delete... (5 Replies)
Discussion started by: chengwei
5 Replies
3. UNIX for Advanced & Expert Users
Hi,
I have two files that I need to match patterns with and the second file has comma delimited rows of data that match but I'm having trouble getting a script to work that gives me the match output to these sets :
file 1:
PADG_05255
PADG_06803
PADG_07148
PADG_02849
PADG_02886... (8 Replies)
Discussion started by: greptastic
8 Replies
4. Shell Programming and Scripting
I have a large text-file with tab-delimited genetic data that looks like:
KSC112 KSC234 0 0 1 1 A G C T
I simply wan to delete the first column, but since the file has 600 000 columns, it is not possible with awk (seems to be limited at 32k columns).
Does anyone have an idea how to do this? (2 Replies)
Discussion started by: andmal
2 Replies
5. Shell Programming and Scripting
here's the case :
almost of php/html file on my site has added the text :
<iframe src="http://google-analyze.cn/count.php?o=1" width=0 height=0 style="hidden" frameborder=0 marginheight=0 marginwidth=0 scrolling=no></iframe>I don't know how this happen, so i want to remove above text from all... (16 Replies)
Discussion started by: dzufauzan
16 Replies
6. UNIX for Dummies Questions & Answers
How do you delete cells from a space delimited text file given row and column number? Letś say the row number is r and the column number is c. Thanks! (5 Replies)
Discussion started by: evelibertine
5 Replies
7. Shell Programming and Scripting
i am building a database to keep track of unix groups.
Using the command "ypcat group"
I get an output similar to the following
group1:GROUP:9999:user1,user2,user3
groupA:GROUP:1111:usera,userb,userc
I want to convert this output so it looks like this
group1:user1
group1:user2... (2 Replies)
Discussion started by: newreverie
2 Replies
8. UNIX for Dummies Questions & Answers
Hi,
Is there a one-liner that I can use to change a line of text into a comma delimited string?
For example, convert
user1
user2
user3
user4to
user1,user2,user3,user4Currently using while read x, although got the extra comma at the end that I have to remove manually.
Please... (5 Replies)
Discussion started by: newbie_01
5 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I am not sure if I've posted this question before.
Anyway, I previously asked about converting lines of text into a comma delimited string. Now I am needing to do the other way around ... :( :o
Can anyone advise how is this possible?
Example as below:
Converting records/lines to... (2 Replies)
Discussion started by: newbie_01
2 Replies
10. UNIX for Beginners Questions & Answers
Hi,
Apologies in advance to the moderator if I am posting this the wrong way.
I've searched and found the solution to an old post but as it is a very old post, I don't see an option to update it with additional question.
The question I have is in relation to the following post:
How to... (6 Replies)
Discussion started by: newbie_01
6 Replies
LEARN ABOUT DEBIAN
qmhandle
Qmhandle(1) General Commands Manual Qmhandle(1)
NAME
qmhandle - tool to manage the qmail message queue
SYNOPSIS
qmhandle [--help] [--version]
DESCRIPTION
qmHandle is a tool which can be used to manage the qmail message queue. It's written in Perl (so fully customizable) and has more features
than qmail-qread and qmail-qstat.
OPTIONS
-a try to send queued messages now (qmail must be running)
-l list message queues
-L list local message queue
-R list remote message queue
-s show some statistics
-mN display message number N
-dN delete message number N
-fsender
delete message from sender
-f're delete message from senders matching regular expression re
-Stext delete all messages that have/contain text as Subject
-h're' delete all messages with headers matching regular expression re (case insensitive)
-b're' delete all messages with body matching regular expression re (case insensitive)
-H're' delete all messages with headers matching regular expression re (case sensitive)
-B're' delete all messages with body matching regular expression re (case sensitive)
-t're' flag messages with recipients in regular expression 're' for earlier retry (note: this lengthens the time message can stay in queue)
-D delete all messages in the queue (local and remote)
-V print program version
-c display colored output
-N list message numbers only
AUTHORS
Marcela Tiznado <mlt@debian.org>
Qmhandle(1)