How to Arrange string data if both data have different spellings

Hello,

It would really depend on the data, but what you could do is try and use the following Bash script:

#!/bin/bash

# A file containing the city list with the wrong names:
wrong_names=wrong.txt

# A file containing the city list with the right names:
right_names=right.txt

# Sort the files:
wrong_names_sorted=$(cat ${wrong_names} | sort > wrong_names_sorted.txt)
right_names_sorted=$(cat ${right_names} | sort > right_names_sorted.txt)

# Compare the two sorted files side by side:

sdiff ${wrong_names_sorted} ${right_names_sorted}

Hope that this helps!

Best,

Bobby