Finding A String In A Specific Column of A Table (SQLite)

2 次查看（过去 30 天）
Shiv MV
Shiv MV 2021-11-20
回答： Peter Perkins 2021-11-23
I have a table consisting of several columns and ran code to isolate only the last 6 characters of a specific column in that table. Now I need to search for a string in this new column that I have made, not sure how to include the code that isolated this new column into the code that will find the string? Thx
Code To isolate Column:
SELECT substr(column,28)
FROM table

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

回答（2 个）

KSSV
KSSV 2021-11-20
Read about strfind and strcmp.
Peter Perkins
Peter Perkins 2021-11-23
If this were a MATLAB table, it would be something like
endsWith(T.StringVar,"sixChr")
but I don't know what context you are working in.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by