Jump to content

Need help to fill 6*****05

Plexter
Go to solution Solved by iRileyx,

http://textmechanic.com/text-tools/numeration-tools/generate-list-numbers/

 

Copy those settings - 
https://gyazo.com/4deed16c78f9d8c6171656cd339d52ed

 

And click generate list, it'll print them for you below so you can copy and paste or save as a file.

Hello everyone,

 

This may look stupid, but I need help to fill 6*****05. What I mean by that? I want a numbers to work with filling the gap between 6 and 05. As you can see, it's 8 digit number, I need 6 and 05, but I need to fill every other number from 00000 to 99999 between 6 and 05. Tried using Google, tried in Excel and so on, can't find solution how to do that fast. Any help appreciated.

Link to comment
Share on other sites

Link to post
Share on other sites

61234705?

 

Oh, programming sub-forum...

Cor Caeruleus Reborn v6

Spoiler

CPU: Intel - Core i7-8700K

CPU Cooler: be quiet! - PURE ROCK 
Thermal Compound: Arctic Silver - 5 High-Density Polysynthetic Silver 3.5g Thermal Paste 
Motherboard: ASRock Z370 Extreme4
Memory: G.Skill TridentZ RGB 2x8GB 3200/14
Storage: Samsung - 850 EVO-Series 500GB 2.5" Solid State Drive 
Storage: Samsung - 960 EVO 500GB M.2-2280 Solid State Drive
Storage: Western Digital - Blue 2TB 3.5" 5400RPM Internal Hard Drive
Storage: Western Digital - BLACK SERIES 3TB 3.5" 7200RPM Internal Hard Drive
Video Card: EVGA - 970 SSC ACX (1080 is in RMA)
Case: Fractal Design - Define R5 w/Window (Black) ATX Mid Tower Case
Power Supply: EVGA - SuperNOVA P2 750W with CableMod blue/black Pro Series
Optical Drive: LG - WH16NS40 Blu-Ray/DVD/CD Writer 
Operating System: Microsoft - Windows 10 Pro OEM 64-bit and Linux Mint Serena
Keyboard: Logitech - G910 Orion Spectrum RGB Wired Gaming Keyboard
Mouse: Logitech - G502 Wired Optical Mouse
Headphones: Logitech - G430 7.1 Channel  Headset
Speakers: Logitech - Z506 155W 5.1ch Speakers

 

Link to comment
Share on other sites

Link to post
Share on other sites

http://textmechanic.com/text-tools/numeration-tools/generate-list-numbers/

 

Copy those settings - 
https://gyazo.com/4deed16c78f9d8c6171656cd339d52ed

 

And click generate list, it'll print them for you below so you can copy and paste or save as a file.

PC - CPU Ryzen 5 1600 - GPU Power Color Radeon 5700XT- Motherboard Gigabyte GA-AB350 Gaming - RAM 16GB Corsair Vengeance RGB - Storage 525GB Crucial MX300 SSD + 120GB Kingston SSD   PSU Corsair CX750M - Cooling Stock - Case White NZXT S340

 

Peripherals - Mouse Logitech G502 Wireless - Keyboard Logitech G915 TKL  Headset Razer Kraken Pro V2's - Displays 2x Acer 24" GF246(1080p, 75hz, Freesync) Steering Wheel & Pedals Logitech G29 & Shifter

 

         

Link to comment
Share on other sites

Link to post
Share on other sites

3 minutes ago, Plexter said:

Hello everyone,

 

This may look stupid, but I need help to fill 6*****05. What I mean by that? I want a numbers to work with filling the gap between 6 and 05. As you can see, it's 8 digit number, I need 6 and 05, but I need to fill every other number from 00000 to 99999 between 6 and 05. Tried using Google, tried in Excel and so on, can't find solution how to do that fast. Any help appreciated.

In what kind of form do you need it? List? Text file? Excel file?

Try, fail, learn, repeat...

Link to comment
Share on other sites

Link to post
Share on other sites

On 2017-5-30 at 9:27 PM, RKRiley said:

http://textmechanic.com/text-tools/numeration-tools/generate-list-numbers/

 

Copy those settings - 
https://gyazo.com/4deed16c78f9d8c6171656cd339d52ed

 

And click generate list, it'll print them for you below so you can copy and paste or save as a file.

