Hi,

I downloaded data from our server and imported it into a table. However, the batch ID is full of syntax error and typos, so I like to do the following.

1) Ensure the batch ID is correctly formatted the way I want. For example, 11-002.23-C1.
typo example will be 11.002.23-C1 or 11-2.23-C1 or 11-2.23.c1.  So how to fix it in the Design view Format?

2) When a Duplicate is found, I like to add another ID to show it is duplicated, like 11.002.23-C1, and I like to make the second one with ID 11.002.23-C1.1  and the third one 11-002.23-C1.2 or so far and so on. Any suggestions on how?