Regex expression to remove some text from Query output

[samson_Omolola]

Please how can I remove {color:#de350b} and {color} from:

{color:#de350b}FA_RDA_CORE-DEC-20220325122114-210-981{color}

to get

FA_RDA_CORE-DEC-20220325122114-210-981

[Gokul001 (Gokul Balaji)]

Hi @samson_Omolola

Welcome to UiPath community

You can try with Regex Expression

YourString = "{color:#de350b}FA_RDA_CORE-DEC-20220325122114-210-981{color}"

Use Assign activity

StrVal = System.Text.RegularExpressions.Regex.Match(YourString,"(?<=})\S+(?={)").Tostring

Regards
Gokul

[ppr (Peter Preuss)]

As an opposite of grabbing we can use regex replace as alternate option

replacing with empty string

strPattern = "{[\s\S]+?}"
 System.Text.RegularExpressions.Regex.Replace(strText, strPattern,"")

[samson_Omolola]

Thanks, it worked

[ppr (Peter Preuss)]

@samson_Omolola
Perfect, it is working. May we ask you for the following?

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

thanks for support

[samson_Omolola]

Thanks, question answered.