Try Text manipulation action -> Remove text:
Source=var A
Text to match=var B (after replacing all \s
by |
)
Thanks, I've just tried it but it doesn't quite work.
Firstly, it should be replacing
\n by
| because there could be words that are separated by spaces. It'd be better to do this on a new line instead.
Anyway, here's my data for variable A:
1.1.1.1 | 2Degrees | 70mai | 9Gag | ANZ | APK Pure | AT Mobile | AT Park | Action Block | Alexa | Aliexpress | Amazon | Android Messages | Android TV | App Manager | Aurora Store | Az Devops | Azure | BNZ | BPMe | Background Video Recorder | BardX | BetterBatteryStats | Bose Connect | Brave | Bridge | Bring! | Bromite | BubbleUPnP | CamCard | ChatGPT | CoPilot | Company Portal | Confluence | Cromite | Currency | CurrencyFair | DesktopSMS | Discord | DoorDash | Dosh | Droid-ify | Edge | Eufy | FTPClient | Facebook | Fake GPS 1 | Fake GPS 2 | Feedly | FolderSync | Foxy Droid | Free Proxy List | Freestuff | GSAM Battery Monitor | Gaspy | GetFlix | Gmail | Google | Google Calendar | Google Home | Google Keep | Google Lens | Google Maps | Google Pay | Google Photos | HTTP File Server | Headphones | Heartland | HelloGuestWiFi | Here Maps | Hoyts | Hungry Panda | Hushed | Ivacy | Kiwi Browser | Lean Remote | Lime | Line | Location Changer |
Maps.Me | McDonalds | Menulog | Mi Fitness | Mi Gallery | Mi Remote | Microsoft Remote Desktop | Milkrun | Mullvad VPN | Neo Store | Netflix | New World | NextDNS | NextDNS Manager | Nine | OneDrive | Opera Mini | Opera Mobile | OpsGenie | Order Meal | Outlook Lite | Pak'nSAVE | Panda Remit | Parkable | Parkmate | Parkopedia | Perplexity | Petrol Spy | Pikashow | Play Store | Popcorn Time | PriceGrabber | Pricespy | ProtonVPN | Proxy List | Psiphon Pro | Pushbullet | Rabobank | RateX | Reddit | Rethink | Revolut | Rewards | SBS | Salefinder | Secure Parking | Shazam | Show Wifi login acreen | Signal | Slack | SlowDNS | SnakeTunnel VPN | Snapchat | SpotiFlyer | Spotify | Squirrel | Stocard | Stremio | Super Proxy | Swann | Swift Backup | Swipefy | Taobao | Tasks | Teams | Teddy | Telegram | Temu | Termux | TetherFi | The Warehouse | Tile | Today Weather | TopCashBack | Tournament Parking | Trademe | UP TV | Uber | Uber Eats | VPN China | VPN Hotspot | VPNHood! | Wallet | WangVPN | Waze | WeChat | Webtoon | Westfield | WhatsApp | WhosCall | WiFi Map | WiFiMan | Windscribe | Woolworths | Wyze | Xe Currency | Your Freedom | YourPhone | Youtube Vanced | Z App | Zepp Life | ZiVPN | Zoom | microG |
Here's my data for variable B:
1.1.1.1 | 2Degrees | 70mai | 9Gag | APK Pure | AT Mobile | AT Park | Action Block | Aliexpress | Amazon | Android Messages | Android TV | App Manager | Aurora Store | Az Devops | Azure | BNZ | BPMe | BardX | BetterBatteryStats | Bose Connect | Brave | Bridge | Bring! | Bromite | BubbleUPnP | CamCard | ChatGPT | CoPilot | Company Portal | Confluence | Cromite | Currency | CurrencyFair | DesktopSMS | Discord | DoorDash | Dosh | Droid-ify | Edge | Eufy | FTPClient | Facebook | Fake GPS 1 | Fake GPS 2 | Feedly | FolderSync | Foxy Droid | Free Proxy List | Freestuff | GSAM Battery Monitor | Gaspy | GetFlix | Gmail | Google | Google Calendar | Google Keep | Google Lens | Google Maps | Google Pay | Google Photos | HTTP File Server | Headphones | Heartland | HelloGuestWiFi | Here Maps | Hoyts | Hungry Panda | Hushed | Ivacy | Kiwi Browser | Lean Remote | Lime | Line | Location Changer |
Maps.Me | McDonalds | Menulog | Mi Fitness | Mi Gallery | Mi Remote | Microsoft Remote Desktop | Milkrun | Mullvad VPN | Neo Store | Netflix | New World | NextDNS | NextDNS Manager | Nine | Opera Mini | Opera Mobile | Order Meal | Outlook Lite | Pak'nSAVE | Panda Remit | Parkable | Parkmate | Parkopedia | Perplexity | Petrol Spy | Pikashow | Play Store | Popcorn Time | PriceGrabber | Pricespy | ProtonVPN | Proxy List | Psiphon Pro | Pushbullet | Rabobank | RateX | Reddit | Rethink | Revolut | SBS | Salefinder | Secure Parking | Shazam | Show Wifi login acreen | Signal | Slack | SlowDNS | SnakeTunnel VPN | Snapchat | SpotiFlyer | Spotify | Squirrel | Stocard | Stremio | Super Proxy | Swann | Swift Backup | Swipefy | Taobao | Tasks | Teams | Teddy | Telegram | Temu | Termux | TetherFi | The Warehouse | Tile | Today Weather | TopCashBack | Tournament Parking | Trademe | UP TV | Uber | Uber Eats | VPN China | VPN Hotspot | VPNHood! | Wallet | WangVPN | Waze | WeChat | Webtoon | Westfield | WhatsApp | WhosCall | WiFi Map | WiFiMan | Windscribe | Woolworths | Wyze | Xe Currency | Your Freedom | YourPhone | Youtube Vanced | Z App | Zepp Life | ZiVPN | Zoom |
And here's the result:
|||| ANZ ||||| Alexa ||||||||||| Background Video Recorder ||||||||||||||||||||||||||||||||||||||Calendar |Home |Keep |Lens |Maps |Pay |Photos ||||||||||||||||||||||||||||Manager || OneDrive ||| OpsGenie |||||||||||||||||||||||| Rewards ||||||||||||||||||||||||||||||||||||Eats |||||||||||||||||||||||| Zoom | microG |
There's a bunch of leftover | but I'm not too worried about that now. The issue is that some of the words got removed even though it shouldn't have. For example, the word "Google" is found in both, so it removed it. However, it also removed that same word from Google Calendar, Google Home, Google Keep, Google Lends, etc...
I think it needs to do a strict matching of the exact word contained within | .
UPDATE:
I've also tried converting them into a dictionary and looping them, basically something like this:
foreach $variable_x in $variables1
{
foreach $variable_y in $variables2
{
compare $variable_x to $variable_y
}
}
but it was extremely slow and just isn't a good solution.