# How to find csv text in another csv text?
**URL:** https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520
**Category:** Ask for Help
**Created:** [February 5, 2023, 9:51am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520 "2023-02-05T09:51:14Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [February 5, 2023, 9:51am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/1 "2023-02-05T09:51:14Z")
How would i find the items in the csv on the right column inside the left column?
Example: The first row contains My Calendar in both column.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 5, 2023, 9:57am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/3 "2023-02-05T09:57:56Z")
Just to be clear, are you looking for the intersection of the two lists?
ie. those items that appear in both lists.
---
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [February 5, 2023, 10:01am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/4 "2023-02-05T10:01:19Z")
Yes. So if anything in second column matches anything first column then return TRUE otherwise FALSE. I will use the TRUE value to determine who on this table of users sees a message.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 5, 2023, 10:11am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/5 "2023-02-05T10:11:55Z")
Okay, this is just off the top of my head and it requires a few columns. There might be a shorter way - certainly it could be done with a single JavaScript column. But anyway…
- Convert both to arrays using Split Text columns
- Use the [Remove Elements from Array](https://www.glideapps.com/plugins/remove-all) plugin to remove all elements in the second array from the first.
- [Check the length](https://www.glideapps.com/plugins/array-length) of the resultant array and compare it to the original.
- If the length is shorter, then you have one or more intersecting items.
---
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [February 5, 2023, 10:13am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/6 "2023-02-05T10:13:28Z")
Interesting idea, okay thanks i will try that now👍
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 5, 2023, 10:30am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/7 "2023-02-05T10:30:18Z")
Here is a JavaScript option. I’d probably use this as it’s only a single column.
```auto
function intersection(list1, list2) {
return list1.filter(function(item) {
return list2.includes(item);
});
}
let arr1 = p1.split(',');
let arr2 = p1.split(',');
return intersection(arr1,arr2);
```
---
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [February 5, 2023, 10:45am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/8 "2023-02-05T10:45:18Z")
It’s only the three extra columns, because i would need column 1,2 & 6 for any solution (besides if i used javascript)
I’ll try the java script now and see.
Thanks for your help on this👍
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 6, 2023, 10:46am UTC](https://community.glideapps.com/t/how-to-find-csv-text-in-another-csv-text/57520/9 "2023-02-06T10:46:17Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.