sshepherd10
New Member
- Joined
- Jul 13, 2018
- Messages
- 3
Hi all, I am frustrated. My Engineers and I manually convert strings of numbers into sequence numbers for our ERP system. It is waste of time and brings in the chance for errors.
SolidWorks (CAD) spits out a number = 1.2.3.4.10 and we change that to Sequence Number = 010
I really have a tough time getting anything above 009 to work, That is why I wanted to get the 010 example to work
Essentially we are taking the numbers after the last decimal and converting them to a three digit number from 001-999.
So that is the problem. I won't say how I have tried to accomplish this, as you will find a much better solution than I.
<tbody>
</tbody>
SolidWorks (CAD) spits out a number = 1.2.3.4.10 and we change that to Sequence Number = 010
I really have a tough time getting anything above 009 to work, That is why I wanted to get the 010 example to work
Essentially we are taking the numbers after the last decimal and converting them to a three digit number from 001-999.
So that is the problem. I won't say how I have tried to accomplish this, as you will find a much better solution than I.
input | output |
1.1.1.2.3.1 | 001 |
1.1.1.2.3.2 | 002 |
1.1.1.2.3.3 | 003 |
1.1.1.2.3.4 | 004 |
1.1.1.2.3.5 | 005 |
1.1.1.2.3.6 | 006 |
1.1.1.2.3.7 | 007 |
1.1.1.2.3.8 | 008 |
1.1.1.2.3.9 | 009 |
1.1.1.2.3.10 | 010 |
1.1.1.2.3.11 | 011 |
<tbody>
</tbody>