[solved]Find and Delete/Replace from Column

[katelynnm 1]

I'm trying to search a table and find all instances of a string within a specific column and replace them with nothing.  For instance: search Column 1 and replace all instances of the word "mile" with nothing, but keep everything else that is in the cell.  How would I go about doing that?  Thank you in advance.

Edited October 14, 2013 by katelynnm

[HelloInsomnia 1103]

This is some code that should help. Basically you need to loop for the total number of rows inside of the table. Then set the table cell to be the same table cell but with a replacement of the string that you want.

set table cell(&data, 0, 0, "test00")
set table cell(&data, 0, 1, "test01")
set table cell(&data, 1, 0, "test10")
set table cell(&data, 1, 1, "test11")
set(#loop_row_num, 0, "Global")
loop($table total rows(&data)) {
    set table cell(&data, #loop_row_num, 0, $replace($table cell(&data, #loop_row_num, 0), "test", "coffee"))
    increment(#loop_row_num)
}

[UBotDev 276]

Instead of manually looping through the table I think you'll be able to use "$table search" function, which returns the column/row in which searched string was found (However, you will need to repeat this search while function only returns first match).

 

Once you find that row you can change the cell with "set table cell" command.

[katelynnm 1]

Thank you both.  HelloInsomnia: I just tried what you posted and it replaces every cell with numbers that increase by one all the way down.

 

Here is the table that I'm trying to change:

 

http://s12.postimg.org/ikzl0vci5/one.jpg

 

I want it to go through the middle column and remove all instances of "m run".  Basically code that changes it to this:

 

http://s22.postimg.org/d31p69sap/image.jpg

 

Here is my ubot code thus far:

create table from file("C:\\Users\\Katelynn\\Desktop\\data2.csv", &my table)
set(#loop_row_num, 0, "Global")
loop($table total rows(&my table)) {
    set table cell(&my table, #loop_row_num, 1, $replace($table cell(&my table, #loop_row_num, 0), "m run", "nothing"))
    increment(#loop_row_num)
}
save to file("C:\\Users\\Katelynn\\Desktop\\data3.csv", &my table)

Edited October 9, 2013 by katelynnm

[Pete 121]

if this is a one off update I would use a regex

 

set(#input, $replace regular expression($read 
file("C:\\Users\\Katelynn\\Desktop\\data2.csv"), "((\s[m])(\srun))", $nothing), "Global")save 
to file(#input, "C:\\Users\\Katelynn\\Desktop\\output.csv")

[HelloInsomnia 1103]

+1 for what Zap said but if you want to do it the way I showed above try this code instead:

create table from file("C:\\Users\\Katelynn\\Desktop\\data2.csv", &my table)
set(#loop_row_num, 0, "Global")
loop($table total rows(&my table)) {
    set table cell(&my table, #loop_row_num, 1, $replace($table cell(&my table, #loop_row_num, 1), "m run", $nothing))
    increment(#loop_row_num)
}
save to file("C:\\Users\\Katelynn\\Desktop\\data3.csv", &my table)

[LoWrIdErTJ - BotGuru 904]

I have a tool (plugin) that i was developing for just this thing and much more.   I should have it out next day or 2 as soon as i finish up the videos, and example code

[katelynnm 1]

Thank you for all of the advice, everyone!

 

HelloInsomnia - that worked perfectly!  Thank you so much!! 

 

LoWrldErTJ - I'd love to see your plugin when you've finished it-it sounds awesome!

[LoWrIdErTJ - BotGuru 904]

ill have the sales thread up here soon and videos done

but you can see the current and planned feature set at

https://www.botguru.net/ubot-studio-list-and-csv-grids-and-extended-features/

[Bliss 194]

You can always check out my table plugin too   

 

http://www.ubotstudio.com/forum/index.php?/topic/12583-sell-ubot-table-addon-plugin-duplicate-tables-search-tables-sort-compare-and-more/