Hi,
I have no more hair left after trying to show correct data in queries. I have channel name with lots of "rubbish" in the column that I will not show.
The channel-name is like this in the column: Slot: 2 Port: A Service: 5031- Al Jazeera but I will just show the channel name in a new column like this: Al Jazeera. So everything before Al Jazzera should be gone.
I have tried this Regex: (^.*Service:\\s*\\d+\\s*-\\s*", ") with help from 365 Copilot but that is not working.
Any ideas what I shall use as Regex for this to present correct data?
Did a quick test and this should work:
(?<=Service:\s*\d+-\s*)[A-Za-z0-9 .&()-]+

See picture below. 🙁