This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a string that may contain the values: 1,2,3,4,5,6,7,888,981 or any permutation of those 9 values. I am using RegEx with Parse output option with the following expression - ^(1)|(2)|(3)|(4)|(5)|(6)|(7)|(888)|(981)$.
Example - Field value = 2,4,981
When I use the expression above and parse the capture groups into their own buckets I only get the first match and all the other buckets have whitespace (Not null). I expected to see the values in the 2nd, 4th, and 9th bucket respectively. RegEx Buddy gives me the expected results (using a RegEx format of Perl 5.2.0). What am I doing wrong?
Big Kudos go out to Gene Rinas for his elegant solution to this problem. Was able to bypass RegEx completely!
By using "Text to Columns" then adding a "counter" field with a value of one. A cross tab with a group on the recordID, the response as the header field and count as the data field gave me EXACTLY what I was looking for.