I Have Multiple CSV Row Text in my Spreadsheet Column After Get Column I want to find specific string in all CSV Row Text list . After Find I want CSV Row Text list & List index
List :
UIDs
1)1526,6273,7273,9588,
2)3848,7373,3131,
3)7284,8007,3636,7585,
4)9595,0000,
Is your data in a Google Spreadsheet?
Use sql to query your table
To get more help, provide a few rows of your table and explain more in detail what you like to get
Taifun
I have a column in which each row of the column contains a csv row list, so after getting the column I have to search for a specific string one by one in each csv row text list and when I find it then I have to get that list and its index.
List like
A
1)6262,2993,3939,
2)2992,8287,
3)0101,5252,7178,9290,9282
4)8181,9001,7171
5)2135,0084,6289,9288,
You forgot to answer the question
Where does the data come from?
In sql you could send a like query to the table like this
Select * where a like %yourString%
Taifun
Since I had nothing to do, here it is 
(Hoping it’s what you want)
We simply transform the CSV text into a listOfLists, and with a procedure, we cycle through each row and column.
If the value we’re looking for (valueToSearch) matches the one we’re targeting (currentValue), we save its column (columnNumber) and row index (rowNumber) in a list that is returned by the procedure.
Thank You Very Much
It’s always a pleasure to help,
and if you have any doubts or need a more detailed explanation, just let me know.
Have a great day !
