How can I copy/paste different selections onto different fields at once?

Off-topic posts of interest to the World of Warcraft community.
Post Reply
User avatar
Alivandesiz

How can I copy/paste different selections onto different fields at once?

#1 » Post by Alivandesiz » 28 Jul 2016 13:42

Title is self-explanatory, I'm doing some work for university and it bothers me to copy/paste over and over...
As a demonstration

*File 1*
[1]" "
[2]" "
[3]" "
...etc

*File 2*
asd
btv
onv
.... etc

I want to get this result
[1]"asd"
[2]"btv"
[3]"onv"
without manually copy/pasting invidivual selections onto fields
Thanks.

User avatar
shaun03
Posts: 547
Joined: 21 Dec 2013 06:24

Re: How can I copy/paste different selections onto different fields at once?

#2 » Post by shaun03 » 28 Jul 2016 13:46

What types of files are you using?
Feeling as though I've infringed your right to freedom of speech?

[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]

[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]

User avatar
Alivandesiz

Re: How can I copy/paste different selections onto different fields at once?

#3 » Post by Alivandesiz » 28 Jul 2016 13:47

It can be anything as long as I paste desired results onto Word/Notepad. (Any program that enables this feature, that is.)

User avatar
shaun03
Posts: 547
Joined: 21 Dec 2013 06:24

Re: How can I copy/paste different selections onto different fields at once?

#4 » Post by shaun03 » 28 Jul 2016 14:30

Ok, well I would use Excel to do it then, if I'm understanding you correctly.

I'll copy & paste the data of each file of yours onto a sheet of an excel document(File 1 onto sheet 1, and File 2 onto Sheet 2).

Once that is the case, then I'll create the following formula on an additional sheet, sheet 3, (assuming that each list of data starts in Cell A1, Column A, Row 1) :
=sheet1!A1&" "&sheet2!A1

[The " " in the above formula indicate a space between the two data strings. You can remove this if you'd like, as it all depends on what you want]

Once you have that, drag the formula down as far as you'd need to.

Then copy the new list that you formed on sheet 3 and paste it onto your word document/notepad.

It should do what you want, unless I misunderstood you.
Feeling as though I've infringed your right to freedom of speech?

[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]

[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]

User avatar
Alivandesiz

Re: How can I copy/paste different selections onto different fields at once?

#5 » Post by Alivandesiz » 28 Jul 2016 15:01

Thanks for the solution, however it didn't work for me, but as the demonstration here's what I precisely need, because I didn't demonstrate/explained it thoroughly as I should.

I'm getting "","","" asdbsdcsd result,but I need "asd","bsd","csd" like literally. (you can say this is an ordering in a way, assign selection 1 in between the first "", assign selection 2 in between the second " and so on.)

So you can say it's a mapping in a sense

Here is a picture (of course you'd have more than 1 element)

Image

User avatar
F86509B4
Posts: 1
Joined: 16 Feb 2015 23:29

Re: How can I copy/paste different selections onto different fields at once?

#6 » Post by F86509B4 » 28 Jul 2016 16:33

I wrote a small java application that does EXACTLY what was descriped in your first post:
https://puu.sh/qht8l/cfb96ace13.class
Save as "Insert.class". Run from the command line with "java Insert file1.txt file2.txt".
If you don't have the java runtime: https://www.java.com/

Be aware: this is a very specific solution for this problem. Replacing " " in each line from file1 with "<string>" where <string> is a line from file2.

User avatar
shaun03
Posts: 547
Joined: 21 Dec 2013 06:24

Re: How can I copy/paste different selections onto different fields at once?

#7 » Post by shaun03 » 28 Jul 2016 21:11

Yeah, the only way you're going to get your desired result is by using macros / a different kind of program, as the above poster wrote for you.

Unfortunately I don't have enough experience in programming other than excel macros, but even then my knowledge is limited, and it will waste your time, waiting for me to do a macro for you.

I apologise I couldn't help any further Alivandesiz, but I hope that you manage to find the solution you're looking for asap.
Feeling as though I've infringed your right to freedom of speech?

[hide="Yes"]Stop being so sensitive, and practice what you preach.[/hide]

[hide="No"]Good for you, your opinion wouldn't matter anyways.[/hide]

Post Reply

Who is online

Users browsing this forum: No registered users and 14 guests