How to split unstructured data

vinod_ravikumar · February 4, 2021, 6:34pm

Hi Team,

Please provide me your inputs to split & get the output from the below data.

Input Data:

5 06/10/2016 Endorse/Revise Add EMT:…Submitted 4/27/2016 06/10/2016
4 06/10/2015 New Auto: …Issued 4/27/2015 06/10/2016

We don’t have any unique value to find and split and it also has spaces in between which is not constant.

Expected Output in below format

5, Endorse/Revise & 4/27/2016
4, New & 4/27/2015

Regards,
Vinod

prasath17 · February 4, 2021, 6:57pm

Hi @vinod_ravikumar - Please find the regex patten…

You have to use group variables to get the output…

Group 1= 5
Group 2= Endorse/Revise
Group3= 4/27/2016

Please refer this post

prasath17 · February 4, 2021, 8:11pm

@vinod_ravikumar - Please find the starter help here…

Topic		Replies	Views
Split the text file line by line using regex Activities activities , string , data_manipulation , system	5	2070	September 30, 2020
Split specific data in string Activities excel , activities , question	15	1025	April 24, 2021
Split text seperately Activities pdf , activities , question	10	845	October 15, 2022
I need to extract the value using regex Academy Feedback studio , question	8	1102	December 27, 2020
Extract/Splitting the particular data from entire data Activities excel , activities , question	12	423	April 14, 2023