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

2 vues (au cours des 30 derniers jours)
Shiv MV
Shiv MV le 20 Nov 2021
Réponse apportée : Peter Perkins le 23 Nov 2021
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

Connectez-vous pour répondre à cette question.

Réponses (2)

KSSV
KSSV le 20 Nov 2021
Read about strfind and strcmp.
Peter Perkins
Peter Perkins le 23 Nov 2021
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.

Catégories

En savoir plus sur Characters and Strings dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by