topic Re: Paste multiple lines from excel into text edit box in Discussions

Paste multiple lines from excel into text edit box

Erik_The_First — Mon, 18 Aug 2025 08:24:24 GMT

Hello,

I currently have a text edit box, where the user would have to put in some ID's one by one and press a button "add" every time. I want them to be able to just copy multiple cells from excel and paste them into the text edit box, so it's faster for them. The problem is, that if I paste some ID's, then only the first ID (the others are in the next lines) will be pasted. Is there a way to paste something multiline into a text edit box or even another box?

Re: Paste multiple lines from excel into text edit box

jthi — Mon, 18 Aug 2025 08:38:30 GMT

You can make TextEditBox taller by using N Lines.

Names Default To Here(1);
win = New Window("Example",
	fontobj = text = Text Edit Box("Example Text")
);
text << Set N Lines(3);

And you can parse the user input as needed.

Re: Paste multiple lines from excel into text edit box

Erik_The_First — Mon, 18 Aug 2025 08:55:21 GMT

Okay thank you, due to me not knowing how many lines the will paste, I thought its not a great solution, but by setting N lines to 2, the text edit box will accept any number of lines. Just with n lines(1) it will accept only one

Re: Paste multiple lines from excel into text edit box

jthi — Mon, 18 Aug 2025 09:16:51 GMT

Usually, I have fixed size text edit box and then immediately clean and reformat the input after user has inputted (and committed) their values. So, if user inputs

it will be formatted to (or something similar)

a,b,c

in the text edit box

Re: Paste multiple lines from excel into text edit box

Erik_The_First — Mon, 18 Aug 2025 09:55:59 GMT

When I paste some ID's from multiple excel cells, they are all in separate rows in the text edit box bot are not "separate" as in the are not split by delimiters, whitespaces or real line breaks. So when I do <<get text its just one string with the ID's in different rows but as I said no real delimiter. What could be a way to get all separate ID's ? You said you can format it inside the text edit box? Note that the ID's are completely random so no regex