New Import Text Delimiter Option

Discuss the spreadsheet application
Post Reply
urizan
Posts: 3
Joined: Mon Mar 13, 2023 1:10 am

New Import Text Delimiter Option

Post by urizan »

I'm needing a way to make this delimit by css brackets.

https://www.maxpreps.com/al/football/st ... YXI9MTE%3d

When I try to import the above player information their CSS code brackets seem to go unseen by the OO installation during importing. So the problem is that the name of the school should be in the same row right after the name of the player and we wanted to ask for someones help with this please.

Thanks.
OpenOffice v4.14 on MS Windows
FJCC
Moderator
Posts: 9549
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: New Import Text Delimiter Option

Post by FJCC »

When I import the link into Calc using Insert -> Link to External Data, I get the data in the attached file. The school is in the same cell as the player name, just as it is on the web page. Do you get something different than that?
Attachments
Alabama.ods
(27.68 KiB) Downloaded 59 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
urizan
Posts: 3
Joined: Mon Mar 13, 2023 1:10 am

Re: New Import Text Delimiter Option

Post by urizan »

I tried what you did but for me it didn't work because the "OK" button remain off when I paste the link.
Can you guide me to the same solution with more details maybe something in the OpenOffice settings?
OO v4.1.14 on Windows 7x64. Thanks.
Attachments
print screen image
print screen image
prntscrn.jpg (121.33 KiB) Viewed 805 times
OpenOffice v4.14 on MS Windows
FJCC
Moderator
Posts: 9549
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: New Import Text Delimiter Option

Post by FJCC »

After you paste the url into the box, if the process does not proceed, click twice, slowly, on the drop down list arrow just to the right of the URL. You should then get a dialog for Import Options. Accept the defaults. You will then get a dialog with three possible tables to import. Pick HTML_1. There is no way to tell which is the correct option, but I picked that and it worked.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
urizan
Posts: 3
Joined: Mon Mar 13, 2023 1:10 am

Re: New Import Text Delimiter Option

Post by urizan »

So doing Insert>Link External Data worked for the 1st iteration of 50 records under 3rd party pagination involving CSS / jquery. I reached out to taboola in an email for inquiry into this same issue I am reporting here. Is there a way in OO or a plugin module for OO to handle pagination that tokenizes the page number or next 50 iterations of the database for the webserver.

Thanks in advance.
OpenOffice v4.14 on MS Windows
Post Reply