Menu
I have a PHP variable that looks a bit like this:
$id = "01922312";
I need to replace the last two or three numbers with another character. How can I go about doing this?
EDIT Sorry for the confusion, basically I have the variable above, and after I'm done processing it I'd like for it to look something like this:
$new = "01922xxx";
792
The substr() and strpos() function is used to remove portion of string after certain character.
You can use the JavaScript replace() method to replace the occurrence of any character in a string. However, the replace() will only replace the first occurrence of the specified character. To replace all the occurrence you can use the global ( g ) modifier.
Press the F5 key to run the code. Then you can see all numbers in selected cells are replaced with x as below screenshot shown. Related articles: How to find and replace all blank cells with certain number or text in Excel?
The REPLACE function in Excel allows you to swap one or several characters in a text string with another character or a set of characters. As you see, the Excel REPLACE function has 4 arguments, all of which are required. Old_text - the original text (or a reference to a cell with the original text) in which you want to replace some characters.
Click on cell A5 in the worksheet to enter that cell reference for the Old_text argument; Click on the Start_num line; Type the number 1 - starts the replacement from the first character on the left. Click on the Num_chars line; Type the number 3 on this line - the first three characters will be replaced;
If the number that you type contains more than 15 digits, any digits past the fifteenth digit are changed to zero. Format the number as text to work around this problem. MET150 Last digits are changed to zeros when you type long numbers in cells of Excel - Office | Microsoft Docs Skip to main content This browser is no longer supported.
Try this:
$new = substr($id, 0, -3) . 'xxx';
Result:
01922xxx
194
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
