Recurrent extractregex

1

a)
Hi, having this in clipboard:

Name: Martin Hogg
Phone number: 5555-5555

Using Text Blaze commands:
First Name: {=extractregex({clipboard}, "Name: (\w+)")}
Second Name: {=extractregex({clipboard}, "Name: .+? (.+)")}
Phone: {=extractregex({clipboard}, "Phone number: (.+)")}

I can get:
First Name: Martin
Second Name: Hogg
Phone: 5555-5555

=====================

b)
having this in clipboard: (Recurrent)

Name: Martin Hogg
Phone number: 5555-5555
Name: Lars Larsen
Phone number: 1111-11111
Name: Suzane Vega
Phone number: 3333-33333

How can I get:

First Name,Second,Name,Phone
Martin,Hogg,5555-5555
Lars,Larsen,1111-11111
Suzane,Vega,3333-33333

Thank You!

2

Hey @martinhgps

The command you're looking for is extractregexall(). Scott gave a few examples in August Development Update

Try this

{first_names=extractregexall({clipboard}, "Name: (\w+)")}
{second_names=extractregexall({clipboard}, "Name: .+? (.+)")}
{phones=extractregexall({clipboard}, "Phone number: (.+)"); trim=yes}
First Name,Second,Name,Phone
{repeat: for (name, i) in first_names}
{=name}, {=second_names[i]}, {=phones[i]}
{endrepeat}

3

THANK YOU!!!! It works!!!!