BAQ Concatenate fields

Yahoo Archive
1
How to CONCATENATE Two character fields Together?
 Note for this Example to set the Data type Character and the format to X (100). String (EmpBasic.address) + String (EmpBasic.address2)

From: Greg Payne <gpayne@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, September 11, 2013 9:30 PM
Subject: [Vantage] BAQ Concatenate fields

  
<div id="ygrps-yiv-164367211yiv7058369625ygrp-text">
  
  
  <div>
I am trying to concatenate these two strings into one field for a spreadsheet. Both fields show on the BAQ individually, but when I do a calculated field for them it shows up blank.
 
I got the syntax below from an answerbook, but no luck.
 
Thanks for any suggestions.
 
Greg
 
 
 
string(JobHead.ShortChar09) + string(UDCodes.CodeDesc)

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
</div>


2

I am trying to concatenate these two strings into one field for a spreadsheet. Both fields show on the BAQ individually, but when I do a calculated field for them it shows up blank.

 

I got the syntax below from an answerbook, but no luck.

 

Thanks for any suggestions.

 

Greg

 

 

 

string(JobHead.ShortChar09) + string(UDCodes.CodeDesc)


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
3

Good Day Greg:

 

This worked for me:

 

            PODetail.LineDesc + POHeader.ShipCity + Vendor.Name

 

            Make sure the Calculated field is Text and has 20-30 character length..

 

            You may not need the “String”; also the Command is “” String ( x,y)”””     y may be the format? 

 

 

Sun is on E9 Verion:  9.05.700C – SQL- Unidata - Enterprise-since 10/15/2012

 

 

 

                                                                                                                                                Len

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Wednesday, September 11, 2013 4:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Concatenate fields

 

 

I am trying to concatenate these two strings into one field for a spreadsheet. Both fields show on the BAQ individually, but when I do a calculated field for them it shows up blank.

 

I got the syntax below from an answerbook, but no luck.

 

Thanks for any suggestions.

 

Greg

 

 

 

string(JobHead.ShortChar09) + string(UDCodes.CodeDesc)

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
4

Thank Len

 

I had to do the UDCodes into a calculated field first, then concatenate that with Jobhead and it worked.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Wednesday, September 11, 2013 5:00 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Concatenate fields

 

 

Good Day Greg:

 

This worked for me:

 

            PODetail.LineDesc + POHeader.ShipCity + Vendor.Name

 

            Make sure the Calculated field is Text and has 20-30 character length..

 

            You may not need the “String”; also the Command is “” String ( x,y)”””     y may be the format? 

 

 

Sun is on E9 Verion:  9.05.700C – SQL- Unidata - Enterprise-since 10/15/2012

 

 

 

                                                                                                                                                Len

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Wednesday, September 11, 2013 4:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Concatenate fields

 

 

I am trying to concatenate these two strings into one field for a spreadsheet. Both fields show on the BAQ individually, but when I do a calculated field for them it shows up blank.

 

I got the syntax below from an answerbook, but no luck.

 

Thanks for any suggestions.

 

Greg

 

 

 

string(JobHead.ShortChar09) + string(UDCodes.CodeDesc)

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."