Editing Survey123 data

[DanCrafton]

I recently merged the data from two Survey123 surveys using the append command in ArcGIS Pro.  One Survey was completed in the web designer, the other in Connect.  Both surveys had the same questions, but the recorded answers are slightly different: Less-Than vs less_than.  My dashboard sees these as two different answers.  I know I can edit each record seperately in the data tap on the hosted feature layer.  There are several thousand records that need correcting so I would like to avoid getting carpel tunnel syndrome.  Is there a way to more than one record at a time?

[DanCrafton]

I should add that some of the records have attachments so I dont think downloading into Excel would work.

[GregKeith]

In Pro you could select the ones in the non-desired format, i.e. 'less-than' and calculate them all to 'Less-Than'

[DanCrafton]

Do I do that in the attribute table for the hosted feature layer?

[DanCrafton · Accepted solution]

I figured it out, there is a Find and Replace command in the attribute table.  Can replace each record one at a time or do them all an once.

[GregKeith]

There's a Calculate Field tool in the attribute table, but whatever works 🙂