How do i split string values so i can have required values from a string line?

[Arshad_Iqubal1 (Arshad Iqubal)]

Description

I need to separate some of the things from starting and ending of the string line so i can have required value dynamically?
Ex-
07182024_Acquisition_Admin_Payee_Jul2024_07152024_-180.64
07182024_Acquisition_Admin_Payee_Jul2024_07152024_-29.45
07182024_Acquisition_Admin_Payee_Jul2024_07152024_-118.88
07182024_Acquisition_Admin_Payee_Jul2024_02_12943.91
07182024_Acquisition_Admin_Payee_Jul2024_02_2523.87
I will have these kind of lines and i need to remove firstly date “07182024” from every line and also need to remove after Jul2024 from some of the line and from some need to remove after “Jul2024_02” how can i make this done dynamically using UiPath studio, so i will have result as “Acquisition_Admin_Payee_Jul2024” also “Acquisition_Admin_Payee_Jul2024_02”
Can you guys please help me out?

Link

@Arshad_Iqubal1

Date

2024-07-21

Related UiPath products

Action Center
AI Center
Apps
Assistant
Automation Cloud
Automation Hub
Automation Ops
Automation Suite
Cloud Robots
Communications Mining
Community
Data Service
Document Understanding
Documentation
Forum
Insights
Integration Service
IT Automation
Marketplace
Mobile Automation
Orchestrator
Orchestrator Mobile
Process Mining
Robot
Studio
Studio Web
StudioX
Task Capture
Task Mining
Test Suite

[vrdabberu (Varunraj Dabberu)]

Hi @Arshad_Iqubal1

ue the below regex expression:

([A-Za-z]+[A-Za-z_]+\d+(\_\d{2})?)(?=\_)

[singh_sumit (Sumit Singh Tariyal)]

Hie @Arshad_Iqubal1
if i"m not wrong here your in put right

and to get your desired value use split condition

So it will give you your desired output

Mark this helpful if it resolve your query
cherrs happy automation