Forum Discussion

Escad199001's avatar
Escad199001
Copper Contributor
Feb 17, 2023
Solved

findAll method - Can't get to row indexes

Hi Everyone, I need to manipulate a few strings in my spreadsheet.For that, I'm using the findAll and getAddress() methods.   The getAddress returns a string with all the matches just like what th...
excel
Office Scripts
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 18, 2023

    Escad199001 

    There are no other options for getAddress(). Options are to transform returned text by script or outside; or return row indexes by other way.

    findAll() returns set of areas, for each are you may related to this area range properties. For such example

    Output is

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 18, 2023

Escad199001 

There are no other options for getAddress(). Options are to transform returned text by script or outside; or return row indexes by other way.

findAll() returns set of areas, for each are you may related to this area range properties. For such example

Output is

Escad199001's avatar
Escad199001
Copper Contributor
Feb 18, 2023

I ended up doing something similar, so yes you're right!
I was wondering if another pre-defined method existed and I had missed in the documentation.
Good to know! Thanks Sergey.