[Solved] Comma separated file import

Discuss the spreadsheet application
Post Reply
sidewind
Posts: 1
Joined: Thu Feb 15, 2018 4:54 pm

[Solved] Comma separated file import

Post by sidewind »

Hi everyone

I need to import a comma separated file into a spreadsheet, so that I can convert timing like this:
0000054544, 0000044811, 000332295, 0012154826
I need them imported vertically, so that I can convert them to 1/xxx

All help or hints to how to do is apreciated

Soren
Last edited by MrProgrammer on Sat Dec 19, 2020 5:05 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 3.1 on Windows Vista
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Comma separated file import

Post by FJCC »

There is no simple way to rearrange data during the import process. I suggest you simply import that data and then use the tutorial for rearranging rectangular data. If you are having trouble with the import process, please upload a few lines of data. You can upload a file by clicking Post Reply and then using the Upload Attachment tab that is just below the box where you type a response.
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.
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Comma separated file import

Post by MrProgrammer »

Hi, and welcome to the forum.
sidewind wrote:I need to import a comma separated file into a spreadsheet, so that I can convert timing like this:
0000054544, 0000044811, 000332295, 0012154826
I need them imported vertically, so that I can convert them to 1/xxx
[Tutorial] Text to Columns, Q30/A30 and Q31/A31.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
Post Reply