Extract a certain value from table

Hi all, I'm struggling at extracting a specific value from a table. For example, I'd like to take the value "Amy" below the cell "name". The values are always below the cell "name".

Does anyone have an idea to sort it out? Thanks in advance

1	2	3
irrelevant cell	irrelevant cell	irrelevant cell
irrelevant cell	name	irrelevant cell
irrelevant cell	Amy	irrelevant cell

Regex

Transformation

Dynamic Processing

Accepted answers

Felipe_Ribeir0

Hi @dreldrel

Read all possible columns and compare different rows at the same time can be tricky, here is one way of doing this using a batch macro, please see if it works for you:

Input 1

Input 2

Input 3

Extract a certain value from table.yxzp

OllieClarke

Hi @dreldrel

here's a macro-less approach that outputs into a new column called 'OUTPUT' the value immediately below name

Hope that helps,

Ollie

FindName.yxmd

All comments

Felipe_Ribeir0

Hi @dreldrel

One way of doing this

Extract a certain value from table.yxmd

dreldrel

Hi @Felipe_Ribeir0,

Many thanks for quickly getting back to me. I was wondering what if the table length is dynamic and the name position is not fixed, is it possible to find the value as well?

Felipe_Ribeir0

Hi @dreldrel

Could you please share some example table of how the position can be?

dreldrel

Hi @Felipe_Ribeir0

No problem, it could be the below scenarios. The thing is that I'd like to output "Amy" to users no matter where is it in the table. Many thanks for your assistance.

1	2	3	4
irrelevant cell	irrelevant cell	irrelevant cell	irrelevant cell
irrelevant cell	irrelevant cell	irrelevant cell	irrelevant cell
irrelevant cell	irrelevant cell	irrelevant cell	name
irrelevant cell	irrelevant cell	irrelevant cell	Amy

1	2
irrelevant cell	irrelevant cell
name	irrelevant cell
Amy	irrelevant cell
irrelevant cell	irrelevant cell

Felipe_Ribeir0

Hi @dreldrel

Read all possible columns and compare different rows at the same time can be tricky, here is one way of doing this using a batch macro, please see if it works for you: