Need Help
- 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
Hello Everyone,
I want to extract values where it is tick(x) from below column, for e.g. in this case I need to extract DEF and XYZ, Please can some one help me on this.
col1
ABC
DEF x
GHI
XYZ x
Result:
DEF
XYZ
Thank you in advance :)
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Sabiha,
Try filter tool with the suitable condition, the data doesnt provide enough to create a condition but if you do find a pattern we can try something.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sounds like a Filter tool! Where [Tick]=“x”
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yeah, please accept the answer once it works.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your reply. Sorry I have modify my query(it was incorrect earlier). Please can you again check the query. Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You will still need a Filter to reduce the rows down to 2., in this case use EndsWith([col1], “x”). Then use a Left([col1], 3) to extract the first three characters of each line
- 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
@sabihaS seems to be your data is in single cell,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That workflow shows exactly what you've described above IF they are separated into different cells
If they are not like you've tried to demonstrate, then you need a Text to Columns tool before the filter to split to rows on \n (aka newline)
