1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to change a cell separator?

Discussion in 'BlackHat Lounge' started by robibrk, Sep 20, 2010.

  1. robibrk

    robibrk Regular Member

    Joined:
    Aug 23, 2009
    Messages:
    321
    Likes Received:
    121
    I have one data feed with coma cell separators in txt format. I want to change this cell separators to |.

    Example:

    CELL 1,CELL 2,CELL 3

    to

    CELL 1|CELL 2|CELL 3

    I can't find this option in excell.
     
  2. robibrk

    robibrk Regular Member

    Joined:
    Aug 23, 2009
    Messages:
    321
    Likes Received:
    121
    I am still waiting for answer. It is important for me, it is a CJ.com feed, that i want to use on my wp site.
     
  3. Fwiffo

    Fwiffo Power Member

    Joined:
    Apr 7, 2010
    Messages:
    562
    Likes Received:
    325
    Occupation:
    Starship Captain
    Location:
    Pluto / Spathiwa
    ctrl+f

    select "replace"

    find what: ,
    replace with: |
     
  4. robibrk

    robibrk Regular Member

    Joined:
    Aug 23, 2009
    Messages:
    321
    Likes Received:
    121
    I have tested already this and was not worked. I have found a solution right now, it is a little tricky.

    You need to change your separator under control panel>region and language>advanced>list separator from , to |. After this change joust save as normal csv with coma separator.