Problem in split a text into an Array

[Islam_ISmail]

Hi Everyone, I hope you doing well!

I am facing a challenge while trying to split a variable named ‘StrExctractedText’ into an Array by splitting it with a newLine delimiter

that contains the following text:

I tried to use the split function but the result after Looping inside the Array is a single-element array instead of three elements as expected. as you see here:

After several tries, I changed the way to Regex, here:

and the output is a 5 Elements array instead of three elements also

Can anyone provide guidance on how to correctly split the ‘StrExctractedText’ variable into an array where each line is a separate element?

[ppr (Peter Preuss)]

give a try at trimming
Assign Activity:
arrSplits | String Array =

YourTextVar.Split({Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Select(Function (x) x.Trim())

You can prototype it within the immediate panel as well

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

[Yoichi]

Hi,

Another approach:

It may be linebreak matter. Can you try the following expression?

StrExctractedText.Split(vbcrlf.ToCharArray,StringSplitOptions.RemoveEmptyEntries)

If you need to trim each item, @ppr 's LINQ expression will help you.

Regards,

[Parvathy (PS Parvathy)]

Hi @Islam_ISmail

Try the below following way:

StrExctractedText= "Client ID: BL17488
                    Client Name: Mabel Suttle
                    Client Country: Romania"

arrDetails= StrExctractedText.Split({Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries)

Hope it helps!!

[Rohan_Ashok_Gaikwad]

SplitAndTrim.zip (2.7 KB)

Use this Workflow

[postwick (Paul Ostwick)]

Use Split(yourstring,delimiter) instead of yourstring.Split because the former accepts a string instead of character array.

[Islam_ISmail]

Thank you for your response that helps me!

[ppr (Peter Preuss)]

@Islam_ISmail
Perfect, so the topic can be closed

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

[Islam_ISmail]

Thank you for your response I’ll try this out !

[Islam_ISmail]

Thank you for helping me out !!