[FRIAM] Find String in Spreadsheet
Stephen Guerin
stephen.guerin at simtable.com
Sun Nov 27 00:08:58 EST 2022
Looking at the dataset, the filter feature was helpful to show the list by
institution. eg, here's researchers with SFI listed as their primary
institution. the rank is in the second to last column.
[image: image.png]
_______________________________________________________________________
Stephen.Guerin at Simtable.com <stephen.guerin at simtable.com>
CEO, https://www.simtable.com <http://www.simtable.com/>
1600 Lena St #D1, Santa Fe, NM 87505
office: (505)995-0206 mobile: (505)577-5828
On Sat, Nov 26, 2022 at 9:19 AM Frank Wimberly <wimberly3 at gmail.com> wrote:
> Thanks, Brent.
>
> Stanford published a spreadsheet with about 200,000 researchers. Each row
> contains name, institution name, country, etc. I want to be able to search
> for the data about a given individual, the people associated with an
> institution, etc.
>
> I used to program macros in VBA but I only did it for a few months and
> that was about 15 years ago.
>
> Frank
> ---
> Frank C. Wimberly
> 140 Calle Ojo Feliz,
> Santa Fe, NM 87505
>
> 505 670-9918
> Santa Fe, NM
>
> On Sat, Nov 26, 2022, 9:03 AM Brent Auble <brent at auble.net> wrote:
>
>> If you just want to find something, using the Find option from the menu
>> will work and it should give you the option of searching within the current
>> sheet or across all sheets in the workbook. If there are multiple results,
>> it should pop up a docked window at the bottom of the spreadsheet to show
>> everything it's found.
>>
>> However, if you want to do it programmatically, I'm not sure if any of
>> the built-in functions (formulas) will handle that well, mostly because of
>> the complexity of handling multiple results. Excel functions try really
>> hard to just return single values so they can populate just the cell
>> they're in. There are some exceptions, where a formula will run and put its
>> results in multiple other cells, but those are uncommon because they can
>> indiscriminately overwrite existing cell values.
>>
>> The is likely a capability in the Visual Basic language used for
>> scripting Excel to handle searching, but it's not something I've used
>> before (despite having done a good bit of Excel VBA in the past).
>>
>> What are you trying to accomplish?
>>
>> Thanks,
>>
>> Brent
>>
>>
>>
>> On Sat, Nov 26, 2022 at 10:42 AM, Frank Wimberly
>> <wimberly3 at gmail.com> wrote:
>> I used to know Excel pretty well but that was decades ago. I want to
>> find a given string, say "Wimberly" in a large spreadsheet. How do I do
>> that simply? FIND function wants to provide the location within a larger
>> string of a substring. I want something like the Unix "grep' command.
>>
>> --
>> Frank Wimberly
>> 140 Calle Ojo Feliz
>> Santa Fe, NM 87505
>> 505 670-9918
>>
>> Research: https://www.researchgate.net/profile/Frank_Wimberly2
>> -. --- - / ...- .- .-.. .. -.. / -- --- .-. ... . / -.-. --- -.. .
>> FRIAM Applied Complexity Group listserv
>> Fridays 9a-12p Friday St. Johns Cafe / Thursdays 9a-12p Zoom
>> https://bit.ly/virtualfriam
>> to (un)subscribe http://redfish.com/mailman/listinfo/friam_redfish.com
>> FRIAM-COMIC http://friam-comic.blogspot.com/
>> archives: 5/2017 thru present
>> https://redfish.com/pipermail/friam_redfish.com/
>> 1/2003 thru 6/2021 http://friam.383.s1.nabble.com/
>>
>> -. --- - / ...- .- .-.. .. -.. / -- --- .-. ... . / -.-. --- -.. .
>> FRIAM Applied Complexity Group listserv
>> Fridays 9a-12p Friday St. Johns Cafe / Thursdays 9a-12p Zoom
>> https://bit.ly/virtualfriam
>> to (un)subscribe http://redfish.com/mailman/listinfo/friam_redfish.com
>> FRIAM-COMIC http://friam-comic.blogspot.com/
>> archives: 5/2017 thru present
>> https://redfish.com/pipermail/friam_redfish.com/
>> 1/2003 thru 6/2021 http://friam.383.s1.nabble.com/
>>
> -. --- - / ...- .- .-.. .. -.. / -- --- .-. ... . / -.-. --- -.. .
> FRIAM Applied Complexity Group listserv
> Fridays 9a-12p Friday St. Johns Cafe / Thursdays 9a-12p Zoom
> https://bit.ly/virtualfriam
> to (un)subscribe http://redfish.com/mailman/listinfo/friam_redfish.com
> FRIAM-COMIC http://friam-comic.blogspot.com/
> archives: 5/2017 thru present
> https://redfish.com/pipermail/friam_redfish.com/
> 1/2003 thru 6/2021 http://friam.383.s1.nabble.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://redfish.com/pipermail/friam_redfish.com/attachments/20221126/1bf95b47/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 86007 bytes
Desc: not available
URL: <http://redfish.com/pipermail/friam_redfish.com/attachments/20221126/1bf95b47/attachment-0001.png>
More information about the Friam
mailing list