Page 1 of 1
Insert text in column B1 keeping the data in A1-A10
Posted: 29 Aug 2011 08:41
by Ken
My problem is the date is in column A1-A10 and my batch inserts data starting in column B11. Is there a way the data can be inserted starting in column B1 keeping the existing data in A1-A10 using a batch file? I have dates in column A and I need the inserted text to be inserted into column B1-B10 etc...
Thanks
Ken
Re: Insert text in column B1 keeping the data in A1-A10
Posted: 29 Aug 2011 13:46
by trebor68
Please see the code block:
Code: Select all
echo 1,2,3,4,5,6,7,8,9,10,11,12,13>Test.csv
echo ,,,,,,,,,10,11,12,13>>Test.csv
You can see the difference between the two rows.
In row 2 you will have not value in the B1-B9.
Please test this.
Re: Insert text in column B1 keeping the data in A1-A10
Posted: 29 Aug 2011 15:19
by Ken
Thanks for the quick response... This is what it I am having a problem with.
The date will always be in column A and my input text needs to start on the same line as the date in column A.
This is what it is doing.
8/29/2011
1 2 3 4 5 6 etc...
8/29/2011
1 2 3 4 5 6
This is the way I want it to look.
8/29/2011 1 2 3 4 5 6
8/29/2011 1 2 3 4 5 etc.
Thank you for your help
Ken