Re^2: create a level csv

Sorry for beeing late.I need an output like this:

0 440Z0220-932§other information     <-- this is the first line of the
+ "root file"
1 440Z0220-932§other information
1 623Z5400-1§other information
1 623Z5400-1§other information
1 623Z5400-18other information
1 623Z5400-18§other information
1 623Z5400-3§other information
1 623Z5420-1301§other information
1 623Z5420-1307§other information
1 7010902H01§other information
1 7010900H01other information
1 623Z5466-1013§other information
1 623Z5466-1015§other information
1 623Z5465-1039§other information
1 623Z5465-1041§other information
1 623Z5465-1001§other information
1 623Z5420-3301§other information
1 623Z5465-41§other information
1 623Z5462-1001§other information   <-- this is the line that has chil
+dren of level 2
2 623Z5465-1§other information      <-- this is the second line of the
+ 1_623Z5465-1001.CSV file
2 623Z5465-11§other information
2 CA623Z5465-1001§other information <-- and this is the last line of t
+he 1_623Z5465-1001.CSV file
1 623Z5462-1003§other information   <-- here i continue to read the "r
+oot" file
2 623Z5468-1§Other information      <-- this is the second line of the
+ 1_623Z5462-1003.CSV
2 623Z5468-9§Other information
2 623Z5468-7§Other information
2 623Z5468-5§Other information
2 CA623Z5462-1003§Other information
2 BACD40AC36B30§Other information
2 623Z5469-7§Other information
2 623Z5462-3§Other information      <-- and this is the last line of t
+he 1_623Z5462-1003.CSV
1 7010902H01§other information      <-- continue to read the "root" fi
+le
1 623Z5420-3307§other information
1 B3-15838§other information
1 623Z5422-3307§other information
[download]

Comment on Re^2: create a level csv Download Code

Replies are listed 'Best First'.
Re^3: create a level csv by ELISHEVA (Prior) on Apr 16, 2009 at 13:05 UTC
Note: OP has updated the post above with a much more detailed annotated explanation, so this answer may not make sense anymore. Sorry for my slowness, but I didn't quite follow originally what you meant. I think I get it now. The first part of the line ("440Z0220-932") identifies a file. The duplicate lines associated with "440Z0220-932" are for each line within the file identified by "440Z0220-932". Is that right? So if you had only the following inputs: # FILE #1: 0_IP_017.CSV (reduced to illustrate logic) 623Z5465-1001§other information 623Z5462-1003§other information # FILE #2: 1_623Z5465-1001.CSV 623Z5465-1001§other information 623Z5465-1§other information 623Z5465-11§other information CA623Z5465-1001§other information # FILE #3: 1_623Z5462-1003.CSV 623Z5462-1003§Other information 623Z5468-1§Other information 623Z5468-9§Other information 623Z5468-7§Other information 623Z5468-5§Other information CA623Z5462-1003§Other information BACD40AC36B30§Other information 623Z5469-7§Other information 623Z5462-3§Other information [download] You would get the following output file? 1 623Z5465-1001§other information #line in file #1 - ids file #2 2 623Z5465-1001§other information #line in file #2 2 623Z5465-1§other information #line in file #2 2 623Z5465-11§other information #line in file #2 2 CA623Z5465-1001§other information #line in file #2 1 623Z5462-1003§other information #line in file #1 - ids file #3 2 623Z5462-1003§Other information #line in file #3 2 623Z5468-1§Other information #line in file #3 2 623Z5468-9§Other information #line in file #3 2 623Z5468-7§Other information #line in file #3 2 623Z5468-5§Other information #line in file #3 2 CA623Z5462-1003§Other information #line in file #3 2 BACD40AC36B30§Other information #line in file #3 2 623Z5469-7§Other information #line in file #3 2 623Z5462-3§Other information [download] Best, beth Update: finally got what OP meant and updated accordingly. The striken portion is below. This is much better, but it still isn't clear why, for example, the output has two lines with "440Z0220-932": `0 440Z0220-932§other information 1 440Z0220-932§other information` [download] but only one of your sample input files (0_IP_017.CSV) has a line with "440Z0220-932" in it. Nor is it clear how you are defining that something is a node and what node number (0,1,2) to attach to it. For example, why is "440Z0220-932" assigned both 0 and 1 when it is only in the one non-"leaf" file? This doesn't seem consistent with your explanation above (at least to me). Perhaps you could give us a very small set of short input files and an output file with just a few sample lines and then explain (in words) the reasons why you assigned 0,1, or 2 to each of the output lines.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: create a level csv
by ELISHEVA (Prior) on Apr 16, 2009 at 13:05 UTC

Note: OP has updated the post above with a much more detailed annotated explanation, so this answer may not make sense anymore.

Sorry for my slowness, but I didn't quite follow originally what you meant. I think I get it now. The first part of the line ("440Z0220-932") identifies a file. The duplicate lines associated with "440Z0220-932" are for each line within the file identified by "440Z0220-932". Is that right? So if you had only the following inputs:

# FILE #1: 0_IP_017.CSV (reduced to illustrate logic)

623Z5465-1001§other information
623Z5462-1003§other information

# FILE #2: 1_623Z5465-1001.CSV

623Z5465-1001§other information
623Z5465-1§other information
623Z5465-11§other information
CA623Z5465-1001§other information

# FILE #3: 1_623Z5462-1003.CSV

623Z5462-1003§Other information
623Z5468-1§Other information
623Z5468-9§Other information
623Z5468-7§Other information
623Z5468-5§Other information
CA623Z5462-1003§Other information
BACD40AC36B30§Other information
623Z5469-7§Other information
623Z5462-3§Other information
[download]

You would get the following output file?

1 623Z5465-1001§other information      #line in file #1 - ids file #2
2 623Z5465-1001§other information      #line in file #2
2 623Z5465-1§other information         #line in file #2
2 623Z5465-11§other information        #line in file #2
2 CA623Z5465-1001§other information    #line in file #2

1 623Z5462-1003§other information      #line in file #1 - ids file #3
2 623Z5462-1003§Other information      #line in file #3 
2 623Z5468-1§Other information         #line in file #3
2 623Z5468-9§Other information         #line in file #3
2 623Z5468-7§Other information         #line in file #3
2 623Z5468-5§Other information         #line in file #3
2 CA623Z5462-1003§Other information    #line in file #3
2 BACD40AC36B30§Other information      #line in file #3
2 623Z5469-7§Other information         #line in file #3
2 623Z5462-3§Other information
[download]

Best, beth

Update: finally got what OP meant and updated accordingly. The striken portion is below.

This is much better, but it still isn't clear why, for example, the output has two lines with "440Z0220-932":

0 440Z0220-932§other information 1 440Z0220-932§other information
[download]

but only one of your sample input files (0_IP_017.CSV) has a line with "440Z0220-932" in it.

Nor is it clear how you are defining that something is a node and what node number (0,1,2) to attach to it. For example, why is "440Z0220-932" assigned both 0 and 1 when it is only in the one non-"leaf" file? This doesn't seem consistent with your explanation above (at least to me).

Perhaps you could give us a very small set of short input files and an output file with just a few sample lines and then explain (in words) the reasons why you assigned 0,1, or 2 to each of the output lines.

[reply]
[d/l]
[select]