How to combine two lines in to one line

[Ragala]

Hi All,

I have a an input string value as mentioned below

XXXX-XXX-1234
Sachin R Tendulkar
XXXX-XXX-0987
Suresh K Raina
XXXX-XXX-4567
Virender K Sehwag

I want the output value as

XXXX-XXX-1234 Sachin R Tendulkar
XXXX-XXX-0987 Suresh K Raina
XXXX-XXX-4567 Virender K Sehwag

Could you please help me with this.

Thanks,
Ragala.

[Parvathy (PS Parvathy)]

Hi @Ragala

=> Assign activity

Input = "XXXX-XXX-1234
Sachin R Tendulkar
XXXX-XXX-0987
Suresh K Raina
XXXX-XXX-4567
Virender K Sehwag"

=> Use below Regex Pattern in Find Matching Patterns Activity:

Pattern: "[A-Z].*[\s\S]*?[A-Za-z].*"
Pattern Options: Compiled
Text to Search in: Input
Result: Matches

=> Use For Each loop

For Each currentMatch in Matches
   WriteLine -> currentMatch.ToString.ReplaceLineEndings(" ")
End For Each

Hope it helps!!

[Ragala]

@Ragala

XXXX-XXX-4567 Virender K Sehwag

Hi @Parvathy
Thanks for your effort. After performing the actions as you said
The Final output value is coming as

XXXX-XXX-4567 Virender K Sehwag

But my final out put should be all three names along with their number

Thanks.

[lrtetala (Lakshman Reddy)]

Hi @Ragala

Can you try the below

String.Join(Environment.NewLine, System.Text.RegularExpressions.Regex.Matches(Input, "(XXXX-XXX-\d{4})\r?\n([^\r\n]+)").Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) m.Groups(1).Value + " " + m.Groups(2).Value))

Regards,

[lrtetala (Lakshman Reddy)]

@Ragala

Another way

System.Text.RegularExpressions.Regex.Replace(Input, "(XXXX-XXX-\d{4})\r?\n([^\r\n]+)", "$1 $2")

Regards,

[Parvathy (PS Parvathy)]

Hi @Ragala

Below syntax should help you.

Input = "XXXX-XXX-1234
         Sachin R Tendulkar
         XXXX-XXX-0987
         Suresh K Raina
         XXXX-XXX-4567
         Virender K Sehwag"

Output = String.Join(Environment.NewLine, System.Text.RegularExpressions.Regex.Matches(Input, "[A-Z].*[\s\S]*?[A-Za-z].*").Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) m.Value.ReplaceLineEndings(" ")))

Let me know if you have any queries. I will help you.

Regards

[Ragala]

Thanks @Parvathy it is working

[Ragala]

Thanks @lrtetala Bro. It is working

[Parvathy (PS Parvathy)]

Hi @Ragala

Glad to have helped.

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 found…

Regards

[Ragala]

Hi @Parvathy sorry to bother you. But I am pretty much impressed with the expression you gave. Does that expression came instantly from your mind or have you done any R&D for that. If yes can you please send me the source link how to get those expressions. Hope you don’t mind.

Thanks

[Parvathy (PS Parvathy)]

Hi @Ragala

You can follow below videos

The regular expressions are written in below website. It is purely on pur requirement how we want the output.

RegExr: Learn, Build, & Test RegEx

For Linq you can follow below videos

If perfect, please close the topic by marking my post as solution.

Regards