katelynnm 1 Posted October 14, 2013 Report Share Posted October 14, 2013 (edited) How can I go through a column of a csv and delete all instances of a letter-even when it is part of a word? For example, remove every instance of the letter "E"? Here is what I have tried: set table cell(&my table, #row_num, 2, $replace($table cell(&my table, #row_num, 2), "Â", $nothing)) increment(#row_num) Edited October 14, 2013 by katelynnm Quote Link to post Share on other sites
k1lv9h 76 Posted October 14, 2013 Report Share Posted October 14, 2013 Hi, Not sure if you put what you tried in a loop. Sample: set(#row_num, 0, "Global") loop($table total rows(&ttab)) { set table cell(&my table, #row_num, 2, $replace($table cell(&my table, #row_num, 2), "E", $nothing)) increment(#row_num) }Kevin Quote Link to post Share on other sites
katelynnm 1 Posted October 14, 2013 Author Report Share Posted October 14, 2013 Hi Kevin, Thanks-I was able to figure it out using a replace command with some regex and then looping it. Quote Link to post Share on other sites
Code Docta (Nick C.) 638 Posted October 14, 2013 Report Share Posted October 14, 2013 Yes, Regex is your friend!! Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.