Search found 1 match

by kryszczyn
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: 720

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...

Go to advanced search