Here is a useful macro to share, to convert a String field into rows, one character per row.
This could be useful if you want to compare strings on a character by character basis. I wrote it for Weekly Challenge #59, but I have hit moments in the past where this would have been a nice quick step in a solution.
I am not a huge Regex fan; Yes, it is super powerful, but Regex is terse, hard to support, and very hard to debug. If you want a quick way to check if certain characters exist in strings, you could bounce the string to rows with this tool, and check each character for your test condition.
Want to count the number of "at" symbols (strudel?) in a string to see if it looks roughly like an email? Apply the macro, filter for the "at" symbol, and then Summarize to count the number.
The macro input is a V_WString field. The output is two new fields, "Position_ZeroIndex" (Int) and "Character" (V_WString,1), with one record per character in the source string. Position_ZeroIndex gives you the position of the character in the source string starting at zero, and Character is the letter (or number, symbol, space etc,) at that position.
(The macro will pass through additional columns undisturbed, and the order of the fields should be unchanged.)
Example Input...
ColA,MyString,ColB
A,Continuum.je,B
Example Output...
ColA,MyString,ColB,Position_ZeroIndex,Character
A,Continuum.je,B,0,C
A,Continuum.je,B,1,o
A,Continuum.je,B,2,n
A,Continuum.je,B,3,t
A,Continuum.je,B,4,i
A,Continuum.je,B,5,n
A,Continuum.je,B,6,u
A,Continuum.je,B,7,u
A,Continuum.je,B,8,m
A,Continuum.je,B,9,.
A,Continuum.je,B,10,j
A,Continuum.je,B,11,e