Info

This question is closed. Reopen it to edit or answer.

Database organization using algorithms

1 view (last 30 days)
Lee
Lee on 12 Apr 2017
Closed: MATLAB Answer Bot on 20 Aug 2021
Hey everyone,
I'm not even sure if there's a way to accomplish this at all. I'm working on converting a bunch of Excel files into a database. Failry trivial overall but the largest hurdle i'm running into is that there are either multiple items that are the same thing but spelled incorrectly or a cell might have some extraneous information that should be split into a another cell. Again, it's fairly trivial to find and fix these things but it's becoming incredibly tedious even with built in Excel functions.
I use Matlab extensively for data analysis but now i'm curious if it can help me sort these excel list I have. My intuition says that it's likely more work than it's worth to properly set up an algorithm for each Workbook, since they aren't always in the same format. But then again, it's really just a string computation (possibly the Levenshtein distance algorithm?) and then replacing returned strings and choosing a master string to set all those as. It's probably a bit more complicated if there's a small change in the string (Example: Trim16 or Trim17).

Answers (1)

Sanjana Ramakrishnan
Sanjana Ramakrishnan on 18 Apr 2017
You can use the implementation of Levenshtein and edit distance algorithms present in the file exchange for your requirement. Refer the below file exchange links:
https://www.mathworks.com/matlabcentral/fileexchange/17585-calculation-of-distance-between-strings
https://www.mathworks.com/matlabcentral/fileexchange/39049-edit-distance-algorithm

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!