I want to concatenate the strings from different columns in Oracle but some columns have value and others don’t have. What I want is that if the value of the last 3 characters of C1 matches to the first 3 characters of the value of the C2 then concatenate with dash(-) then drop the 2… Read More Capture values from multiple columns and apply trim and replace

I don’t know if this is possible, and I’m pretty new to JavaScript and programing, but here is what I’m trying to do: I have a table in HTML: <table> <tr> <td id="w1t1">kc</td> <td id="w1s1">30</td> </tr> </table> I have an object in JS: const kc = {name: kc, color: "red", score: 0}; I would like… Read More grab text from html and use it and concatenation to access object property

I want a vector with the excel-letters: c(A, B, C, … Z, AA, AB, … AZ, BA, …). My try was this: excel_letters <- LETTERS for(n in length(LETTERS)){ excel_letters <- c(excel_letters, paste0(LETTERS[n], LETTERS)) } Since i am defining excel_letters outside of the loop before iterating through the loop, i expected to get the wanted output.… Read More For loop concatenates only last iteration. Why?

Where is undefined coming from? I thought I initialised the string correctly. (tried using debugger but can’t figure out the issue) I’ve tried using concat() method. I’ve tried +=. Everything results in "undefined" Why? const reverseString = function(string) { let newWord = ""; for (i = string.length; i > -1; i–) { newWord = newWord.concat(string[i]);… Read More Concatenating string using for loop makes it begin with 'undefined'? (javascript)

I’m struggling with a problem in Excel right now with some Amino Acid data. The idea is that i would have a string of AA residues that need to be polymerized (functionally contatenated to themselves) a number of times based on a multiplier. So, if I have a sequence AAGKLY, and I want to polymerize… Read More Concatenate or TextJoin Same Cell Multiple Times based on Value in another Cell?

I have two DataFrames, df1 and df2. In my code I used Pandas.concat method to find the differences between them. df1 = pd.read_excel(latest_file, 0) df2 = pd.read_excel(latest_file, 1) #Reads first and second sheet inside spreadsheet. new_dataframe = pd.concat([df1,df2]).drop_duplicates(keep=False) This works perfectly, however I want to know which rows are coming from df1, and which are… Read More Adding new column to merged DataFrame based on pre-merged DataFrames

I am trying to combine multiple columns from a dataframe into a new column in the same dataframe. Those columns could either have a string value or are Na or NaN. Whenever one column is Na/NaN, I would like these columns to not be included in the final string. E.g. a b c d RESULT… Read More Combine multiple columns as a string in python

I have an Excel spreadsheet in which the date of certain events is stored in three columns: year, month, and day. Year Month Day 1734 04 08 1750 11 10 I set the format of the cell to ‘custom’ so as to show the leading ‘0’ which I want to maintain. I now want to… Read More Contenate while keeping leading zero

I have table , table_A: Transnumber lpost A001 0 A002 1 A003 1 A004 1 A005 0 A006 1 I need to store transnumbers in one variable, with condition lpost=0 In MsSQl Server I can use : SELECT @var1=@var1+’,’+rtrim(table_A.Transnumber) FROM table_A where lpost=0 In MySQL I try : Set @var1=”; Select concat(@var1,’-‘,Transnumber) into @var1 FROM… Read More MySQL concate 1 column from many records

I am trying to concatenate strings for specific groups of customer ids/order dates. I have a dataframe: customerid <- c("A1", "A1", "A2", "A2", "A3", "A3", "A3", "A4") orderdate <- c("2018-09-14", "2018-09-14", "2018-09-15", "2018-09-15", "2020-08-21", "2020-08-21","2020-08-21", "2018-08-10") orderid <- c("1", "2", "3", "4", "5", "6", "7", "8") status <- c("review", "review", "review", "negative", "positive", "review", "review",… Read More Concatenate strings based on value in another column