AnsweredAssumed Answered

Is it possible to auto-format the information received from pulldata()?

Question asked by chrsmith_KSDOT on Oct 5, 2017
Latest reply on Oct 5, 2017 by chrsmith_KSDOT

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. 

 

031K0017700
064U0005600

059I0013500

059K0000400

 

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))

Outcomes