The Deal Journal Blog: Updated throughout. the market day with exclusive commentary, news flashes, profiles, data and more, The Deal Journal provides you. with the up-to-the-minute take on deals and deal-makers. Visit Now >>.
var numericString = testString.replace(/[^0-9]/g, ''); return numericString; }. This function uses the replace method and the /[^0-9]/g,'' Regular Expression to remove non-numeric characters from the testString variable passed in the parameter list.Save the document and launch your browser. Open the document in your browser.ips & Warnings. 1  This example runs the removeNonNumeric function when the Web page loads. 2  Remove the first three lines of code before that function to stop that from happening. 3  To use the function in production, call the function and pass it a string containing text.
LEFT() returns the first X characters in a string, based on the amount of characters you specify. Like: LEFT(text,num_chars). Say you want to remove the last 3 characters from a string in cell A1 you can use: =LEFT(A1,LEN(A1)-3). Or more generally: =LEFT(A1,LEN(A1)-[number of characters to remove]).ay for example that in cell A1 you have a string âIncomeMAXâ and you want to remove the last three characters (âMAXâ): 1  First, LEN(A1) returns how long the string in cell A1 is: 8 characters.