Data Manipulation with Strings

[Kailash_Singh]

Create a workflow using string activities that extracts the First and Last Name of an employee from a text file and uses this information to fill in the placeholder text in the string

First Name: Kailash
last Name:Singh
Age:27
Email:Kailsh.Singh@LocalCompany.com
would you like to send me all activity

[chandreshsinh.jadeja]

You can use Assign Activity

Email → “Kailsh.Singh@LocalCompany.com”
Fullname → Email.Split(“@”)(0).ToString
Firstname → Fullname.Split(“.”)(0).ToString
Lastname → Fullname.split(“.”)(1).ToString

[lrtetala (Lakshman Reddy)]

Hi @Kailash_Singh

Can you try the below

Input:

Output:

Sequence18.xaml (9.5 KB)

Cheers!!

[ppr (Peter Preuss)]

• Read Text Dile Activity - out: strText

• Assign Activity:
  dictExtract | Dictionary(Of String, String) =

System.Text.RegularExpressions.Regex.Matches(strText, strPattern).Cast(Of Match ).ToDictionary(Function (m) m.Groups(1).Value.Trim,Function (m) m.Groups(3).Value.Trim)

feel free to split the approach also to part statements