Excel rows, create list only from integer numbers of rows

Hi guys, i need to create some lists from an excel file.

In my excel in a column “A” there are numbers that give me the right order of my bill of materials and in “B” the relative codes.
That number, in a integer indicate the main code and in a decimal the children of the main code.

1 - ASM30050069
2 - SGA30050070
2.1 - SGE30050071
2.2 - SGE30050072
3 - SGA30050073
4 - ASM30050074
5 - SGA30050075
5.1 - SLE30050076
5.2 - SGE30050077

In this example the main code 2 in Column “A” have the code in “B” SGA30050070.
I need to create a list automatically to get the main code SGA30050070 and all the children. In this case
2.1 - SGE30050071
2.2 - SGE30050072

for all of elements of my excel file.
In this case i attach an excel example to understand better what i need, but sometimes the code in my excel BOM are thousand and thousand.

Thank you
ASM31104662 SPINTORE 3500-900 V3.xls (109.5 KB)

Hi @prasath17 no, i want to extract the code of the main article and the code of all childrens

Are you trying to Concatenate Column A and B separated by - ??

Got it…Here you go…


Note: Here (1) - means 2nd column… to get the main code use (0)…

ArrStringNumeroparte = List < string >
ArrStringMainCode = List < string >

1 Like

Not exaclty.

I want to get the B value only. But the list is from A numbers.
Again, wait i’m trying to explain better.

In column B ive the code of components, but the hierarchy is from column A.

Column A say me who is the “father” and who is the children.
If in column A there is a integer number, is a father.
If there is a decimal number, is a children. But the family is indicate from integer number!

if integer number is 2 (and relative code in column B is ASM30050070) and childrens are 2.1 and 2.2 (and relative code in columb B are SGE30050071 and SLE30050072) i want a list which contains The code of number 2 and the codes of numbers 2.1 and 2.2

we do feel that a list with 1,2,3 will not help your case
Also a list with all number will not add a value.

Looking on this from another viewpoint we do see the chance to form groups based on main and sub items.

for this we can use a group by approach:

and if we do the grouping by logic like bring e.g. 1 and 1.1,1.2 … etc together we can segment the data for a further processing.

Here following statement will help for defining the group key:

Let us know if you want to get more help on this group by approach. Thanks


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.