Remove string of a row that another row contains

hatudu95

Hi,

Just wondering if there is a quick way to do.

Input

A1 E2

A1 E2 H3

A1 E2 H3 J4

A1 E2 H3 J4 M5

A1 E2 H3 K4

A1 E2 H3 K4 N5

A1 E2 H3 K4 O5

B1 C2

B1 F2 H3

B1 F2 H3 J4

B1 F2 H3 K4

Output

A1 E2 H3 J4 M5

A1 E2 H3 K4 N5

A1 E2 H3 K4 O5

B1 C2

B1 F2 H3 J4

B1 F2 H3 K4

I tried to use Multi tool as below but could not work.

if FINDSTRING([Row-1:Concat_Adjusted Value], [Concat_Adjusted Value])>0
THEN "Remove" ELSE "Keep" ENDIF

Thanks very much for your help.

Expression

Accepted answers

Rags1982

Hi @hatudu95

Does this help?

Contains.yxmd

FinnCharlton

Hi @hatudu95 , to me it looks like you are trying to filter for 'childless' rows, where the value ends the previous sequence and has no continuation. If that's right, you can do it like this:

Flag Childless Rows.yxmd

All comments

Deano478

hey @hatudu95 you can do it this way

Test.yxmd

rzdodson

@hatudu95 it looks like the longest text string is 14 characters. In this solution, I created a simple Formula that returns nulls for all text strings less than 14 characters, and then used a Filter tool to remove nulls from your record set. Hope that helps!

01. Solution - 1.png 02. Solution 2.png

Solution.yxzp

hatudu95

@rzdodson @Deano478 I am looking for a more comprehensive solution. Not just taking the longest string. Just adjusted the question slightly. Could you please help

Rags1982

Hi @hatudu95

Does this help?

Contains.yxmd

FinnCharlton

Hi @hatudu95 , to me it looks like you are trying to filter for 'childless' rows, where the value ends the previous sequence and has no continuation. If that's right, you can do it like this:

Flag Childless Rows.yxmd

hatudu95

@FinnCharlton This was exactly what I was looking for. I tried contains but was keeping used "Row - 1" - thats why then

@Rags1982 Your one was great, very logical. It albsolutely worked.

Thank you very much both of you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703