Hi,
I have data that was exported from Solidworks to Excel (csv), which includes hierarchical levels in a format I would like to change in the least painful way possible. If I have a column of data in this format 1, 1.1, 1.1.1, 2, 2.1, 3, 3.1, 3.1.1, 3.2, 3.2.1 (where the , represents a new cell), how can I convert to this format 1, 2, 3, 1, 2, 1, 2, 3, 2, 3?
Where single digit = 1, two digits = 2, three digits =3, and so on. (1, 2, or 3 would convert to 1) (1.1, 2.1, or 2.2 would convert to 2) (1.1.1, 3.1.1, or 3.2.1 would convert to 3)
I guess digit in not the correct wording because 10.10.20 would = 3
Any help would be greatly appreciated!
I have data that was exported from Solidworks to Excel (csv), which includes hierarchical levels in a format I would like to change in the least painful way possible. If I have a column of data in this format 1, 1.1, 1.1.1, 2, 2.1, 3, 3.1, 3.1.1, 3.2, 3.2.1 (where the , represents a new cell), how can I convert to this format 1, 2, 3, 1, 2, 1, 2, 3, 2, 3?
Where single digit = 1, two digits = 2, three digits =3, and so on. (1, 2, or 3 would convert to 1) (1.1, 2.1, or 2.2 would convert to 2) (1.1.1, 3.1.1, or 3.2.1 would convert to 3)
I guess digit in not the correct wording because 10.10.20 would = 3
Any help would be greatly appreciated!