View original (French)

Cell separator

zbrihi -  
vdfinternet Posted messages 487 Status Member -
Hello,
I have a problem separating data into different cells. The data is in the form 1,256,1,132,0,125,-1,253 and I want to have 4 columns with 4 numbers having 3 decimal places. The problem is that I cannot separate them using the character length since it varies from line to line.
Thank you for your responses

Configuration: Windows 7 / Firefox 26.0

9 answers

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Hello.

    I believe we need to examine the source of the problem: Why this strange display?
    Who imported the data? You? A colleague? Your boss? You don't know?
    It would actually be enough to better configure the original file, so that the separator is a semicolon instead of a comma, and you would have data like
    1.256;1.132;0.125;-1.253
    which would solve all your problems...

    Best regards.
    --
    Retirement is nice! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    1
  2. vdfinternet Posted messages 487 Status Member 40
     
    Hi, it's not clear!
    0
  3. zbrihi Posted messages 9 Status Member
     
    I want to separate a list of data that contains only commas; every other comma is a decimal comma and the other is a separator.
    0
  4. zbrihi Posted messages 9 Status Member
     
    Yes, it's on Open Office.
    0
    1. vdfinternet Posted messages 487 Status Member 40
       
      I created some models for professional accounting with OpenOffice Calc.
      0
  6. vdfinternet Posted messages 487 Status Member 40
     
    I think you right-click on the cell / cell property / then you set the corresponding number format. Is that what you need?
    0
  7. zbrihi Posted messages 9 Status Member
     
    no, I don’t have the cell properties tab showing.
    0
    1. vdfinternet Posted messages 487 Status Member 40
       
      I don't have the software installed on my computer, is there ownership?
      I'm in the process of retrieving it!
      0
    2. vdfinternet Posted messages 487 Status Member 40
       
      Excuse me, it's / format the cell
      0
  8. zbrihi Posted messages 9 Status Member
     
    no, it doesn't change anything
    0
    1. vdfinternet Posted messages 487 Status Member 40
       
      Open Office Calc

      Select the cell, right-click / Format Cells /
      Then you have many options to customize the desired cell.
      0
  9. zbrihi Posted messages 9 Status Member
     
    I have set my numbers correctly, but I want to have 4 cells with one number in each cell instead of 4 in one.
    0
    1. vdfinternet Posted messages 487 Status Member 40
       
      Ok, it's clearer now, but the classic functioning of a spreadsheet does not allow for displaying a "divide" result in multiple cells! I believe.
      0
    2. zbrihi Posted messages 9 Status Member
       
      If there is a separator operator, but I can't make it so that it replaces every other comma with a separator
      I thought about writing an algorithm using the find and replace functions to replace every other comma with a period and then use the separator
      but I'm struggling a bit since I'm not very familiar with the open functions.
      0
    3. vdfinternet Posted messages 487 Status Member 40
       
      Ok, it's not going to be easy for me either, I don't know how to code scripts. Happy New Year anyway.
      0
  10. zbrihi Posted messages 9 Status Member
     
    it's a bit late to solve the problem at the source, that's why I'm looking for a direct solution.
    0
    1. vdfinternet Posted messages 487 Status Member 40
       
      If you state the problem more explicitly, it is possible that a developer will respond to you.
      0