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.
[TABLE="width: 219"]
<tbody>[TR]
[TD]input[/TD]
[TD]output[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.1[/TD]
[TD]001[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.2[/TD]
[TD]002[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.3[/TD]
[TD]003[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.4[/TD]
[TD]004[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.5[/TD]
[TD]005[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.6[/TD]
[TD]006[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.7[/TD]
[TD]007[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.8[/TD]
[TD]008[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.9[/TD]
[TD]009[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.10[/TD]
[TD]010[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.11[/TD]
[TD]011[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 219"]
<tbody>[TR]
[TD]input[/TD]
[TD]output[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.1[/TD]
[TD]001[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.2[/TD]
[TD]002[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.3[/TD]
[TD]003[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.4[/TD]
[TD]004[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.5[/TD]
[TD]005[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.6[/TD]
[TD]006[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.7[/TD]
[TD]007[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.8[/TD]
[TD]008[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.9[/TD]
[TD]009[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.10[/TD]
[TD]010[/TD]
[/TR]
[TR]
[TD]1.1.1.2.3.11[/TD]
[TD]011[/TD]
[/TR]
</tbody>[/TABLE]