I have the following sample data:
key | source_string
---------------------
1355 | hb;am;dr;cc;
3245 | am;xa;sp;cc;
9831 | dr;hb;am;ei;
What I need to do:
Find strings from a fixed list ('hb','am','dr' ,'ac') in the source_string
Create 3 new attributes and assign the found strings to them randomly but fixed (no difference...
sri8580
Last Activity: Jan 23 '21, 01:15 PM
Joined: Jan 23 '21
Location:
-
sri8580 started a topic How to find string occurrences, sort them randomly by key and assign them to new attrin PostgreSQLHow to find string occurrences, sort them randomly by key and assign them to new attr
No activity results to display