Question

How to access data of regexp output (without temporary variable)?
I know how to convert the output from regexp( ) to a table by intermediating through a temporary variable as this solution: str...

1 year ago | 4 answers | 0

Question

use unstack to reshape table with dummy variable (edited: alternative crosstab method)
After I sort table according to a group variable, I like to put the group value as the 'header' column and put its members in th...

1 year ago | 2 answers | 0

Question

Edit: sqlwrite( ) fails when integer variable's value range is set too small.
Edit: previous wrong undestanding: "sqlwrite( ) fails to save a tall table to MySQL (native connection mode), when the number o...

1 year ago | 1 answer | 0

Answered
Unable to connect to MySQL (native data source configuration) on iMac
After I upgrade Matlab to 2023a, this problem is gone. I now can connect to MySQL server with "native" mode. Thanks to Mathwork...

1 year ago | 0

| accepted

Question

Why is parfor-loop is much slower than for-loop in this case?
I just started to explore the pros and cons of parfor-loop. In the simpy testing codes below, parfor-loop is much slower than fo...

1 year ago | 1 answer | 0

Question

How to include a wide table's VariableDescriptions as an additiolnal column when stacking the table?
I would like to make a wide table's VariableDescriptions as an additional column when I stack the table. I have written some cod...

1 year ago | 1 answer | 0

Question

Live editor's new panel is just blank when another live script is open
I just started using Live Script more often recently and loved it. But when a couple live scripts are being edited, Matlab Live ...

2 years ago | 1 answer | 0

Question

How to suppress "Warning: ATTR will be removed in a future release" when update( ) MySQL?
Everytime I use the update( ) function to update a row in a MySQL table, the warning message is displayed Warning: ATTR will be...

2 years ago | 1 answer | 0

Question

How to modify the built-in 'fetch' function so that it can select columns flexibly?
I was trying to write a function which fetch only the columns I like from a MySQL table. easy_fetch(conn, 'mytable', 'A', 'B') ...

2 years ago | 1 answer | 0

Question

How should XPath be set in TableSelector for htmlImportOptions so readtable( ) can output the first three tables in an html file?
I like to read first three tables in an html file with calling readtable( ) once in order to reduce the html file reading ti...

2 years ago | 2 answers | 0

Question

How can my code, which collects bad data with 'cellfun' and 'try, catch', be improved?
My real situatoin is that I have a large number of files. Some I suspect are bad. I want to know the file names of all the bad f...

2 years ago | 1 answer | 0

Question

JDBC warning message: "..... The new driver class is `com.mysql.cj.jdbc.Driver'...."
I have configured a JDBC data source successfully. There is no problem of reading in a database from the data source. However, ...

2 years ago | 1 answer | 0

Question

Why does not string(f.name) work, f = dir(folder)?
I want to do something to, like split, the filenames in a folder. I first use dir( ) to get the contents of the folder. folde...

2 years ago | 3 answers | 0

Question

How to convert negative numbers in parentheses (bank-formatted text) to numbers with minus sign?
I like to find a function or a better way to convert (9,999) to -9999. This problem occurs when I use readtable(...) to read an ...

2 years ago | 3 answers | 0

Answered
'CEF Helper' ate all my RAM and abused my GPU - what is it doing?
I have a 'cefhelper (Renderer)' problem in a different situation. In 'Help Center' window, when I click 'Examples' button, an ic...

2 years ago | 1

Question

cefhelper (Renderer) icon bouncing in Mac OS Dock, whenever accessing Matalb 'help'
Let me describe what happens. I type in the command line 'help dir' (or help other topics). I click Documentation for strsplit, ...

2 years ago | 0 answers | 0

Answered
How do I resolve 'Bundle' error messages?
Similar problem with me. When I was configuring MySQL native connection in script, I received the error message: "Failed to load...

2 years ago | 0

Question

Database Explorer App in Mac has no option for MySQL/ODBC connection
Is that normal? I hope the app has configuration option for ODBC because the native connection (MySQL/C++) doesn't work. And I ...

2 years ago | 1 answer | 0

Question

Unable to connect to MySQL (native data source configuration) on iMac
[My Computer Setup] iMac Pro OSX 12.4 Montery MySQL/C++ connector has been installed by brew as well as by .dmg package. The p...

2 years ago | 1 answer | 0