Match Regex in Queries (Low-code App)

Solved81 viewslow code app Queries
4
0 Comments

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?

Thomaz Malmberg [DevOps Advocate] Selected answer as best 1 day ago

2 Answers

2
359 2 Comments

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:

Thomaz Malmberg [DevOps Advocate] Selected answer as best 1 day ago
Wale Oguntoyinbo [SLC] [DevOps Advocate] commented

Try this as there is a space before and after the hyphen:

(?<=Service\:\s*\d+\s*-\s*)[A-Za-z0-9 .&()/-]+
Thomaz Malmberg [DevOps Advocate] commented

Yahooo!

That worked and you saved my day. Big thanks for your help.
You are viewing 1 out of 2 answers, click here to view all answers.