string <- "this is a funny cat" I want to replace the first 15 characters of string with ‘orange`. The desired output is ‘orange cat’ However, using substr gives me substr(string, 1, 15) <- "orange" > string [1] "oranges a funny cat" which is not the desired output. >Solution : The output of substr should… Read More How to replace a string defined by starting and ending index by another string in R?

I have a table which looks like this: Category Name T – 1029 – PHONE sjss T-2629172-LAPTOP ssus T-26124-PC udia T-22 T – 1029 – PHONE I am using this statement to update the ‘Name’ column in my table by getting the entire string after the second dash: update tech_table set name = SUBSTR(Category, INSTR(Category,… Read More how to remove spaces in front of updated values for column in sql?

I have a dataset which looks something like this: Category Name T-1029-PHONE sjss T-2629172-LAPTOP ssus T-26124-PC udia T-22 T-1029-PHONE T-1029 I want to update the ‘Name’ column by getting the last part of the ‘Category’ value string after the second ‘-‘ to get the table to look something like this: Category Name T-1029-PHONE PHONE T-2629172-LAPTOP… Read More How to use 'case when' and 'substr' to update a column in oracle sql?

I have sequence date: names<-format(seq.Date(as.Date("2012-11-01"),as.Date("2012-12-01"), by = ‘months’),format = "%Y%m") How can I get the last two digit, like the result for last two digits of names[1] is 11? >Solution : Using the stringr package you can just put stringr::str_sub(string = names, start = -2, end = -1)

I am working on a coding problem in which I have to delete all occurrences of a substring T in a string S (keeping in mind that removing one occurrence of T in S may generate a new occurrence of T), and then to return the resulting string S after all deletions. The size of… Read More Why is string::resize and string::substr O(1)

I want to get the first letters of a string, but every time its giving me a empty result. The string is following. 080521234567890 Here is my code: <?php if ($_GET[‘test1’]) { echo "<table border =0>"; $parsing = "080521234567890"; echo "<tr>"; if ($p1 = substr($parsing,0,1)) { echo "<td><strong>Version Format n1</strong></td>"; echo "<td>: $p1</td"; } echo… Read More PHP: Substr() returns empty string

I have the following code: #include <iostream> #include <fstream> #include <string> using namespace std; int main() { fstream file; string s; //file contains the following //id="123456789" //Note: There is no spaces at the end file.open("test.txt", ios::in); getline(file, s); s = s.substr(s.find("\"")+1, s.length()-1); cout << s << endl; return 0; } The results print: 123456789" Why… Read More C++ substring not giving me the correct result