• Creating a list in one Excel cell by referencing several other cells

    Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...

    Adventuredev55 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • SYNON built in function *CONCAT

    I need to combine several fields into one text field and thinking about using *CONCAT for that. However it seems that *CONCAT can only merge two fields at a time. If so it would mean a lot of code if I have ten fields to merge. Am I understanding this correctly? Thanks for any help! Lars Holmberg...

    Larsholmberg5 pointsBadges:
  • Determining which concatenated dataset is being processed by a COBOL program

    I'd like to determine which dataset in a group of concatenated datasets is currently being processed. I have multiple datasets going through an edit process (COBOL) on a mainframe and when I find an error I'd like to list the DSN the record is in. 

    Jfruehwirth5 pointsBadges:
  • How can I concatenate files for transfer from the iseries

    I have 3 files with a common layout in a common library on the i5. The source files (query results) have different definitions so I am unable to append the result of query2 to query1. So what I want is to perform a UNION or concatenate them into a single download file. I have tried a UNION but...

    Mgaylard5 pointsBadges:
  • SQL concatenate results

    Hi Need help here:-  I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS,...

    devan390 pointsBadges:
  • How to concat SQL Server 2005 data with line feed

    I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The script I...

    TLMercer45 pointsBadges:
  • Times spanning midnight in RPG/400 concatenation

    I have successfully converted time field to date/time. Now I need to find the total minutes between one field and another but cannot get it to show me any value. I am using DateDiff ('n',{@startdatetune}, {@startdatetime}) where n indicates minutes. I should be able to use any field where I have...

    UVADebbie5 pointsBadges:
  • Inserting Hex values into Excel

    Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex "4F". The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. Ive used HEX2DEC and its...

    Marsh218335 pointsBadges:
  • Total Balance for Concatenated Unique ID in Access and Excel

    Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it...

    Roballen885 pointsBadges:
  • Concatenate many *CHAR variables.

    Is it possible to Concatenate many *CHAR variable in one same type variable. I've created a CL who will read records from one file and concatenate them in one varaible which i will use after in my CL. But after exiting the loop i got a varaible with the last record value so the concatenation...

    junioras400250 pointsBadges:
  • Dummying a dataset with a concatenated list of datasets

    I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the dataset you wish to process need to be...

    Jaharvis15 pointsBadges:
  • MySQLi and PHP problem with code

    Can someone please tell me what I'm doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . 'areaCode' 'prefix' and 'lineNumber' are all...

    PatOswalt115 pointsBadges:
  • Control Cards for NDM from Server to JCL

    How can we concatenate the file name to read from Server in  NDM &SDD='&INDD1 || _ || &DATE || . || &ATTB'  -

    Mm026015 pointsBadges:
  • How do I prevent from losing the first position of a non “0″ field?

    How do I prevent from losing the 1st position of non "0" field, using this logic: WHERE concat(TRN@DS, concat(substring(concat('00',TRNYDS),2,2), concat(substring(concat('00',TRNMDS),2,2), substring(concat('00',TRNDDS),2,2)))) between

    BGramby15 pointsBadges:
  • Concatenation

    I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?

    BGramby15 pointsBadges:
  • How to convert VBA decimal DataTypes

    I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300...

    McNitro255 pointsBadges:
  • concatenating rows of a column in oracle 9i sql

    how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

    Chrishram15 pointsBadges:
  • Concatenating two note fields into one, but need them to be on their own line

    sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?

    Macsterling5 pointsBadges:
  • validation

    i need to concatinate two fields and send to resultant field in rpg/400. one is numeric and other one is character. so please advice how can i

    Askt1140 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following