extract block of data delimited by parentheses

[tuli1954]

hello,

I have a text file with blocks of data defined by parentheses, something similar to

(
asas
dsdss
)
(
wwqee
weqqe
)

I need to extract the content between the parentheses. the problem is that sometimes the parentheses are nested.
any suggestions?

Thank you

 

[maabadi]

1. How you want extract nested Paranthesis. E.G. ( aaa1 ( bbb1 ( ccc1) bbb2) aaa2) Extraxt to what?
2. What is your maximum nested paranthesis?
3. What is address (Range) of Data?

 

[tuli1954]

1. each block would occupy a column like EG.
(
B1
B2
B3
)
(
C1
C2
C3)
(
.
.
.
)
Z1,

Z2
Z3))

would turn into

B1 C1 … Z1
B2 C2 … Z2
B3 C3 … Z3

2. unknown a priori, was thinking to just count the number of "(" and ")" before running the "conversion algorithm"

3. the source is a text file not a range in a a sheet

 

[maabadi]

Please upload an real example. Descriptipn not Clear & clarify.
I think you wanted result ( with your example)
B1 B2 B3
C1 C2 C3
....

 

[tuli1954]

Please upload an real example. Descriptipn not Clear & clarify.
I think you wanted result ( with your example)
B1 B2 B3
C1 C2 C3
....

 

[tuli1954]

just uploaded a snapshot of a part of the source file and a snapshot of an excel sheet which illustrates what I am looking for

Thank you

 

[maabadi]

If it is possible, upload text file OR Paste Text here to I Work on it.

 

[maabadi]

If your Nested Parentheses is Origin, Main Reflector Type, Main_Rim & ...
If I correct Understand, you don't want to split text based them.
Then we should find Criteria to how don't separate based them also.

 

[tuli1954]

actually, it would be REALLY nice to have all this separated by ":" and/or ","

 

[maabadi]

If it is possible, upload text file OR Paste Text here to I Work on it.