ServiceNow RPA Excel Connector Use Case | Split data to Columns using Transform Data | Excel Methods

VB.NET Code to get UserName:

Dim name As String = Value.split(“-“)(1).split(“@”)(0).Replace(“.”,” “)
Dim parts() As String = name.Split(” “c) ‘ Split by space
For i As Integer = 0 To parts.Length – 1
If Not String.IsNullOrEmpty(parts(i)) Then
parts(i) = parts(i)(0).ToString().ToUpper() & parts(i).Substring(1)
End If
Next
Dim finalstr As String = String.Join(” “, parts)
return finalstr
———————————————————————————————————————–
Other Videos:

Get Started with ServiceNow RPA Design Desktop Studio – A Beginner’s Guide
https://www.youtube.com/watch?v=0k30Yv8TrbA&t=1s

Variables & Types in ServiceNow RPA Studio: An Introduction + Complete Guide
https://www.youtube.com/watch?v=db5yOg2jPOw&t=2s

ServiceNow RPA Excel Automation- Read Excel Files (Using Data Reader and Connectors)
https://www.youtube.com/watch?v=iVrhXSBVR0c&t=2s

Install, Add & Configure Plugins for Enhanced Automation in ServiceNow RPA Studio
https://www.youtube.com/watch?v=ck9LfBL4OUw&t=165s

How to get a PDI Instance on Service Now | Step-By-Step Guide
https://www.youtube.com/watch?v=hPpQctz_xRw

Installation Guide of RPA Design Desktop Studio & RPA Hub Setup | Robotic License Distribution
https://www.youtube.com/watch?v=9IgEouawZg8&t=67s

How to Publish | Create Bot Process | Create Robot in ServiceNow RPA | RPA Hub
https://www.youtube.com/watch?v=rcXeh7AEPtM&t=1s
———————————————————————————————————————
email: [email protected]