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?
Thanks Wale for a quick answer and I have tried it, but strangely is not working in my queries. I really don´t know why.
I have done like this:
Yahooo!
That worked and you saved my day. Big thanks for your help.
Did a quick test and this should work:
(?<=Service:\s*\d+-\s*)[A-Za-z0-9 .&()-]+
See picture below. 🙁
Try this as there is a space before and after the hyphen:
(?<=Service\:\s*\d+\s*-\s*)[A-Za-z0-9 .&()/-]+