Finding A String In A Specific Column of A Table (SQLite)
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
0 Commenti
Risposte (2)
Peter Perkins
il 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.
0 Commenti
Vedere anche
Categorie
Scopri di più su Characters and Strings in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!