Find Occurrence of URL string in a document

[tjamal1]

Hello,

I have a table that contains Web Page ID and Web Page HTML code

I need to find the ocurrance following paths 

1. devaelearning-cdn/module1/dashboard

and 

2. devaelearning-cdn/New

the first path can have module 1, module2, module3 ....... module8

Thanks

[RishiK]

@tjamal1 can you provide a sample.  You can potentially use regex to do this:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Function-to-parse-phrase-word-only-reg...

[tjamal1]

Sample can have other html code before and after these URls

PageID	SampleCode
1	http://mysite.com/devaelearning-cdn/module1/dashboard/drivers-license-classification/1.jpg
2	http://mysite.com/devaelearning-cdn/module1/dashboard/drivers-license-classification-gm-class/1.jpg
3	http://mysite.com/devaelearning-cdn/module1/dashboard/traffic-laws/1.jpg
4	http://mysite.com/devaelearning-cdn/module1/dashboard/traffic-laws/2.jpg
5	http://mysite.com/devaelearning-cdn/module2/did-you-know-on-average-each-year/1.jpg
6	http://mysite.com/devaelearning-cdn/module2/did-you-know-on-average-each-year/2.jpg
7	http://mysite.com/devaelearning-cdn/module2/seatbelts-incidents/1.jpg
8	http://mysite.com/devaelearning-cdn/module2/seatbelts-incidents/2.jpg
9	http://mysite.com/devaelearning-cdn/New/16.jpg
10	http://mysite.com/devaelearning-cdn/New/17.jpg
11	http://mysite.com/devaelearning-cdn/New/19.jpg
12	http://mysite.com/devaelearning-cdn/New/18.jpg
13	http://mysite.com/devaelearning-cdn/New/20.jpg
14	http://mysite.com/devaelearning-cdn/New/21.jpg
15	http://mysite.com/devaelearning-cdn/New/22.jpg
16	http://mysite.com/devaelearning-cdn/New/23.jpg
17	http://mysite.com/devaelearning-cdn/New/24.jpg

[ArtApa]

Hi @tjamal1 - I attached a possible solution:

[Qiu]

@tjamal1 
I tried with Append tool.

[tjamal1]

@ArtApa @Qiu 

Thanks for the workflow,

Is it counting the URL if occurring a second time in the HTML Code?

Because some of my HTML code documents has same pattern of URL repeating 2nd time or 3rd time

like 

devaelearning-cdn/module3/dashboard/

[ArtApa]

Hi @tjamal1 - My workflow counts ALL rows in the Document Text Input tool, which contain URL Strings from the second Text Input. If you want to count new URL Strings (like devaelearning-cdn/module3/dashboard/) you just need to add them in the Text Input tool.