topsyleeus Posted June 7, 2011 Share Posted June 7, 2011 I need to copy data from a clipboard and rearrange it and paste it in excel.in the following way Suppose I have data in clipboard of the following format- mm nn pp hh dd df mm vvv Paste in excel in the following format- mm nn pp hh dd df mm How do I do that? Link to comment Share on other sites More sharing options...
bogQ Posted June 7, 2011 Share Posted June 7, 2011 (edited) $split = StringSplit(ClipGet()," ") ClipPut($split[1]&" "&$split[2]&" "&$split[3]&@CRLF&$split[4]&" "&$split[5]&" "&$split[6]&" "&$split[7]) Edited June 7, 2011 by bogQ TCP server and client - Learning about TCP servers and clients connectionAu3 oIrrlicht - Irrlicht projectAu3impact - Another 3D DLL game engine for autoit. (3impact 3Drad related) There are those that believe that the perfect heist lies in the preparation.Some say that it’s all in the timing, seizing the right opportunity. Others even say it’s the ability to leave no trace behind, be a ghost. Link to comment Share on other sites More sharing options...
sahsanu Posted June 7, 2011 Share Posted June 7, 2011 Suppose I have data in clipboard of the following format- mm nn pp hh dd df mm vvv Paste in excel in the following format- mm nn pp hh dd df mm Just another example using RegExp: ClipPut(StringRegExpReplace(ClipGet(), "((?:.+?\s.+?){2})\s(.*)","${1}" & @CRLF & "${2}")) Link to comment Share on other sites More sharing options...
topsyleeus Posted June 8, 2011 Author Share Posted June 8, 2011 (edited) What if I want to print in the excel in the following way.. mm nn pp (space) (space) hh dd df mm. How would I get the 'tab' in the next row for one or more columns? Edited June 8, 2011 by topsyleeus Link to comment Share on other sites More sharing options...
JoHanatCent Posted June 8, 2011 Share Posted June 8, 2011 (edited) What if I want to print in the excel in the following way..mm nn pp(space) (space) hh dd df mm.How would I get the 'tab' in the next row for one or more columns?_ExcelWriteCell Edited June 8, 2011 by JoHanatCent Link to comment Share on other sites More sharing options...
topsyleeus Posted June 8, 2011 Author Share Posted June 8, 2011 Thanks All Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now