<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Concatenate in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036834#M85277</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The CONCATENATE statement combines two or more separate strings into one. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CONCATENATE &amp;lt;c1&amp;gt; ... &amp;lt;cn&amp;gt; INTO &amp;lt;c&amp;gt; [SEPARATED BY &amp;lt;s&amp;gt;].&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This statement concatenates the character fields &amp;lt;c1&amp;gt; to &amp;lt;cn&amp;gt; and assigns the result to &amp;lt;c&amp;gt;. The system ignores spaces at the end of the individual source strings. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The addition SEPARATED BY &amp;lt;s&amp;gt; allows you to specify a character field &amp;lt;s&amp;gt; which is placed in its defined length between the individual fields.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If the result fits into &amp;lt;c&amp;gt;, SY-SUBRC is set to 0. However, if the result has to be truncated, SY-SUBRC is set to 4.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DATA: C1(10) VALUE 'Sum',&lt;/P&gt;&lt;P&gt;C2(3) VALUE 'mer',&lt;/P&gt;&lt;P&gt;C3(5) VALUE 'holi ',&lt;/P&gt;&lt;P&gt;C4(10) VALUE 'day',&lt;/P&gt;&lt;P&gt;C5(30),&lt;/P&gt;&lt;P&gt;SEP(3) VALUE ' - '.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CONCATENATE C1 C2 C3 C4 INTO C5.&lt;/P&gt;&lt;P&gt;WRITE C5.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CONCATENATE C1 C2 C3 C4 INTO C5 SEPARATED BY SEP.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WRITE / C5.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Output: &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Summerholiday&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Sum - mer - holi - day&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In C1 to C5, the trailing blanks are ignored. The separator SEP retains them.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope it helps u.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&amp;amp;Regards,&lt;/P&gt;&lt;P&gt;Ruthra&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 19 Oct 2005 09:03:02 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2005-10-19T09:03:02Z</dc:date>
    <item>
      <title>Concatenate</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036831#M85274</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all&lt;/P&gt;&lt;P&gt;I have to do a CONCATENATE with some string.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The problem is that if one of this is space, this one doesn't appear in concatenated string, but I want it.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;thanks&lt;/P&gt;&lt;P&gt;enzo&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Oct 2005 08:30:34 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036831#M85274</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2005-10-19T08:30:34Z</dc:date>
    </item>
    <item>
      <title>Re: Concatenate</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036832#M85275</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Check the following thread...&lt;/P&gt;&lt;P&gt;&lt;A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="74534"&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Don't forget to reward&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Oct 2005 08:36:55 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036832#M85275</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2005-10-19T08:36:55Z</dc:date>
    </item>
    <item>
      <title>Re: Concatenate</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036833#M85276</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Enzo,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;there is no real good solution, but, if possible, translate the space to e.g. '_', CONCATENATE, and translate it back.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;BTW.: Kernel 7.0 will have a "PRESERVING SPACE" extension for CONCATENATE.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If you find my answer useful, please don't forget the reward.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Juergen&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Oct 2005 08:38:52 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036833#M85276</guid>
      <dc:creator>former_member225448</dc:creator>
      <dc:date>2005-10-19T08:38:52Z</dc:date>
    </item>
    <item>
      <title>Re: Concatenate</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036834#M85277</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The CONCATENATE statement combines two or more separate strings into one. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CONCATENATE &amp;lt;c1&amp;gt; ... &amp;lt;cn&amp;gt; INTO &amp;lt;c&amp;gt; [SEPARATED BY &amp;lt;s&amp;gt;].&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This statement concatenates the character fields &amp;lt;c1&amp;gt; to &amp;lt;cn&amp;gt; and assigns the result to &amp;lt;c&amp;gt;. The system ignores spaces at the end of the individual source strings. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The addition SEPARATED BY &amp;lt;s&amp;gt; allows you to specify a character field &amp;lt;s&amp;gt; which is placed in its defined length between the individual fields.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If the result fits into &amp;lt;c&amp;gt;, SY-SUBRC is set to 0. However, if the result has to be truncated, SY-SUBRC is set to 4.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DATA: C1(10) VALUE 'Sum',&lt;/P&gt;&lt;P&gt;C2(3) VALUE 'mer',&lt;/P&gt;&lt;P&gt;C3(5) VALUE 'holi ',&lt;/P&gt;&lt;P&gt;C4(10) VALUE 'day',&lt;/P&gt;&lt;P&gt;C5(30),&lt;/P&gt;&lt;P&gt;SEP(3) VALUE ' - '.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CONCATENATE C1 C2 C3 C4 INTO C5.&lt;/P&gt;&lt;P&gt;WRITE C5.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;CONCATENATE C1 C2 C3 C4 INTO C5 SEPARATED BY SEP.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WRITE / C5.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Output: &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Summerholiday&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Sum - mer - holi - day&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In C1 to C5, the trailing blanks are ignored. The separator SEP retains them.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope it helps u.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&amp;amp;Regards,&lt;/P&gt;&lt;P&gt;Ruthra&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Oct 2005 09:03:02 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036834#M85277</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2005-10-19T09:03:02Z</dc:date>
    </item>
    <item>
      <title>Re: Concatenate</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036835#M85278</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;EX:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DATA : S1 TYPE STRING VALUE 'ABC 123',&lt;/P&gt;&lt;P&gt;       S2 TYPE STRING VALUE 'DEF 888',&lt;/P&gt;&lt;P&gt;       S3 TYPE STRING VALUE ' '.&lt;/P&gt;&lt;P&gt;      &lt;/P&gt;&lt;P&gt;       CONCATENATE S1 S2 INTO S3 SEPARATED BY ' '.&lt;/P&gt;&lt;P&gt;       WRITE:/ S3.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Oct 2005 09:34:05 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/concatenate/m-p/1036835#M85278</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2005-10-19T09:34:05Z</dc:date>
    </item>
  </channel>
</rss>

