search for a specific word and copy the word and the preceeding words until a comma
"Ron Rosenfeld" wrote in message
...
I don't see what you mean when you say "plural match" in the examples given.
In the examples given, I see no need for an array form.
Perhaps I am missing something?
--ron
Thank you for your reply, Ron.
I'm Japaneses and my English is not as good enough to express what i want
to say as do in my mother tongue. but i'll try.
as you said, there is no need of array form in the examples given.
it's just my interest. if A1 has a data something like this
Kempapura, Hasigala Post, Hoskote Taluk, Bangalore Rural, #42/10,
Behind Dharmaraya Temple, Malinapet, Hona Hoskote Taluk
and want to extract every matches, How could i apply REGEX.MID for this?
i mean what i want in this case is "Hoskote Taluk" and "Hona Hoskote Taluk"
i can get these respectively by
=REGEX.MID(A1,"(?<=\s|^)[\s\w]*Taluk",1) and
=REGEX.MID(A1,"(?<=\s|^)[\s\w]*Taluk",2)
and i thought i could get these in the range by using as array formula,
as it is said to be able to use as array funntion.
Possibly, i misunderstood this function.
Thanks
keizi
|