How to split string based on special character

[ranaprathap928 (Rana reddy)]

Hi guys i’m facing a issue of splitting the name based on special character.

Ex: 1) Ram kumar & rajesh & raja reddy
2)10-01-2021 & 15-01-2021

o/p : 1) Ram kumar
rajesh
raja reddy

2. 10-01-2021
   15-01-2021

I want this type of output . Can anyone help me how to solve this

[1996 (Neelima G)]

Hi @ranaprathap928,

Check this below link

Regex Expression with different format of string

Hi Team, I need to get specific word from lines of mail body. Here, I am able to check every line from body of mail,but i need to get exact word from string.Kindly help me. case 1: How to get Lavanya from the string User name - Lavanya case : 2 How to get Bindu from the string User Id : Bindu case :3 How to get Kiran from the string Vdi Id “Kiran” case: 4 How to get Saikumar from the string Please change password user name : Saikumar and Let me Known Please change password user name …

And also you can use split function similar way can able to exact value using special character
Yourvariable.split("&",TocharArray)(0)

[Shikhar_Tandon]

Hi @ranaprathap928,

Here is a quick xaml example for you that how can you achieve this resultSplitExample.xaml (8.7 KB)

Cheers !

[nv08 (Nilay Varshney)]

array1=str.split("&"c).ToArray
string.Join(vbCr,array1)

[ppr (Peter)]

@ranaprathap928

with the menitioned statements the Array items maybe still need to get trimmed

following statement is doing it in one go:

YourStringVar.Split("&"c).Select(Function (x) x.Trim).toArray

or also removing empty split results on same time:
YourStringVar.Split({"&"}, StringSplitOptions.RemoveEmptyEntries).Select(Function (x) x.Trim).toArray

[ranaprathap928 (Rana reddy)]

Thanks @Shikhar_Tandon it’s working

[Cristian_Negulescu]

Hello Rana,
In this video I do a lot of stuff with String and DateTime:

UiPath Tutorial for String and DateTime | Substring | Split | Trim | Compare | Convert | Use-cases

0:35 Examples for Substring functions
4:10 IndexOf and LastIndexOf
5:00 SubString working together IndexOf and LastIndexOf
6:45 Split string by character
8:50 Split string by string
12:00 Lower Case and Upper Case
12:45 Trim
15:05 Compare strings in multiple ways
19:05 Resume of all the String function part
20:05 DateTime to string in multiple ways
23:00 AddDays get DayofWeek
25:40 Convert from String to DateTime
26:20 Compare DateTime

Thanks,
Cristian Negulescu