Revert 'Edit as Table' for csv files in IDEA Ultimate

There is Text/Data switch at the bottom of editor window.

I see no such switch.

Check the file type mapping:

I am an idiot.  For some reason I kept staring at the lower right corner and never looked at the lower left.

Thank you!

Hi,

Same issue on my side. i found this switch, but how to completely exit from that mode ? For example if it was set on the bad file ?

I want to come back exactly as before i set the "Edit as table", without even that switch on the bottom. Is this possible without some project reset ?

@...

Looks like there is currently no way to do it. See/vote for https://youtrack.jetbrains.com/issue/DBE-9974

For those who want to get rid of a Text|Data switch without re-creating the project or wait for a bug fix (as the bug were first reported two years ago), this is how to change the raw IDE settings :

# First part : Get the ProjectId

This will avoid you to repeat the next part on multiple file, it's useless if you have only one project with that (JetBrain) IDE.
Before anything, close the JetBrains IDE. Then:

• Go to <Project root>/.idea/workspace.xml where <Project root> is the path of your project.
• Search "ProjectId"
• Copy the id field (looks like "1blunApP8NzY9DUzYpbnKQAz66R"), this is the ProjectId.

# Second part : Edit the project's workspace settings file

You first need to find the Jetbrains storage folder that depend on your operating system.
For Windows:
%LOCALAPPDATA%\JetBrains\
For MacOS (You can use the "Open a folder" on the finder or the terminal):
~/Library/Application Support/JetBrains/
For Linux:
~/.local/share/JetBrains/

Next, open the IDE Storage folder. It's name is like :
<IDEName><Year>.<Subversion> (PhpStorm = "PhpStorm2021.2", PyCharm = "PyCharm2021.2"...)

- Backup this folder in case something goes wrong
- In the IDE Storage folder open workspace/<ProjectId>.xml
So in my case :
~/Library/Application Support/JetBrains/PhpStorm2021.2/workspace/1blunApP8NzY9DUzYpbnKQAz66R.xml
- In that file, search for your file name ("example-file") with the "Text|Data" switch to delete and you should find something like that :

<entry file="file://$PROJECT_DIR$/example-subfolder/example-file.ext">
    <provider selected="true" editor-type-id="text-editor">
        <state>
        ...
        </state>
    </provider>
    <provider editor-type-id="csv-data-editor">
        <state>
        ...
        </state>
    </provider>
</entry>

Delete all provider block that has "editor-type-id" not equal to "text-editor", in my case i deleted the provider with editor-type-id="csv-data-editor" (the second).
Next, save your changes.

Re-open your IDE and the Text|Data switch should be gone on that file !

TT

Thank you, TT!!!