How to split name from sentence

Help Studio
, ,
1

trying to split this sentence and i only want the name kimberly Plye . please help with code thx.

New SPEAR Employee Request: Kimberly Pyle – has been updated

2

you can use the below method
sentenceVariable.Split(":“c)(1).Trim.Split(”-"c)(0).Trim

3

txt.Split(":“c)(1).ToString.Split(”–"c)(0).ToString.Trim

– is different from a regular -
for some reason :smiley:

4

Hi @Shazid_Rahman if : and - are constant in your sentence then use this:

Split (Split(“yoursentence”,“:”)(1),“-”)(0)

Also Use this

System.Text.RegularExpressions.Regex.Match(TextVar,“:{1}[A-Za-z\s]+”).ToString.Replace(“:”,“”).Trim

5

Hi @Shazid_Rahman - You can use regular expressions to get the name. Take a assign activity

Variable of type String = System.Text.RegularExpressions.Regex.Match(Input,"(?<=:).*").ToString

Capture

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.