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
...
Solved! Go to Solution.
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
Perfect - thanks!
I was a little unsure about the 'Default' part of the Switch function.
Hi Kane
The switch is really helpful!
Thanks
Hello guys
I really need help with next situation. I have two problems
1. I need to replace "," with "." in multiple fields so I can have double values instead of VString.
2. I'm trying to use multiple-field formula but I really don't understand how to properly write formula in multiple field forumula tool.
F9, F13, F15, F16 are all VString fields that I need to be double fields without losing number after comma.
Sending you SS in attachment
Hi @Marko1986,
The formula should be the same as above just with the field being [_CurrentField_]
Replace([_CurrentField_],',','.')