Search found 1 match
- Thu Nov 23, 2017 9:02 am
- Forum: Vertica SQL Functions
- Topic: REGEX_REPLACE or SUBSR to extract Twitter accounts from text
- Replies: 0
- Views: 12766
REGEX_REPLACE or SUBSR to extract Twitter accounts from text
In one of my projects I have data sample that is a list with tweets. The task is to extract every account name to separate field. The sample data looks as follows (each line is a row - 1 column): @msgerain [What the hell happened to you?] Appendicitis http://tr.im/dagerby @msngregeain is @aragerekum...