topic RE: Split text by length in Product Forum

Split text by length

DilipK — Mon, 30 Dec 2019 16:27:00 GMT

Hi Team,

I am trying to split the text based upon some certain count(lets assume as 5)

Input parameter:

The input [test]: 36444 36481 3650136588 36601 (Please note there are some spaces in between)

Maximum Line Length: 5

outpu parametert:
Split Lines : collection

Outcome is :Empty spaces are not considered. It is considering only the values in it.

1)36444
2)36481
3)36501
4)36588
5)36601

Expectation is : Empty spaces should also be considered in output collection
1)36444
2)
3)36481
4)
5)36501
6)36588
7)
😎36601

Do we have any way to overcome this?

Thank you!

Regards,
Dilip K

RE: Split text by length

FredLi1 — Tue, 31 Dec 2019 07:22:00 GMT

Basically, we can leverage the build-in function Left, Right and Len to do string split.

Please check the attachment.

------------------------------
Fred Li
AS
Pacific/Apia
------------------------------

RE: Split text by length

peterlacken — Tue, 31 Dec 2019 11:50:00 GMT

Hi,

try a 'custom escape' - replace all of the spaces with another character before the Split

Replace(text, " ", "-")

then when you have a collection as expected put back the space by replacing the "-" with " ".

peter

------------------------------
PeterLacken
Ren Røros Intelligent Automation
Peter.Lacken@renroros.no
http://www.rria.no
------------------------------

RE: Split text by length

HalilKOC — Thu, 21 May 2020 07:02:00 GMT

Hi Fred,

I have a problem. Can you help me please.

The input
Yıl:2020

Donem:3
Varyant:MAR.2020 DURUS

The Result Collection
Yıl Donem Varyant
2020 3 MAR.2020 DURUS

------------------------------
Halil KOC
------------------------------