What will be the RegEx expression formula for dynamically renaming columns ?

[ak515155]

Hello ,

The column pattern is 

"Please select your level of awareness in the technology. [SQL]"

I want to rename the column into only 'SQL' . Appreciate if anyone has a potential solution.

Thanks and Regards,

Abhishek

[Qiu · Accepted solution]

@ak515155 

I suppose you want the string between [].

[shreyanshrathod]

Hi @ak515155 ,

Check if this works for you. I hope I have understood your problem statement correctly. If not, requesting you to share a sample workflow explaining the same.

In my attached solution, I am assuming there will always be a set of '[]' in which resides your desired column name.

Let me know if the solution helps.

Cheers,

Shreyansh Rathod

[messi007]

@ak515155,

The formula below will do the job for you as well:

Attached the workflow.

Hope this helps!

Regards

[ak515155]

Thank you @Qiu  !! This worked smoothly as expected. thanks a lot once again

If you can just explain the logic once , would be really helpful as I have just learning RegEx .

[Qiu]

@ak515155 
Glad to help and thank you for the accept mark.

I use this site to form and test RegEx.

And you also find very detailed explanation on the right hand side.

https://regex101.com/