Community Profile

photo

Pete sherer


Last seen: 3 months ago Active since 2012

Statistics

  • First Answer
  • First Review
  • Thankful Level 3

View badges

Content Feed

View by

Question


Extracting 2 Far right characters
Hi, How could I extract the 2 far right characters from cell string? tt= {'United Kingdom TR';'United Kingdom SR';'United Ki...

3 months ago | 2 answers | 0

2

answers

Question


using accumarray to combine text
Hi, I am trying to use accumarray to concatenate string. tdata = table([ 1 2 2 3 4 2]', ["a","b","c","d","e","f"]', 'Variabl...

7 months ago | 1 answer | 0

1

answer

Answered
How to convert number to text in thousand format?
Thanks very much

9 months ago | 0

Question


How to convert number to text in thousand format?
tt = strtrim( string(num2str( [2598.32 256 23125]', '%1.2f'))) tt = 3×1 string array "2598.32" "256.00" "231...

9 months ago | 2 answers | 0

2

answers

Question


Help with regexp to extract data
Hi I need help extracting the text and number or text before and after the "_". When an underscore is not present, then the w...

1 year ago | 1 answer | 0

1

answer

Question


anonymous function w/ accumarray
tdata = table([ 1 1 1 2 2]', [1 5 9 10 1]', 'VariableNames',{'year','id'}) Hi I got error message below. Could you help sh...

1 year ago | 1 answer | 0

1

answer

Question


Calculating Contribution by group
Hi, I am trying to calculate the contribution within a group. Currnetly I am using below procedure, looking for ways to do it ...

1 year ago | 0 answers | 0

0

answers

Question


Using accumarray with nested inline function
Hi I have below data and would like to use accumarray to perform calculation with inline functions locOut = @(x) matches( x,"G...

1 year ago | 1 answer | 0

1

answer

Answered
Will MATLAB support running Julia code through MEX?
https://github.com/bermanmaxim/jlcall

1 year ago | 0

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

1 year 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...

1 year 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...

2 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...

2 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...

2 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...

2 years ago | 0 answers | 0

0

answers

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...

3 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 '...

4 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...

4 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;...

4 years ago | 1 answer | 0

1

answer

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...

4 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...

4 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 ...

4 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...

4 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. ...

4 years ago | 2 answers | 0

2

answers

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

4 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...

4 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

4 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...

4 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 ...

6 years ago | 2 answers | 0

2

answers

Answered
regexprep with multiple expression
Yes. Thanks

10 years ago | 0

Load more