Replace values in multiple fields

Hi all,

I'm looking at survey data that has standard Likert type repsonses (Agree, Strongly Agree, etc.) and i'd like to update these responses to numerical values rather than the text (e.g. Strongly Disagree = 1, Disagree = 2, etc.). I thought that the Multi-Field Formula tool would be the way to go but can't figure out if I have it configured correctly. Any thoughts?

Thanks

jm

Replace([_CurrentField_], 'Strongly Disagree', '1')
AND
Replace([_CurrentField_], 'Disagree', '2')

AND

...

Preparation

Accepted answers

Hi John,

There are 2 ways off the top of my head. Either Nested replaces, or a switch formula. So using your example either:

Replace(Replace([_CurrentField_], 'Strongly Disagree', '1'), 'Disagree', '2')

OR

Switch([_CurrentField_],[_CurrentField_],

'Strongly Disagree', '1',

'Disagree', '2')

Kane

All comments

Hi John,

There are 2 ways off the top of my head. Either Nested replaces, or a switch formula. So using your example either:

Replace(Replace([_CurrentField_], 'Strongly Disagree', '1'), 'Disagree', '2')

OR

Switch([_CurrentField_],[_CurrentField_],

'Strongly Disagree', '1',

'Disagree', '2')

Kane

Here is a pic and a demo module of @KaneGs suggestion

Multi-Field Replace.yxmd

Perfect - thanks!

I was a little unsure about the 'Default' part of the Switch function.

Hi Kane

The switch is really helpful!

Thanks

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703