Answered
DB Toolbox: Calling Store Procedure
I tried to use command 'runstoredprocedure' but it seems that function doesn't exist anymore.

3 years ago | 0

Question


DB Toolbox: Calling Store Procedure
Hi, I am using the Database toolbox to execute the store procedure. tSQL = ['{call LiveCAT.dbo.[nameOfSP]('input1','inp...

3 years ago | 1 answer | 0

1

answer

Question


How to use regexp to extract data?
Hi I have this cell array, and want to extract character before and after the "__" tdata = {'XX__TG','GB_TH','BN__TH'}'; I wan...

4 years ago | 1 answer | 0

1

answer

Question


How to parse text to numbers?
Hi I have text cell str looking like this? Is there a way to use regexp to convert this matrix? ttxt = {'No info','1-50.000...

4 years ago | 1 answer | 0

1

answer

Question


How to do vector calc for cost allocation
The problem seems simple to do it using for loop, but I wonder if there's an efficient way to do below calculation. costPerTota...

4 years ago | 0 answers | 0

0

answers

Question


JDBC Connection to Oracle DB
Hi I have insalled the new Java driver and got the following error 'JDBC Driver Error: No suitable driver found for jdbc:oracl...

5 years ago | 1 answer | 0

1

answer

Question


issue with writetable in 2019b
Hi I observed behavior changed in writetable function between 2019a and 2019b. In 2019a, when Matlab write data to excel file...

5 years ago | 2 answers | 0

2

answers

Answered
How simulate correlated Poisson distributions
Is the List() function a default one? I got this error message gpRV = List(Xs',Ps'); % Note tran Undefined function '...

6 years ago | 0

Question


How simulate correlated Poisson distributions
Hi Is there a way to simulate correlated RVs where each RV follows poisson distribution? I have 2 RVs X1 and X2, and both foll...

6 years ago | 3 answers | 0

3

answers

Question


How to do pivot from table-type variable
Hi, I have this table-type data tdata.yearID=[1950;1950;1950;1951;1951;1951;1951;1952;1952;1952]; tdata.cluster=[1;3;...

6 years ago | 2 answers | 0

2

answers

Question


How to avoid for-loop here; repmat
Hi Could anyone help suggest a faster way to construct this vector? xval = [1 2 7 9]; numX = [1 4 2 3]; % I want fina...

6 years ago | 1 answer | 0

1

answer

Question


findpeaks with defined width
Is it possible to use findpeaks to sum values within bands. I am looking for a function that maximize sum values within a speci...

6 years ago | 0 answers | 0

0

answers

Question


How To Accumulate data by maximizing sum value?
Hi, From data below, is there a fast way to identify a block of continuous data that will give largest sum, second largest sum ...

6 years ago | 0 answers | 0

0

answers

Answered
How to get Lat/Lon from vec2mtx
I realized this is a bit off track. Similar to the Table join in SQL but applying the concept to spatial data. Simply it's e...

6 years ago | 0

Question


How to get Lat/Lon from vec2mtx
I am trying to generate grid lat/lon for a given polygon. First I tried to get the grids on the boundary first using vec2mtx. ...

6 years ago | 2 answers | 0

2

answers

Answered
De-allocation un-used spalloc
Also would nnz() or numel() provide actual #elements used?

7 years ago | 0

Question


De-allocation un-used spalloc
Hi For the S = spalloc(m,n,nz); function where users can pre-allocate non-zero elements, I wonder if there's a way to de-all...

7 years ago | 2 answers | 0

2

answers

Answered
How to vectorize this operation
Each locid in the ELT has a unique set of eventid by the way

7 years ago | 0

Question


How to vectorize this operation
Hi, Could you help guide how I can vectorize this operation? I have the original fullset matrix which i want to retain and p...

7 years ago | 1 answer | 0

1

answer

Question


cumsum within a group
Hi, Is there a faster way to do a cumulative sum within a group? data looks like year val cumval data=[1 10 10; 1 10 ...

8 years ago | 2 answers | 0

2

answers

Answered
regexprep with multiple expression
Yes. Thanks

12 years ago | 0

Question


regexprep with multiple expression
Hi, Is there a way to consolidate these regexprep into one expression? regexprep(ttxt, ' parish',''); regexprep(ttxt, ' bor...

12 years ago | 2 answers | 0

2

answers