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 xGHIXYZ x
Result:
DEF
XYZ
Thank you in advance
@sabihaS seems to be your data is in single cell,
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)
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.
Sounds like a Filter tool! Where [Tick]=“x”
Yeah, please accept the answer once it works.
Thank you for your reply. Sorry I have modify my query(it was incorrect earlier). Please can you again check the query. Thank you.
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
Thank you for your reply. I tried but its not getting filtered properly, not sure what I am missing. Please can you have a look at workflow. Thank you.