Wouldn't that miss out 60000005?

Aragorn (WS): 250D | 6800k | 840 Pro 512GB | Intel 530 480GB  | Asus X99-M WS | 64GB DDR4 | Corsair HX720i | GTX 1070 | Corsair H115i | Philips BDM4350UC 43" 3840x2160 IPS

Gimli (server):  Node 304 | G4560 | ADATA XPG SX8000 128GB | 2x 5TB WD Red | ASROCK H270M-ITX/AC  | 8GB DDR4 | Seasonic 400FL

 Omega (server):                 Fractal Arc Mini R2 | i3 4130 | 500GB Maxtor | 2TB WD Red : Raid 1 | 3TB Seagate Barracuda | 16GB RAM | Seasonic G-450w
Alpha (WS): 900D | 4770k | GTX 780  | 840 Pro 512GB  | GA-Z87X-OC | Corsair RM 850 | 24GB 2400mhz | Samsung S27B970D 2560x1440

                              ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Link to comment
Share on other sites

Link to post
Share on other sites

On 5/30/2017 at 11:24 PM, Plexter said:

Hello everyone,

 

This may look stupid, but I need help to fill 6*****05. What I mean by that? I want a numbers to work with filling the gap between 6 and 05. As you can see, it's 8 digit number, I need 6 and 05, but I need to fill every other number from 00000 to 99999 between 6 and 05. Tried using Google, tried in Excel and so on, can't find solution how to do that fast. Any help appreciated.

 

Separate your number into 3 :

 

* The fixed digit 6

* The 5 digits that change

* the last 2 digits that are fixed at 05

 

Now look at a number, let's say first number you can write : 60 000 005

If you look carefully you can also write this number as : 60 000 000  + value * 100  + 5

 

Now you can go even further and use a variable that can have a value from 0 to 99 999 in order to generate all those numbers  :  60 000 000 + ( value) * 100  + 5

 

For value = 0  ==> 60,000,000 + ( 0 ) * 100 + 5  = 60,000,000 + 0 + 5 = 60,000,005

[..]

For value = 12345 ===> 60,000,000 + (12345) * 100 + 5  = 50,000,000 + 1,234,500 + 5 =  61,234,505

[..]

For value = 99999 ===> 60,000,000 + ( 99,999) * 100 + 5 = 60,000,000 + 9,999,900 + 5 = 69,999,905

 

so something super simple in php :

 


for ($i = 0; $i <= 99999; $i++) {
	$value = 60000000 + ($i*100) + 5;
    echo $value."\n";
}

will output all those numbers.  so just use php.exe script.php >output.txt

to output the console text to a text file you can then open and do whatever you want with it.

 

Link to comment
Share on other sites

Link to post
Share on other sites

On 2017-6-2 at 0:29 AM, sgzUk74r3T3BCGmRJ said:

Busting out a programming language or website seems like a lot of work to avoid typing this into your terminal emulator:

 


seq 99999|xargs printf '6%05d05\n'

 

Surely this would be a little more usable/correct:

 seq -w 0 99999|xargs printf '6%s05\n' > numbers.txt

-w 0 99999 allows the value 60000005 to be included in the list which has been missed out quite often in the solutions: This lets the number sequence start at 0 and not 1. It also pads the number with the max amount of 0's needed.

> numbers.txt because it's more accessible than scrolling 100k lines in your terminal buffer (even if you have that many lines in memory)

 

Aragorn (WS): 250D | 6800k | 840 Pro 512GB | Intel 530 480GB  | Asus X99-M WS | 64GB DDR4 | Corsair HX720i | GTX 1070 | Corsair H115i | Philips BDM4350UC 43" 3840x2160 IPS

Gimli (server):  Node 304 | G4560 | ADATA XPG SX8000 128GB | 2x 5TB WD Red | ASROCK H270M-ITX/AC  | 8GB DDR4 | Seasonic 400FL

 Omega (server):                 Fractal Arc Mini R2 | i3 4130 | 500GB Maxtor | 2TB WD Red : Raid 1 | 3TB Seagate Barracuda | 16GB RAM | Seasonic G-450w
Alpha (WS): 900D | 4770k | GTX 780  | 840 Pro 512GB  | GA-Z87X-OC | Corsair RM 850 | 24GB 2400mhz | Samsung S27B970D 2560x1440

                              ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×