Questions tagged [concatenation]

1

votes
2

answer
288

Views

ConcatRelated() - query or tables

I have similar issue to this question Combine values from related rows into a single concatenated string value. I've got two queries: This is what it looks like now without ConcatRelated(): I need to get return: I tried to use this SQL: SELECT DISTINCT Q_Fakt1.FakturaID, Q_Fakt1.DatumVystavenia, Q_F...
Miroslav Daniš
1

votes
1

answer
23

Views

In excel can anyone show me how to concatenate strings and variables to make a cell reference?

If I manually reference a cell in another spreadsheet (by typing = in the destination cell and then clicking in the source spreadsheet), excel creates a formula like this: ='H:\excel\data\[source_file.xls]Sheet1'!$C$5 I am wanting to create that formula from the cell and path which are stored in cel...
Mike Avison
1

votes
0

answer
111

Views

PasswordDeriveBytes.GetBytes(), Algorithm for Multiple Calls

I am interested in the algorithm of the PasswordDeriveBytes class for educational purposes which, as far as I'm concerned, uses the old PKBKDF1 function. I have read the algorithm in the following answer-post: What is the algorithm behind PasswordDeriveBytes? Since it uses the SHA-1 hash algorithm,...
Hello World
1

votes
0

answer
136

Views

Retrieving labels when concatenating in a Wikidata SPARQL query

I am having an issue when concatenating in SPARQL using the Wikidata Query Service. https://query.wikidata.org/ What I want to do is retrieve all persons with a GTAA ID (?q wdt:P1741 ?GTAA_ID.) and specifically persons who have an occupation listed in Wikidata. (?q wdt:P106 ?occupation.) Furthermor...
John
1

votes
1

answer
25

Views

Excel Dynamic Hyperkink using Cell Value as part of Address

