phil11
1
Hi,
I am trying to split the text using split +0000, but the only results I can get are the first string before the first comma.
I’ve tried find and replace to change the +0000 to END etc
data-checkin-id=“1428857689”, class=“user”>Duncan Mackay, is drinking a Long Blonde, by Long Man Brewery, at Keymer & Hassocks Sports & Social Club, serving_styles_2024/cask@3x.png, viewcheckindate">Sat, 26 Oct 2024 21:13:09 +0000, data-checkin-id=“1428841683”, class=“user”>Frans van Rijnswou, is drinking an Old Man, by Long Man Brewery, at Untappd at Home, at Sainsbury’s Local, serving_styles_2024/bottle@3x.png, viewcheckindate">Sat, 26 Oct 2024 20:49:40 +0000
I can only get
data-checkin-id=“1428857689”
No matter how I try and split the text I can’t get anything other than this as the first item,
item 2 is class=“user”>Duncan Mackay etc
I’ve tried this regex too
data-checkin-id=“[^”]+“.*?viewcheckindate”>[^+]+?+0000
which works in a regex tester but not in bubble to split it.
phil11
2
I found the solution.
Join with after my first and original regex with “comma” or similar as it automatically seperated my fields with a “,”