Hello, I have a text file with the following structure. I want to extract everything in Name List B. What can I do? I was looking at multi-row formula to fill down some flags than use filter to remove "remove" tagged rows, but not sure how to do it. Input - - - - - - - - - - - - - - - - - - - Date: 2023-03-15 Name List A - - - - - - - - - - - - - - - - - - - First Name | Last Name XXX | XXX XXX | XXX - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Date: 2023-03-15 Name List B - - - - - - - - - - - - - - - - - - - First Name | Last Name XXX | XXX XXX | XXX - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Date: 2023-03-15 Name List C - - - - - - - - - - - - - - - - - - - First Name | Last Name XXX | XXX XXX | XXX - - - - - - - - - - - - - - - - - - - Output: First Name | Last Name XXX | XXX XXX | XXX These should be names starting below the row Name List B. I don't want anything else in the output. Thanks, Alteryxer

Extract text data

Hello,

I have a text file with the following structure. I want to extract everything in Name List B. What can I do? I was looking at multi-row formula to fill down some flags than use filter to remove "remove" tagged rows, but not sure how to do it.

Input

- - - - - - - - - - - - - - - - - - -

Date: 2023-03-15

Name List A

- - - - - - - - - - - - - - - - - - -

First Name | Last Name

XXX | XXX

- - - - - - - - - - - - - - - - - - -

Date: 2023-03-15

Name List B

- - - - - - - - - - - - - - - - - - -

First Name | Last Name

XXX | XXX

- - - - - - - - - - - - - - - - - - -

Date: 2023-03-15

Name List C

- - - - - - - - - - - - - - - - - - -

First Name | Last Name

XXX | XXX

- - - - - - - - - - - - - - - - - - -

Output:

First Name | Last Name

XXX | XXX

These should be names starting below the row Name List B. I don't want anything else in the output.

Thanks,

Alteryxer

Parse

Accepted answers

ShankerV

Hi @45179902

Step 4: Multi row formula

IF !Isnull([Row-1:Temp]) and contains([Field1],"- - -")
THEN 2
ELSEIF [RecordID]>4 and [Row-1:Temp1]=2 and !contains([Field1],"- - -")
THEN [Row-1:Temp1]
ELSE null()
ENDIF

Step 5;

Step 6:

Hope this helps!!!!

Many thanks

Shanker V

All comments

ShankerV

Hi @45179902

One way of doing this.

Many thanks

Shanker V

ShankerV

Hi @45179902

Step 1: Input

Step 2;

IF [Field1]="Name List B"
THEN 100
ELSE [Row-1:Temp]+1
ENDIF

Step 3:

[Temp] >= 102 AND [Temp] <= 104

Many thanks

Shanker V

lizhaozhi

@ShankerV Thanks for helping. Please note that the example I give is just a representation. There could be different number of names in each name list. Therefore, I'm afraid hardcoding [Temp] <= 104 cannot achieve full automation.

ShankerV

Hi @45179902

I believe the line

------------- will be available in the input right.

Many thanks

Shanker V

lizhaozhi

Yes. The dashed lines are in the file as well. It's just that there could be two rows of names in Name List A, five rows of names in Names List B, and one row of name in Name List C, etc. I want this to achieve full automation so that no matter this variance, I can use this configuration to always extract every name rows in Name List B.

Christina_H

Here's a way to do it with a single multi-row formula.

Multirow.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703