Forum Discussion

beermatt's avatar
beermatt
Copper Contributor
Apr 22, 2020
Solved

Implicit intersection operator: impact on opening csv files

Hi, I have a similar question to this, but regarding impact on opening CSV files in Excel. If I have a csv file where one of the fields contains a domain prefixed by the '@' symbol (e.g. field cont...
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 22, 2020

    beermatt 

    I'd consider that as a bug, better to send a frown.

Takmil's avatar
Takmil
Brass Contributor
Apr 22, 2020

beermatt I always suggest importing data from CSV files in Excel rather than opening it directly with excel. That would be from Data>From Text/CSV.

  • beermatt's avatar
    beermatt
    Copper Contributor
    Apr 22, 2020

    Detlef_Lewinthanks, however I find that if I double-click the file, click File -> Open and browse, or File -> Open and select from recent file list the file just opens (and is interpreted).

     

    Takmilthanks, unfortunately that doesn't seem to allow (easy) saving after making amendments.

     

    Fundamentally, making simple updates to a csv file used to be simple/straightforward using Excel; if this change in functionality is not a bug (and is working as-expected/as-designed) then I'll need to look into an alternative.

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Apr 22, 2020

      beermatt 

      Change the file type to .txt. That invokes the text import assistant when opening the file.

       

Resources