View original (French)

Invert two words in the same cell L.O. Writer

Solved
arscy Posted messages 196 Status Member -  
arscy Posted messages 196 Status Member -
Good evening,
I am looking to swap two words in the same cell in LibreOffice WRITER.

I found some clues related to Table>Convert, but apart from adding tables within a table, I didn't quite grasp the subtleties :-(
an illustration of my issue: to get from a column that displays "first name last name"
to a display of "last name.first name".
Thank you in advance for any help you can provide.

3 answers

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Good evening.

    I’m afraid you’ll have to do this work manually...
    Indeed, Writer won’t know what to do with
    • Valéry Giscard d'Estaing
    • Charles de Gaulle
    • Jean Marie Bigard
    • Catherine de Saint Phalle
    • Jacques Henri Lartigue
    • Jose Maria de Heredia
    • Charles-Humbert-René de La Tour du Pin Chambly de La Charce see here


    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    1
    1. arscy Posted messages 196 Status Member 8
       
      Same fight when exporting the content to the CALC version of LibreOffice?
      0
  2. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 512
     
    Hello

    Greetings Raymond

    arscy

    You may not have completed "convert"

    An example (this is my first attempt)

    https://www.cjoint.com/c/JLgg64e0ffB

    If it's something else, further clarification will be needed.

    Best regards
    0
    1. arscy Posted messages 196 Status Member 8
       
      Thank you for this enlightening tutorial PapyLuc51,

      However, I’m stuck at the second step:
      Indeed, as soon as I validate the text conversion into a table, 2 tables are formed inside my column instead of "on top".
      As a result, I can no longer select this column :-(
      0
  3. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 512
     
    It may be necessary to go through the last step (transforming the table into text) before restarting the process.

    Send me an example of your file so I can see it.

    Best regards
    0
    1. arscy Posted messages 196 Status Member 8
       
      Here it is
      (note: this is a fake document, so there is no confidential data in it, everything is fine ;-) )

      https://www.cjoint.com/c/JLgj1Njm8Ft
      0
      1. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 611 > arscy Posted messages 196 Status Member
         
        Hello
        The process can be done in two steps
        1) select the entire table
        In the toolbar
        Table > Convert > table to text
        indicate space as the separator an empty space in "other"
        2) once the table is in text
        select the entire table
        In the toolbar
        Table > Convert > text to table
        indicate space as the separator an empty space in "other"
        then reverse the columns for name and surname and readjust the column headers
        0
      2. arscy Posted messages 196 Status Member 8 > yclik Posted messages 3875 Registration date   Status Member Last intervention  
         
        I admit that I hadn't thought of applying this strategy to the entire table.

        Of course, it involves solving the issue mentioned earlier by Raymond, possibly by playing around with "-" and/or by merging the hyphenated last names. With a list of 400 people, it requires quite a bit of work, but for my document, we're managing pretty well.
        Thank you very much!
        0