As mentioned you can’t call substr() with a std::ifstream. What you probably meant was to take the parts from the line string read in a[i]= stoi(line.substr(4,2)); name[i]= line.substr(18,15); b[i]= stoi(line.substr(36,1)); Also note you’ll need to convert the substrings extracted to a number (instead of assigning them directly), hence I have added the stoi(). As also … Read more
Both source and chars are pointers to string literals, you can’t modify a string literal, as per the language rules, the behavior of a program where this is done is undefined. source must be declared as a char array: char source[] = “hello, people.”; This way a copy of the string is stored in the … Read more
Using substr: declare l_start number := DBMS_UTILITY.get_cpu_time; begin for i in ( with t as ( select ‘Chapter ‘ || level || ‘ Unit ‘ || level || ‘ Sect ‘ || level d from dual connect by rownum < 100000 ) select substr(d, 1, instr(d, ‘ ‘, 1, 2) – 1) chapter , substr(d, … Read more
Adjust your syntax to: SELECT tableA.something FROM tableA LEFT JOIN table on tableA.name = substr(table.title, LENGTH(table.title)-8) table.title is an argument to the LENGTH() function. Also needs to be argument to SUBSTR(). 4 solved oracle sql about table.substr
$string = current(explode(‘*’, ‘something*10’)); As found here : REF Running Example : IDEONE 0 solved remove part of string after a special character
This is what those functions do exactly: substr() is used to generate a sub-string of specified length from another string. strlen() will return the length of the provided string. Code substr($query,0,strlen($query)-2) removes comma and space from foreach Loop. solved What is the purpose of strlen($query)-2;