Need Help

[sabihaS]

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 :)

[NidhiSethi]

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.

[alexnajm]

Sounds like a Filter tool! Where [Tick]=“x”

[NidhiSethi]

Yeah, please accept the answer once it works.

[sabihaS]

Thank you for your reply. Sorry I have modify my query(it was incorrect earlier). Please can you again check the query. Thank you.

[alexnajm]

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

[sabihaS]

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.

[binuacs · Accepted solution]

@sabihaS seems to be your data is in single cell,

[alexnajm · Accepted solution]

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)