Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issues with csv export of alignment results in MS-DIAL 5 #417

Open
daehwankim12 opened this issue Oct 2, 2024 · 0 comments
Open

Issues with csv export of alignment results in MS-DIAL 5 #417

daehwankim12 opened this issue Oct 2, 2024 · 0 comments

Comments

@daehwankim12
Copy link

daehwankim12 commented Oct 2, 2024

Hello,

I've recently encountered an issue while working with MS-DIAL 5. After preprocessing my data and exporting the alignment results to a csv file, I noticed that some of the annotated compound names are split across multiple cells when opening the file in Excel.

Upon investigating the msp library, which I used during the preprocessing step, I found that some compound names containing commas are enclosed in quotation marks. If a "NAME" field in the msp library already contains both quotation marks and a comma, the export process seems to add additional quotation marks. This causes Excel to misinterpret the field as unquoted, leading to the compound name being incorrectly split across multiple cells.

Could you please look into this issue and provide any guidance on how to resolve it?

Thank you for your time and consideration.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant