How to do Math Calculation to trim the existing field value and store as a new embedded data field.
For Example I am having metadata field as External code and value as "1000abc_ Allowance_03172020_012452"
I want to store only this value 03172020_012452 as new field.
Math Calculation for Trimming
+2
+46Sathwik
I believe this post should help, you can do this via Javascript and store it back in embedded data
left/right substring extraction functions from piped text? — XM Community (qualtrics.com)
Hope it helps!
+46Sathwik
As mentioned on this support page Math operations do not allow you to strip the string.
"Math operations allow you to create custom values with each response. For example, you can create a function that calculates a formula using scoring for individual participants. Math operations can be performed in the survey flow, within a question, or choice text."
Hence, if you need to achieve something like that as far as I know JS is the route.
Hope it helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.