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
[Solved] Comma separated file import
[Solved] Comma separated file import
Last edited by MrProgrammer on Sat Dec 19, 2020 5:05 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 3.1 on Windows Vista
Re: Comma separated file import
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Comma separated file import
Hi, and welcome to the forum.
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.
[Tutorial] Text to Columns, Q30/A30 and Q31/A31.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
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).
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).