2varaition string splitting

[Gayathri_Mk]

Hi Team,
I have scenario
“FINLEY, MICHAEL S INITIATE LOAN 05/04/2023 $12500”
" HATCH, CHRIS N DISTRIBUTION 05/09/2023 $12500"
I will get string values in 2variation I need to extract first and second value
sorry I need output as like this
Plan name:-FINLEY, MICHAEL S Fee type:-INITIATE LOAN
Plan name:-HATCH, CHRIS N Fee Type:-DISTRIBUTION

how to get this output even if I have 2variation of string the space you can see is tab

[Parvathy (PS Parvathy)]

Hi @Gayathri_Mk

Try the below regex expression:

(?=[A-Z])(.*)(?=\s[\d])

Hope it helps!!
Regards,

[Gayathri_Mk]

sorry I need output as like this
Plan name:-FINLEY, MICHAEL S Fee type:-INITIATE LOAN
Plan name:-HATCH, CHRIS N Fee Type:-DISTRIBUTION

[Gayathri_Mk]

sorry I need output as like this
Plan name:-FINLEY, MICHAEL S Fee type:-INITIATE LOAN
Plan name:-HATCH, CHRIS N Fee Type:-DISTRIBUTION

[ppr (Peter Preuss)]

@Gayathri_Mk

sorry I need output as like this
Plan name:-FINLEY, MICHAEL S Fee type:-INITIATE LOAN
Plan name:-HATCH, CHRIS N Fee Type:-DISTRIBUTION

looks like a different requirement as initially described

@Gayathri_Mk

I will get string values in 2variation I need to extract first and second value
ex:FINLEY, MICHAEL S INITIATE LOAN
HATCH, CHRIS N DISTRIBUTION

[Gayathri_Mk]

Apologises,this is my requirement actually
I failed to mention properly

[Parvathy (PS Parvathy)]

Hi @Gayathri_Mk
Use below Regex expression:

Plan name: (.+?,)\s+(.+?)\s(.)\s
Fee Type: (?<=(.+?,)\s+(.+?)\s(.)\s)[A-Z\s]+(?=[\d])

Hope it helps!!
Regards,

[Gayathri_Mk]

Plan name I am getting thank you @Parvathy

but fee type is not matching I am not getting how to send the text there are so many spaces if I paste here the spaces is not appearing here.