Find and Replace in top Record Row?

My goal is to find and replace "_" underscore values found in the header (record, top row) row of data. After doing a formula concatenating values, it added several "_". I would like to replace all "_" with a space, and then have no more then one consecutive space in a row in each of the header fields. Thanks for you help.

Best Practices

Documentation

Accepted answers

Christine_Assaad

Hi @cyeager

I used Regex and Dynamic Rename as below. Hope this helps.

It will go and replace _ repeated once or more with a space. Cheers!

All comments

Qiu

@cyeager

A set of sample data would help us to better understand your requirement, but perhaps something like this?

New Workflow2V.yxmd

cyeager

Attached... the goal would be to have the Header row to be renamed to:

Record ID Field 1 ABC 16ft Field 2 misc 78in
Thank you!

Find and replace in header.yxmd

Christine_Assaad

Hi @cyeager

Is this what you are looking for? Cheers!

Christine_Assaad

Hi @cyeager

I used Regex and Dynamic Rename as below. Hope this helps.

It will go and replace _ repeated once or more with a space. Cheers!

cyeager

I triple checked my spelling, but it doesn't recognize the variable. This is an interesting node that I haven't used before... I wonder if it would leave me with 3 blank spots in the middle of the field name, if it worked. Thank you for the idea. 🙂

cyeager

ah, [_CurrentField_] is actually a variable specific to the Dynamic Rename Node... it worked with removing "_" and potentially trimming, but multiple spaces remained... I wonder if I would then build a find a replace (or formula) of if 4 blanks, replace with 1 blank, if 3 blanks replace with 1 blank, if 2 blanks replace with 1 blank type of script would finish it off. Thank you for the ideas.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703