chilly_bang
Board Regular
- Joined
- Jun 17, 2016
- Messages
- 57
Hi
I have a table with three columns:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]http://headjs.com/site/assets/[/TD]
[TD]http://headjs.com[/TD]
[TD]https://www.w3schools.com[/TD]
[/TR]
[TR]
[TD]https://www.w3schools.com/jsref/[/TD]
[TD]https://www.google.de[/TD]
[TD]https://mein-trikotsatz.de[/TD]
[/TR]
[TR]
[TD]https://www.google.de/search/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]https://mein-trikotsatz.de/produkt/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to
like
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]http://headjs.com/site/assets/[/TD]
[TD]http://headjs.com[/TD]
[TD]https://www.w3schools.com[/TD]
[/TR]
[TR]
[TD]https://www.w3schools.com/jsref/[/TD]
[TD]https://www.google.de[/TD]
[TD]https://mein-trikotsatz.de[/TD]
[/TR]
[TR]
[TD]https://www.google.de/search/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]https://mein-trikotsatz.de/produkt/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I know, how to compare them, if in the column A are domains too - but with urls and partly matches i fail and need help
thanks
I have a table with three columns:
- A contains urls,
- B contains domains
- C contain domains
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]http://headjs.com/site/assets/[/TD]
[TD]http://headjs.com[/TD]
[TD]https://www.w3schools.com[/TD]
[/TR]
[TR]
[TD]https://www.w3schools.com/jsref/[/TD]
[TD]https://www.google.de[/TD]
[TD]https://mein-trikotsatz.de[/TD]
[/TR]
[TR]
[TD]https://www.google.de/search/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]https://mein-trikotsatz.de/produkt/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want to
- make red all cells in column A, where urls contain domains from column B, and
- make green all cells in column A, where urls contain domains from column C
like
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]http://headjs.com/site/assets/[/TD]
[TD]http://headjs.com[/TD]
[TD]https://www.w3schools.com[/TD]
[/TR]
[TR]
[TD]https://www.w3schools.com/jsref/[/TD]
[TD]https://www.google.de[/TD]
[TD]https://mein-trikotsatz.de[/TD]
[/TR]
[TR]
[TD]https://www.google.de/search/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]https://mein-trikotsatz.de/produkt/[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I know, how to compare them, if in the column A are domains too - but with urls and partly matches i fail and need help
thanks
Last edited: