deedii
05-15-2013, 07:43 AM
Hi Guys,
Its been a pleasure to be here again. I hope someone can lend me a help on my 2 problem.
Problem No. 1
Raw Data 1:
000000151985
000000116993
000000147470
Result Data 1:
0151985
0116993
0147470
0147471
From the example above I want to extract the 7 digits start from the last and remove the remaining digits for example 000000147470, I only need the last 7 digits to make it 0147470 as a result after extraction.
Problem No. 2
Raw Data 2:
000000009349003
000000140130001
000000067054003
000000114914006
Result Data 2:
0009349
0140130
0067054
0114914
Here I would like to extract the 7 digits after 3 digits from the last and remove the rest. For example 000000114914006, I want to remove 006 from the last 3 digits and 00000 from the beginning so I can only have 0114914 as the data extracted. So i want to remove the 3 last digits and the first 5 digits and extract only the middle 7 digits.
Thank you so much guys :) TIA
Its been a pleasure to be here again. I hope someone can lend me a help on my 2 problem.
Problem No. 1
Raw Data 1:
000000151985
000000116993
000000147470
Result Data 1:
0151985
0116993
0147470
0147471
From the example above I want to extract the 7 digits start from the last and remove the remaining digits for example 000000147470, I only need the last 7 digits to make it 0147470 as a result after extraction.
Problem No. 2
Raw Data 2:
000000009349003
000000140130001
000000067054003
000000114914006
Result Data 2:
0009349
0140130
0067054
0114914
Here I would like to extract the 7 digits after 3 digits from the last and remove the rest. For example 000000114914006, I want to remove 006 from the last 3 digits and 00000 from the beginning so I can only have 0114914 as the data extracted. So i want to remove the 3 last digits and the first 5 digits and extract only the middle 7 digits.
Thank you so much guys :) TIA