I have a csv file with data in 8 columns. In column 2 it is a number and I want to move that number to a new column in position 3 if the value on the post is six digits or less (below 1000000).
Is there anyone that could come with some suggestion how to solve this with a batch command?

It looks like this:

First Last,28000843,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,47110833,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,29836545,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,1155,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,54963713,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,14798,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,582666,Test1,20110503,1630,1930,Test 2,Book. nr. 53655

I want it to be like this:

First Last,28000843,,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,47110833,,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,29836545,,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,,1155,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,54963713,,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,,14798,Test1,20110503,1630,1930,Test 2,Book. nr. 53655
First Last,,582666,Test1,20110503,1630,1930,Test 2,Book. nr. 53655

I have looked thru a lot of examples of similar posts here but can’t find any that do anything similar, and that could help me with ideas.