For my survey one of the fields I need is Route.
In the spreadsheet I'm pulling the data from it's formatted as shown below.
The way it needs to appear in the results is: (Letter, 3 numbers)
The examples above would need to end up: K177, U056, I135, & K004
Initially I used a new column and formula* to make the changes before I brought the .csv into Survey123 but in the future the csv will periodically be replaced with a new one (new sample information, same column names) and I was hoping it could just be brought over without additional spreadsheet work before it's brought into Survey123.
Is there there something I can put in the calculation or inputMask field to do the formatting for me?
*Excel formula =RIGHT(LEFT(A1,4),1)&(LEFT(RIGHT(A1,5),3))