>Hi everybody,
>
>I have records with different formatting. Some have 108-11 65 Rd, which is correct, and some 8083 118 St, which is wrong. I'd like to insert a dash between first 2 or 3 numbers and then last 2 before the first space, e.g.
>
>10880 would become 108-80
>1080 would become 10-80
>
>I also have - inserted already in ~30% of records, which need to be preserved...
>
>Is it possible?
>
>Thanks in advance.
Since you also use Visual FoxPro, it might be easier to read the value in VFP, give it the correct formatting, and then write it back - one cell at a time.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
