Hi, What is the best approach to transform my Field Name to Field. Currently, I approach to resolve this by adding a Text Input Tool with the second table and then use a Find and Replace to do the trick. I wanted to know the various approaches to resolve this. Field NameFieldsummary______summary_issuetype_self_____issuetype_self_issuetype_id_____issuetype_id_issuetype_description_____issuetype_description_issuetype_iconurl_____issuetype_iconurl_issuetype_name_____issuetype_name_issuetype_subtask_____issuetype_subtask_issuetype_avatarid_____issuetype_avatarid_watches_self_____watches_self_watches_watchcount_____watches_watchcount_watches_iswatching_____watches_iswatching_timespent______timespent_created______created_timeoriginalestimate______timeoriginalestimate_ FindReplace_________________________________

Replace similar characters in a string

Hi, What is the best approach to transform my Field Name to Field.

Currently, I approach to resolve this by adding a Text Input Tool with the second table and then use a Find and Replace to do the trick. I wanted to know the various approaches to resolve this.

Field Name	Field
summary______	summary_
issuetype_self_____	issuetype_self_
issuetype_id_____	issuetype_id_
issuetype_description_____	issuetype_description_
issuetype_iconurl_____	issuetype_iconurl_
issuetype_name_____	issuetype_name_
issuetype_subtask_____	issuetype_subtask_
issuetype_avatarid_____	issuetype_avatarid_
watches_self_____	watches_self_
watches_watchcount_____	watches_watchcount_
watches_iswatching_____	watches_iswatching_
timespent______	timespent_
created______	created_
timeoriginalestimate______	timeoriginalestimate_

Find	Replace
__	_
___	_
____	_
_____	_
______	_
_______	_

Tips and Tricks

Accepted answers

AngelosPachis

@Mario36 and an extra two besides what @apathetichell suggested which works great.

The formula is a bit of a cheat as it's a Regex Replace expression

example_v2.yxmd

All comments

AngelosPachis

Hi @Mario36 ,

One way to do that is by using a Regex tool configure to replace a pattern you define in the regular expression box with a replacement text

Your pattern can be _+, so that means 1 or more instances of an underscore and you want to replace that with a single underscore

Cheers,

Angelos

example.yxmd

Mario36

Thank You @AngelosPachis , this worked like a charm.

Any other approaches you can think of ?

apathetichell

I like @AngelosPachis approach better - but if you need a hardcoded non-regex approach - you could do worse than:

trimright([Field Name],"_")+"_"

which removes the trailing "_" and then adds one back - because that's what you want it to do.

there are numerous other approaches too (hey! You can tokenize everything and then use a multi-flow to find when the strings of "_"'s start then null() them and summarize/concatenate) but I'd stick with a simple regex/non-regex solution.

apathetichell

@AngelosPachisMazel Tov on the new badge! I'm still in the "maybe one day" stage...

Qiu

@Mario36

Since it is a Find and Replace problem, how about the tool with the same name?

New Workflow1A.yxmd

Mario36

Unfortunately I did not want to use a Find and replace and a Text Input tool

AngelosPachis

Thank you @apathetichell ! We all have been at this stage, best of luck for whenever you feel ready and decide to give it a try!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703