Sign in to follow this  
Followers 0
topsyleeus

Copy from clipboard, reformat and paste in excel

6 posts in this topic

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?

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

$split = StringSplit(ClipGet()," ")
ClipPut($split[1]&" "&$split[2]&" "&$split[3]&@CRLF&$split[4]&" "&$split[5]&" "&$split[6]&" "&$split[7])

Edited by bogQ

TCP server and client - Learning about TCP servers and clients connection
Au3 oIrrlicht - Irrlicht project
Au3impact - Another 3D DLL game engine for autoit. (3impact 3Drad related)



460px-Thief-4-temp-banner.jpg
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.

 

Share this post


Link to post
Share on other sites

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}"))

Share this post


Link to post
Share on other sites

#4 ·  Posted (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 by topsyleeus

Share this post


Link to post
Share on other sites

#5 ·  Posted (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 by JoHanatCent

Share this post


Link to post
Share on other sites

Thanks All

Share this post


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
Sign in to follow this  
Followers 0