Help with parsing text

Questions & Suggestions
1

I have a text file (it’s HTML source) filled with numerous entries in this form:

<DT><A HREF="http://www.laphil.com/education/composer-fellowship-program" ADD_DATE="1494874756" PRIVATE="1" TOREAD="0" TAGS="composer composing education">Nancy and Barry Sanders Composer Fellowship Program | LA Phil</A>

I need to step through each of them, and look within the TAGS=“xyz” field, and replace each space with a comma.

(Only inside the tags – so the entry above would look like this: TAGS=“composer,composing,education”)

Any suggestions on how to do this in KM? (KM is the only automation utility I really know.)

2

Get the source HTML in to a variable, and then use the For Each action and Substrings In collection to search for substrings matching the regex:

<DT>.*?TAG="(.*?)".*?</A>

Or something approximating that.

3

Thanks!