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
![Smilie Smilie](https://www.unix.com/images/smilies/smile.gif)
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 HPUX
delete_clearinghouse
delete clearinghouse(1m) delete clearinghouse(1m)
NAME
delete clearinghouse - Deletes the specified clearinghouse from the local server system
SYNOPSIS
cdscp delete clearinghouse clearinghouse-name
ARGUMENT
The full name of the clearinghouse.
DESCRIPTION
The delete clearinghouse command deletes a clearinghouse from the local server system. CDS does not permit you to delete a cleared clear-
inghouse. Before you can delete a cleared clearinghouse, you must recreate it using the create clearinghouse command.
The delete clearinghouse command automatically deletes all read-only replicas from a clearinghouse. CDS does not permit you to delete a
clearinghouse that contains a master replica. See the DCE Directory Service module of the DCE Administration Guide for more information
about handling master replicas when deleting a clearinghouse.
Permissions Required
You must have write and delete permission to the clearinghouse and administer permission to all directories that store replicas in the
clearinghouse. The server principal needs delete permission to the associated clearinghouse object entry and administer permission to all
directories that store replicas in the clearinghouse.
NOTES
It is recommended that you delete all replicas except the root before issuing this command.
This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.
EXAMPLE
The following command deletes a clearinghouse named /.:/sales/Orion_CH from the local server system: cdscp> delete clearinghouse
/.:/sales/Orion_CH
RELATED INFORMATION
Commands: clear clearinghouse(1m), create clearinghouse(1m), list clearinghouse(1m), set cdscp preferred clearinghouse(1m), show clearing-
house(1m), show cdscp preferred clearinghouse(1m)
Books: DCE Administration Guide
delete clearinghouse(1m)