<?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: Split text by length in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Split-text-by-length/m-p/58183#M12069</link>
    <description>Hi Dilip - sorry for the late response. You can try several calc states where you do regular expressions to obtain right(text, length) several times.You will need some interim stages where you trim the text and keep going until you finish with the input data. Or, you can also use a loop (or more) to cycle through the source data. See if this works and good luck!&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Alexander Marlowe&lt;BR /&gt;Blue Prism&lt;BR /&gt;Blue Prism&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
    <pubDate>Fri, 31 Jul 2020 22:22:00 GMT</pubDate>
    <dc:creator>AlexanderMarlow</dc:creator>
    <dc:date>2020-07-31T22:22:00Z</dc:date>
    <item>
      <title>Split text by length</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Split-text-by-length/m-p/58182#M12068</link>
      <description>Hi Team,&lt;BR /&gt;&lt;BR /&gt;I am trying to split the text based upon some certain count(lets assume as 5)&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Input parameter:&lt;BR /&gt;&lt;BR /&gt;The input [test]: 36444 &amp;nbsp; &amp;nbsp;&amp;nbsp; 36481 &amp;nbsp; &amp;nbsp;&amp;nbsp; 3650136588 &amp;nbsp; &amp;nbsp;&amp;nbsp; 36601 (Please note there are some spaces in between)&lt;BR /&gt;&lt;BR /&gt;Maximum Line Length: 5&lt;BR /&gt;&lt;BR /&gt;outpu &lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;parameter&lt;/SPAN&gt;t:&lt;BR /&gt;Split Lines : collection&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;Outcome is :&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;Empty spaces are not considered. It is considering only the values in it.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;1)&lt;/SPAN&gt;&lt;SPAN style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; cursor: text; display: inline; float: none; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;36444&lt;/SPAN&gt;&lt;BR style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;" /&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;2)&lt;/SPAN&gt;&lt;SPAN style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; cursor: text; display: inline; float: none; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;36481&lt;BR style="box-sizing: border-box;" /&gt;3)36501&lt;BR style="box-sizing: border-box;" /&gt;4)36588&lt;BR style="box-sizing: border-box;" /&gt;5)&lt;/SPAN&gt;&lt;SPAN style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; cursor: text; display: inline; float: none; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;36601&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BR style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;" /&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;Expectation is : Empty spaces should also be considered in output collection&lt;/SPAN&gt;&lt;BR style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;" /&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;1)&lt;/SPAN&gt;&lt;SPAN style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; cursor: text; display: inline; float: none; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;36444&lt;/SPAN&gt;&lt;BR style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;" /&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;2)&lt;/SPAN&gt;&lt;BR style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;" /&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #7a7a7a; cursor: text; font-family: 'Helvetica Neue',Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;3)&lt;/SPAN&gt;&lt;SPAN style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; cursor: text; display: inline; float: none; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;36481&lt;BR style="box-sizing: border-box;" /&gt;4)&lt;BR style="box-sizing: border-box;" /&gt;5)36501&lt;BR style="box-sizing: border-box;" /&gt;6)36588&lt;BR style="box-sizing: border-box;" /&gt;7)&lt;BR style="box-sizing: border-box;" /&gt;&lt;span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:"&gt;😎&lt;/span&gt;&lt;/SPAN&gt;&lt;SPAN style="background-color: transparent; box-sizing: border-box; color: #7a7a7a; cursor: text; display: inline; float: none; font-family: &amp;amp;quot; helvetica neue&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;36601&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;Do we have any way to overcome this?&lt;BR /&gt;&lt;BR /&gt;Thank you!&lt;BR /&gt;&lt;BR /&gt;Regards,&lt;BR /&gt;Dilip K&lt;BR /&gt;&lt;BR /&gt;</description>
      <pubDate>Mon, 30 Dec 2019 16:27:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Split-text-by-length/m-p/58182#M12068</guid>
      <dc:creator>DilipK</dc:creator>
      <dc:date>2019-12-30T16:27:00Z</dc:date>
    </item>
    <item>
      <title>RE: Split text by length</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Split-text-by-length/m-p/58183#M12069</link>
      <description>Hi Dilip - sorry for the late response. You can try several calc states where you do regular expressions to obtain right(text, length) several times.You will need some interim stages where you trim the text and keep going until you finish with the input data. Or, you can also use a loop (or more) to cycle through the source data. See if this works and good luck!&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Alexander Marlowe&lt;BR /&gt;Blue Prism&lt;BR /&gt;Blue Prism&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Fri, 31 Jul 2020 22:22:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Split-text-by-length/m-p/58183#M12069</guid>
      <dc:creator>AlexanderMarlow</dc:creator>
      <dc:date>2020-07-31T22:22:00Z</dc:date>
    </item>
  </channel>
</rss>

