Preview of regular expressions - Azure Synapse Analytics

Question

Hi,
I'd like to know how performing the preview of the regular expressions created in a Azure Synapse Analytics pipeline in order to test them.
Does it exist any downloadable tool to execute a such task?
Thanks

Answer 1

Hello @Anonymous

Thank you for posting this concern on this community space.

I would like to share the following article regarding to this case scenario stated previously which fit into this. So, please see it down below:

https://learn.microsoft.com/en-us/sql/ssms/scripting/search-text-with-regular-expressions?view=sql-server-ver16

Let me know if that was useful but if not, I can keep assisting you further.

Looking forward to your feedback,

Cheers,

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Answer 2

Hello @Pasquale Massimo Scorca,

Here is a blog about transforming Data with Regular Expressions via the expression builder.

I hope this helps. Please let us know if you have any further questions.