Remove text from a csv file using sed Post: 302313288

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed csv remove conditionally

Hello, I have many csv file, but I would like to delete lines with some values in a column conditionally. My example look like this, ex1e, ex2g, ex39, pasg, ssg, mrlc, pc, kb, coop -112, -53, -177, 64, 62, 71, 1, 487, 20 -101, -61, -53, 0, 32767, 51, 0, ...

2. Shell Programming and Scripting

How to use sed to remove html tags including text between them

How to use sed to remove html tags including text between them? Example: User <b> rolvak </b> is stupid. It does not using <b>OOP</b>! and should output: User is stupid. It does not using ! Thank you..

3. Shell Programming and Scripting

sed to remove 1st two characters every line of text file

what is the sed command to remove the first two characters of every line of a text file? each line of the text file has the same amount of characters, and they are ALL NUMERIC. there are hundreds of lines though. for example, >cat file1.txt 10081551 10081599 10082234 10082259 20081134...

4. Shell Programming and Scripting

Sed or awk script to remove text / or perform calculations from large CSV files

I have a large CSV files (e.g. 2 million records) and am hoping to do one of two things. I have been trying to use awk and sed but am a newbie and can't figure out how to get it to work. Any help you could offer would be greatly appreciated - I'm stuck trying to remove the colon and wildcards in...

5. Shell Programming and Scripting

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.

6. UNIX for Dummies Questions & Answers

How To Use sed To Remove Text Between '/*'?

First of all let it be said that I hate sed. Every time I think I've got it figured out it proves me wrong. There, now with that out of the way here's my problem that I'm hoping one of you smart people can solve: I have a file full of lines like this: If x=1 then /* this is an if statement */...

7. Shell Programming and Scripting

Using sed to remove a column from a CSV

I found that the following works to remove the first column in my file when my CSV is delimited with a simple comma: sed -i 's/*,//' file.csv However, I have a new file where the fields are encapsulated with double quotes - general example of file: "Internal ID", "External ID", "Name"...

8. Shell Programming and Scripting

sed to remove partial text in one line only

I have test.xml XML file like <Report account="123456" start_time="2014-09-08T00:00:00+00:00" end_time="2014-09-10T23:59:59+00:00" user="Dollar Tree" limit="1000000" more_sessions="some text "> <Session ......rest of xml............... I need output like <Report> <Session ......rest of...

9. Shell Programming and Scripting

Remove text with sed or anything?

Hi there, my first post, so you might find my noobness ;) I need help to fix a thing, find /mnt/fs01/gfx/ -iname "*.rar" > gfx.txt Gives this contained textfile: /mnt/fs01/gfx/toba/toba.rar /mnt/fs01/gfx/zeta/zimba.rar /mnt/fs01/gfx/brashe/getha.rar And now the tricky part (for...

10. Shell Programming and Scripting

sed to remove text from file

Trying to use sed to, in-place, remove specific text from a file. Since there are / in the text I use | to escape that character. Thank you :). sed -i -e 's|xxxx://www.xxx.com/xx/xx/xxx/.*/|' /home/cmccabe/list sed: -e expression #1, char 51: unterminated `s' command

LEARN ABOUT DEBIAN

jsonbot

JSONBOT(1)							    jsb manual								JSONBOT(1)

NAME

       JSONBOT - The JSON everywhere bot!

SYNOPSIS

       JSONBOT is a remote event-driven framework for building bots that talk JSON to each other over XMPP. This manual page documents briefly the
       jsb distribution..

DESCRIPTION

       This distribution provides bots built on this framework for console, IRC, XMPP, Convore and WWW on the shell.

USAGE

       JSONBOT uses command line options to configure a bot. See the --help option to get more help on a command options or see the  corresponding
       man page.

       the jsb pakage contains the following programs:

	   * jsb - console version of jsb
	   * jsb-backup - create backup of JSONBOT datadir
	   * jsb-convore - convore version of jsb
	   * jsb-init - create data directory and config examples, default ~/.jsb
	   * jsb-irc - IRC version of jsb
	   * jsb-fleet - mix IRC and XMPP bots
	   * jsb-sed - sed a whole directory
	   * jsb-stop - stop a running bot
	   * jsb-tornado - a shell web server based on tornado
	   * jsb-udp - send udp packets to the bot that will relay the data
	   * jsb-xmpp - XMPP version of jsb

       note: JSONBOT is in BETA stage right now and still subject to change of protocols and API.

       see http://jsonbot.googlecode.com.  see https://jsonbot.org for documentation on the bot.

SEE ALSO

       The program is documented fully on http://jsonbot.org or see http://jsonbot.googlecode.com

SEE ALSO

       jsb(1), jsb-backup(1), jsb-init(1), jsb-irc(1), jsb-xmpp(1), jsb-fleet(1), jsb-tornado(1),  jsb-stop(1), jsb-udp(1)

AUTHOR

       This manual page was written by Bart Thate <bthate@gmail.com>, for the Debian GNU/Linux system (but may be used by others).

Debian GNU/Linux						    22 Nov 2011 							JSONBOT(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed csv remove conditionally

Discussion started by: Jae

2. Shell Programming and Scripting

How to use sed to remove html tags including text between them

Discussion started by: alphagon

3. Shell Programming and Scripting

sed to remove 1st two characters every line of text file

Discussion started by: ajp7701

4. Shell Programming and Scripting

Sed or awk script to remove text / or perform calculations from large CSV files

Discussion started by: metronomadic