I have a column of part numbers which I would like to associate with a column of links to their corresponding autocad drawings. The drawings are on a server, I would like to be able to insert the part number into the file path. My attempt: =HYPERLINK(\\servername\folderofparts\partprefix\['Lists fo...
JTaylor
1

votes
0

answer
278

Views

In C# How to concatenate values with strings in RDLC IIf expression?

I have an RDLC Report file in which I want to make an expression. I want to use IIf function here... =IIf(First(Fields!due.Value, 'DataSet1') = 0 ,'FULL PAID','DUE TK ='+First(Fields!due.Value, 'DataSet1')+'.00') When the condition is true it shows FULL PAID but when False it Shows #Error It seems...
Shovon Das
1

votes
1

answer
33

Views

Concatenate different dataframes into one with for loop

I want to concatenate different financial dataframes into one. So when doing this for 2-3 stocks manually I do: #getting dataframe from .csv file df1 = pd.read_csv('C:\\Users\\Enric\\Desktop\\python\\tickers\\MSFT.csv',index_col=None, header=0) df2 = pd.read_csv('C:\\Users\\Enric\\Desktop\\python\\t...
Run The Jewels
1

votes
1

answer
40

Views

Concatenating 2 columns

Good day, Looking for help if my concatenating code. I am trying to concatenate Column E & G in sheet1, into column B in sheet2. There is already data on sheet2, so I am trying to get it to copy the data onto the last row of sheet 2. It is only concatenating the last Row in sheet 1, and not being...
Chris
1

votes
1

answer
31

Views

Diagonalise and concatenate every row of a matrix [duplicate]

This question already has an answer here: How to convert matrix to a stack of diagonal matrices based on every row? 5 answers Given a matrix: A = [1 2 3 4 5 6 7 8 9] How to diagonalize each row of A and concatenate them simultaneously, so it yields the following? 1 0 0 4 0 0 7 0 0 0 2 0 0 5 0 0 8...
vaitas
1

votes
1

answer
41

Views

Store Procedure hit SQL Statement Ignored

create or replace PROCEDURE GEN_STATEMENT_SP(indexNM IN VARCHAR2, tableNM IN VARCHAR2) AS BEGIN DECLARE uniqueSTMT VARCHAR2(30); nonUniqueSTMT VARCHAR2(30); charOn VARCHAR2(5); tempfld VARCHAR2(500) ; CURSOR chkTyp IS(SELECT ES_UNIQUENESS from sys.dba_ind_columns where INDEX_NAME = indexNM and TAB...
GTeckHan Goh
1

votes
3

answer
46

Views

Moving Multiple Rows to Columns with a Concate Situation

I have probably what would be considered a simple question - I need to move multiple rows into a single row, based on concate of member IDs and date. What I have is a table that may look like this: Row Member ID Create Date Answer 1 1234 20170101 20170101 2 1234...
user9539580
1

votes
0

answer
52

Views

concatenate a list of form fields and mixed text content inside another form field

I am using the following web app, ESRI GeoForm, and attempting to customize it for concatenation purposes. It is a private, internal to our organization only, form. So I can't share the form I am using other than through video or images. So basically, when the users enter 'Address Number' and 'Addre...
randomblink
1

votes
1

answer
89

Views

String concatenation in Excel VBA failing with run-time error

Why does: sDesktopPath = Environ('USERPROFILE') & '\Desktop\' sTimeStamp = Format(Now(), 'yyyymmdd-hh:nn') sSuffix = '_1Sheet_' & sDateTimeNow ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ sDesktopPath & ActiveSheet.Range('E3').Value & '_1Sheet_' & '.pdf' _ , Quality:=xlQualityStanda...
Fat Monk
1

votes
1

answer
34

Views

Paste columns in separate file with save() in R

I am using a for loop to impute values per column, and want to save these columns with the predictions to another file. So, that the columns are pasted in there one by one. However, my code throws an error and it is not working. This is the part of the code: for (column in 1:ncol(NB_mcar)) { # Impu...
MLnewby
1

votes
1

answer
105

Views

Cell with text, formula and conditional formatting.

I'm looking to see if you can add data to a cell, with a sum, and conditional formatting. An example. A1 A2   100 120 (+20)     I want cell A2 to show a new value (120) with the difference (+20) but also to have conditional formatting as in if the 120 in A2 is greater than the 100 in A1 th...
AJames
1

votes
1

answer
20

Views

Concatenate multiple directories name adding a counter in bash

I have to store the last 5 test results folders. Every time the tests are executed, a folder called 'target' is created with all the results. The idea is to move that folder and add a counter (Ex.: target1, target2, ...). And store the last 5 executions. It is important that when 5 folders exists an...
Diego S. Delgado
1

votes
6

answer
150

Views

Concatenate a two dimensional array

I'm new and I need help to find the right solution for my function in java function concatenateMatrix(matrix) {} var stringMatrix = [ ['H', 'e', 'l', 'l', 'o'], [' ', 'J', 'a', 'v', 'a'], ['W', 'o', 'r', 'l', 'd', '!'] ]; var matrix = ''; newArray = []; for (var i = 0; i < stringMatrix.length; i++)...
TR54296
1

votes
0

answer
52

Views

Python: concatenate string from file with string literal

I'm trying to concatenate a string pulled from a file with a string literal and getting an error. Example: file.txt: string1 string2 string3 program.py: import random f = open('file.txt', 'r') alist = f.readlines() f.close() anotherlist = ['word1', 'word2'] astring = random.choice(alist) + ' ' + ran...
BabaSvoloch
1

votes
0

answer
26

Views

Should I split long string for coding style vs lower performance of concatenating strings Java

Based on the google style doc (https://google.github.io/styleguide/javaguide.html), it is recommended to limit a line to at most 100 column long. However, I have to declare some strings as description which can be 300 characters long. In order to fit in 100 characters each line, The string needs to...
Lazyworm
1

votes
2

answer
110

Views

Concatenate multiple tags from a .xml file using JAVA

I want to concatenate multiple tag values from a xml file using JAVA. The .xml looks like this: row 1 row 2 row 3 Frist Test row 20 row 10 row 30 Second Test And the result should be like this: row 1 row 2 row 3 row 10 row 20 row 30 There should be 2 variables. I've tried: NodeList nodeList...
Adelina Plesa
1

votes
0

answer
42

Views

How do you use table data in an alias for a select statement?

I'd like to reference data from a record in the name that I give the column that a SELECT query returns. I've tried this, but it's not liking the extra SELECT that I'm trying to concatenate into the alias: SELECT Table1.Field1 AS 'Pick any ' & CAST((SELECT Table2.Field1 FROM Table2 WHERE Table2.ID...
Isaac Reefman
1

votes
1

answer
134

Views

In Python Pandas Can't add new column after datetime column

I cannot concatenate new columns to existing Pandas DataFrame if the last column of the existing DataFrame is in the type of datetime. Here is a minimal example: import pandas as pd import numpy as np dates = [pd.Timestamp('2012-05-01'), pd.Timestamp('2012-05-02'), pd.Timestamp('2012-05-03')]...
Lin Sen
-5

votes
3

answer
88

Views

What is reason for syntax error of print statement of given python code [closed]

xString = input('Enter a number: ') x = int(xString) yString = input('Enter a second number: ') y = int(yString) print('The sum of ', x, ' and ', y, ' is ', x+y, '.', sep='') on executing above code, interpretor throwing syntax error saying syntax error as below. print(?The sum of ?, x, ? and ?, y,...
Srikanth P S
1

votes
2

answer
88

Views

How to concatenate a column value based on another column value in excel?

I have sheet like this : How can I concatenate values in column B based on value in column A. Values corresponding to ID 1.1.1 are of B2:B5 Similarly, values for ID 1.1.2 are of B6:B8 and so on.. Its like it start from first id, lookup until next id, all values in column B until next Id in column A...
qwww
1

votes
0

answer
23

Views

Exclude hidden input value from displaying after search performed

I am using javascript to concatenate strings to omit products from search results in shopify. I'm wondering if there is a way to prevent my hidden input value from displaying in the input after the search is performed? Something like value='{{ search.terms | escape }} -= q'? Thanks in advance for yo...
mwalker
1

votes
1

answer
38

Views

XSLT: Concatenation of looping list items separated by pipe symbol

I am trying to build an XML output using XSLT templating The XML has multiple Group GroupName='PersonalSocialMedia' items in which each item do have multiple group items. My input XML looks like this : 2 2 Instagram Iuname 1 1 Facebook fname 3 3 LinkedIn testname1 2 4 Twitter testname2 1 1 Fa...
Shanker
1

votes
2

answer
121

Views

How to write a prolog predicate to trim first N elements from a List using conc (concatenation) operation

trim(L1,N,L2) which is true if L2 contains the first N elements of L1 I'm required to write the prolog code using the relation conc. Im new to prolog, so i have issue with my code. Can somebody correct me? trim(L1, N, L2):- conc(L2,T,L1), length(L2,N),length(L1,N2), N2>= N Most people have written...
1

votes
1

answer
60

Views

How to Concatenate two dataframes in impala

I'm looking for the synthax to concatenate two dataframes in IMPALA. I want to avoid that operation in R because i have to import the dataframes in R. Thank you for your help !
Antoine F
0

votes
0

answer
8

Views

Want to concatenate elements of array into single element

I have an array of arrays that looks like time array([array([ 0, 1, 0, 10, 12, 2011], dtype=int16), array([ 0, 1, 0, 10, 12, 2011], dtype=int16), array([ 0, 1, 0, 10, 12, 2011], dtype=int16), ..., array([ 0, 59, 23, 10, 12, 2011], dtype=int16), array([...
Jack
1

votes
1

answer
57

Views

Use array formulas to concatenate two independent sheets

I have two Google Sheets with identical layouts that are filled in by independent teams: Sheet 1: team1_entry1 243 team1_entry2 546 etc ... XXX Sheet 2: team2_entry1 166 team2_entry2 888 ... XXX I need to see the data from both sheets in one table, which I can then filter and sort using Filter View...
a1s2d3f4
1

votes
1

answer
51

Views

C Programming: ls function sort by file, executable and directory

I have been able to sort it by 'File' and 'Directory' so far, but I don't know how to check whether it is 'Executable.' I was thinking of concatenating my CWD with '/' and d_name and store it into a variable, and check it with access().But I have no idea how. #include #include #include #include #inc...
Jerome Jaghoy
1

votes
2

answer
173

Views

Sqlite3 conversion MM/DD/YY string to YYYY-MM-DD

I am trying to convert a string column of existing values from 'MM/DD/YY' to 'YYYY/MM/DD'. Example Data: Table: backlog_backlogData [LoadDate] 06/29/18 06/29/18 06/28/18 07/24/18 07/24/18 I have tried this (in SQLite Manager FireFox extention): UPDATE backlog_backlogData SET LoadDate = substr(Loa...
Prouderthings
1

votes
0

answer
41

Views

Concatenate two dataframes and write back to xlsx file

Currently I have code that allows me to read a text file and and xlsx file (openxlsx package) within a forloop. What I am trying to do is add the columns together and output the file as an xlsx, overwriting the original xlsx file. I want to do that within a forloop so that each file gets overwritten...
Darwin Chang
1

votes
1

answer
26

Views

HTML String on Object Property Won't Update

I have an object constructor that sets some properties, and later uses them to concatenate a string to write to the DOM. I can see that this works in some cases, but not in others. function Fighter(name, level, attackPts, defencePts, imgSource) { // TRUNCATED PROPERTY ASSIGNMENTS AREA: this.attackPt...
Kevin Hyde
1

votes
1

answer
331

Views

How to solve: Error using horzcat Dimensions of matrices being concatenated are not consistent

Everything is fine in the concatenation step. When I am saving these variables (each variable has size 30x180) and I am labeling it in the Labeling step, I got this error, help with this? What I want is to add the label number to each row of the feature matrix Class1. Error using horzcat Dimensions...
Muhammad Kashif
1

votes
1

answer
143

Views

Oracle : large Number getting converted scientific notation (40 digits) on concatenation

Oracle converts Number to string on concatenation or moving it to_char. Example: select value from tab; value 9076725748515642018090620180906173606980000000000000000000000000000000000000000 select RPAD(value,LENGTH(value)+1,chr(135)) from tab; RPAD(value,LENGTH(value)+1,chr(135)) 9.07672574851564201...
Divye Kapoor
1

votes
0

answer
160

Views

How do I pack multiple images to one image or numpy array in python?

I have a 3d image and try to predict their slice outputs by using neural networks. The problem is that, after prediction, I would like to find a way to pack them back. I have an idea that uses grid method, however, I am not sure it is the best way to do it. fig=plt.figure(figsize=(20, 20)) colum...
Vural Erdogan
1

votes
0

answer
17

Views

minifyEnabled and string concatenation

I have the following in my codestringOne + '_' + stringTwo. It works fine in debug mode, but as soon as I release the apk (minfiy is enabled) I will have the following: stringOnedstringTwo. Please mind the d char in the middle instead of _. If I replace the string concatenation stringOne + '_' + str...
Karoly
1

votes
1

answer
23

Views

Concatenating a portion of each line of a file using BASH commands

BASH version in use: echo $BASH_VERSION 4.4.19(1)-release I am using the following plumbing to extract all banned IP addresses from a fail2ban log file: cat /var/www/html/fail2ban.log | grep Ban | cut -d ']' -f3 | cut -d 'r' -f2 | cut -d 'e' -f2 | cut -d ' ' -f3 | uq | sort -n > /var/www/html/fail2b...
TangoPlease
1

votes
2

answer
58

Views

Dump connected drives serials and users

I need to list users of a connected drive and it's serial # in an output file. I'll be connecting between 12-24 drives in arrays at a time. I would like to be able to put the assigned drive letters into a variable. And then have the entire script loop for each connected drive. dumping serial + linki...
Jon Dunbar

View additional questions