I am currently using the Stripping HTML Tags using Regular Expressions - 4GuysFromRolla.com VB script module to remove HTML tags from a field. I am then using TextBetween to break out the DESCRIPTION_CLEANED field to 5 separate fields. It works for the first 4 but for Voting Statement, I don't know what to do as the ending string because the data is being truncated and the Analytics string is sometimes not included. Similarly, for Analytics, I don't know what to put as the final string. Is there a function to pull last characters?
Yes, is there any ID which has this Analytics data? I mean for other text you have some text information between right? From the ID's you have, are there any values with the text for Analytics. Just wanted to check the pattern so that we can come up with some other alternative.