filter data based on row value(text) ?

1 次查看（过去 30 天）
MUKESH KUMAR
MUKESH KUMAR 2020-6-3
编辑： Mohammad Sami 2020-6-3
I had data similar to shown in image1 and want to exteract data for all data for first column for all rows like image2, image3.....so on for all individual routes of column one.
how to filter data based on text values. Sample data is attached in excel file
Here is further followup question after this,
if first column has time varying throughout the day time of 24hr then how can I distribute this data with probability distribution having probality in night is higher during 10PM to 5AM and low in day time.
thanks
  1 个评论
Mohammad Sami
Mohammad Sami 2020-6-3
编辑：Mohammad Sami 2020-6-3
Matlab supports various string comparison options.
contains Determine if pattern is in strings
matches Determine if pattern matches strings
endsWith Determine if strings end with pattern
startsWith Determine if strings start with pattern

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by