Array and regex in Excel

[Alina]

Good day!

Code: Select all

GetClipBoard>List,0
Separate>List,CRLF,Array1
XLOpen>C:\Users\I\Docs\doc.xlsm,1,xlBook
Let>k=0
Repeat>k
Let>k=k+1
Let>A1=Array1_%k%
XLSetCell>xlBook,Sheet,%k%,1,%A1%,scResult
Until>k=Array1_count

I run this code and I get list in column A:
text A 1 000,22 text B
text A 5 000 text B
...

How can I get list of numbers from column A to column B?
I've written this regex:

Code: Select all

Let>pattern=((?<=text A ).*(?= text B))
RegEx>pattern,text,0,matches1,num,0
MessageModal>matches1_1

But it works only for one value.
How can I get all numbers from column A? How to change my regex? How to join first macros with second macros (regex)? How to join regex and array together?

[Dorian (MJT support)]

I just tested this and it does what I think you want. Writing the numbers into column B.

Code: Select all

Let>pattern=((?<=text A ).*(?= text B))
GetClipBoard>List,0
Separate>List,CRLF,Array1

XLOpen>C:\Users\I\Docs\doc.xlsm,1,xlBook

Let>k=0
Repeat>k
  Let>k=k+1
  Let>A1=Array1_%k%
  RegEx>pattern,A1,0,matches1,num,0
  //MessageModal>matches1_1
  XLSetCell>xlBook,Sheet,%k%,2,%matches1_1%,scResult
Until>k=Array1_count

[Alina]

Thank you very much, Dorian! It works perfectly!
I've only changed %A1% on %matches1_1% in XLSetCell.

[Dorian (MJT support)]

Good catch. Edited.