I am trying to parse out Twitter handles from numerous fields. The column header is titled "Twitter Body" and this wil capture the text of someones tweet. As you can imagine sometimes when people tweet they will include someone else's twitter handle, sometimes they won't, ....and then sometimes they will mention multiple twitter handles.
So my data is structured in a way that if a twitter handle is mentioned it starts with the "@" symbol. However, this @ symbol can appear anywhere in the body of the text....so in a way it is unstructured.
I would like to parse out into an output field the different twitter handles that are mentioned. I've utilized the RegEx ([@]/<w+>) and this will return one Twitter handle in each cell. However, if the cell contains multiple Twitter handles I would like to output those into addtional output fields as well.
Thank you in advance for your help.