Extract a certain value from table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Regex
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
or
1 | 2 |
irrelevant cell | irrelevant cell |
name | irrelevant cell |
Amy | irrelevant cell |
irrelevant cell | irrelevant cell |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all, very appreciate for helping me figure out the solutions! Both are working.
![](/skins/images/59DA3CA97FC6306BFE8B6DED203F3AC0/responsive_peak/images/icon_anonymous_message.png)