Here’s a solution using awk awk -F ‘;’ ‘{same=1; for (i=3;i<NF;i++) { if ($i != $2) { same=0 } }; if (same == 1) {print $0}}’ file Here’s how it works ‘{ same=1; #assume all fields are the same for (i=3;i<NF;i++) { #for each field after the second if ($i != $2) { same=0 } … Read more
I don’t know about sed or R, but in Python: >>> import re >>> i = “””NOTE: Variable Variable_S1 already exists on file D1.D, using Var_S8 instead. NOTE: The variable name more_than_eight_letters_m has been truncated to ratio_s. NOTE: Variable ratio_s already exists on file D1.D, using Var_S9 instead.””” >>> print(re.findall(r'(\w+_\w+)’, i)) [‘Variable_S1’, ‘Var_S8’, ‘more_than_eight_letters_m’, ‘ratio_s’, … Read more
You should have been more clearer when you raise the problem. Do not add test cases later You can try this, I have modified the third field to last but one. But credit to @Kaz ~> more test SER1828-ZXC-A1-10002 SER1878-IOP-B1-98989 SER1930-QWE-A2-10301 SER1930-QWE-A2-10301 SER1930-QWS_GH-A2-10301 SER1930-REM_PH-A2-10301 SER1930-REM-SEW-PH-A2-10301 SER1940-REM-SPD-PL-D3-10301 ~> awk -F- ‘BEGIN { OFS=”-” } { sub(/[0-9]/,””,$(NF-1)); … Read more
awk -F ‘|’ -v ‘OFS=|’ ‘{$13 = $16; NF -= 3; print}’ file or perl -F’\|’ -ne ‘splice(@F, 12, 3); print join(“|”, @F)’ file 1 solved How to match and remove a string of characters in a pattern
If you won’t have more than one of the pattern on a single line, I’d probably use sed: sed -n -e ‘s%.*https://\([-.0-9A-Za-z]\{1,\}\.[A-Za-z]\{2,\}\).*%\1%p’ Given the data file: Nothing here Before https://example.com after https://example.com and after Before you get to https://www.example.com And double your https://example.com for fun and happiness https://www.example.com in triplicate https://a.bb and nothing here The … Read more
You didn’t ask for Tcl code, but here’s one way to do it. It could be prettier, but it works. set data { A1 1 2 a1 B1 3 4 b1 C1 5 6 c1 } set ns {} foreach {- a b -} $data { lappend ns $a $b } set a 0 set … Read more
With no sample input, I will just guess and maybe it will help: cat file header for file 1111 header for file 1111 2222 header for file 3333 4444 5555 awk ‘/header/&&c++>0 {next} 1’ file header for file 1111 1111 2222 3333 4444 5555 Though I am not the greatest in sed sed ‘1!{/^header/d;}’ file … Read more
Use rfind to get the location of the last slash then substr to return the right side of the string. Since substr‘s second argument defaults to “the end of the string” you only need to provide the beginning position: #include <string> std::string GetURLFilePath(const std::string& url) { auto last_slash_location = url.rfind(“https://stackoverflow.com/”); if(last_slash_location == std::string::npos || last_slash_location … Read more