Text manipulation in txt file

Help Activities
, ,
1

Hello all,
This is my first post, I hope I chose the right tag.
I have site I want to extract the text. Actually, tried as a table, didn’t work, just picking one column. Anyway, if I download it in text file, doesn’t look so nice.
How can I make the text more readable. Example of what I have:
"
Decisions — January 2022

                Decisions
                Notifications - Acquisitions
                Notifications - New Businesses
            
        

        Decisions
    
        
            A
            B
            C
            D
            E
            F
            G
            H
            I
            J
            K
            L
            M
        
        
            N
            O
            P
            Q
            R
            S
            T
            U
            V
            W
            X
            Y
            Z
        
    


        



        
            top of page
        
        
        Notifications - Acquisitions

        
    
        
            A
            B
            C
            D
            E
            F
            G
            H
            I
            J
            K
            L
            M
        
        
            N
            O
            P
            Q
            R
            S
            T
            U
            V
            W
            X
            Y
            Z
        
    


        

    #

    Investor: 1000025535 Ontario Inc., New York, NY, USA (USA)

    Canadian Business: 
    
        
                Replica Analytics Ltd., Ottawa, ON, CAN
                Business Activity: Develops synthetic data software.
        
    
    



    Investor: 1000027092 Ontario Inc., Cary, NC, USA (USA)

    Canadian Business: ...............

"

I want simple:
Investor: 1000027092 Ontario Inc., Cary, NC, USA (USA)
Canadian Business:
Replica Analytics Ltd., Ottawa, ON, CAN
Business Activity: Develops synthetic data software…

Thank you,
Brano

2

Hi,

How about the following sample?

image
image1517×710 46.7 KB

Sample20220516-2.zip (2.7 KB)

Regards,

3

Thank you Yoichi,
It is pulling the proper data! I should actually pull that from string variable and I did, with help from your example. What do you think how should I continue and is it possible:

  • to write strings in two columns;
  • assign values (to the list? - although don’t know too much on them);
    Thanks,
    Brano
4

I managed to create text file from flow.
Although, doesn’t look so nice (and it has 4 lines on the end needs to be deleted):
"
Investor: 1000025535 Ontario Inc., New York, NY, USA (USA)

    Canadian Business: 
    
        
                Replica Analytics Ltd., Ottawa, ON, CAN
                Business Activity: Develops synthetic data software.

Investor: 1000027092 Ontario Inc., Cary, NC, USA (USA)

    Canadian Business:

"
Thanks,
Brano

5

Hi,

I might not understand your requirement 100%, the following will help you. This returns each item in the match string.

image
image847×793 24.5 KB

Sample20220516-2v2.zip (2.9 KB)

Regards,

1 Like