calaloo722
New Member
- Joined
- Apr 8, 2013
- Messages
- 12
Hello,
I have a column within a spreadsheet that has data separated by 2 delimiters, a "\" and a "/". (This data has been extracted from a linux-based file.)
For example: "1\100789/3\200899/6\xlm-sgt-455-0987"
The items of data are from a bill of material (parts explosion) and the number preceding the "\" is a quantity and the numbers preceding the "/" is a sub-part number of the main part number that is entered into a column to the left of this data string. (unseen in the example)
I need to take this string of numbers and place the quantity in one column, the part number in another column, then add a row and continue to populate each column until the data has all been separated, then move on to the next main part number row to continue the process.
for example:
1 100789
3 200899
6 xlm-sgt-455-0987
Is this possible with the data tools in a spreadsheet, or will I need to write a macro? If a macro is needed, I'll need help with the code.
Thank you!
I have a column within a spreadsheet that has data separated by 2 delimiters, a "\" and a "/". (This data has been extracted from a linux-based file.)
For example: "1\100789/3\200899/6\xlm-sgt-455-0987"
The items of data are from a bill of material (parts explosion) and the number preceding the "\" is a quantity and the numbers preceding the "/" is a sub-part number of the main part number that is entered into a column to the left of this data string. (unseen in the example)
I need to take this string of numbers and place the quantity in one column, the part number in another column, then add a row and continue to populate each column until the data has all been separated, then move on to the next main part number row to continue the process.
for example:
1 100789
3 200899
6 xlm-sgt-455-0987
Is this possible with the data tools in a spreadsheet, or will I need to write a macro? If a macro is needed, I'll need help with the code.
Thank you!