>I runned some more test an notice that
>
>It can import direct from a charcter field if
>there is not anything between numbers
>
>I must run before appending:
>
>if c_field type = "C"
>replace all c_field with onlynumbers
>
>is there a function for this ?
The function I gave you before. If you want to get rid of any character that is not a digit, you have to eliminate digits first, and use the remainder as a "mask" for chrtran(), i.e., to indicate what characters to eliminate. In the following example, variable x contains non-digit characters:
x = "123/456-789"
? chrtran(x, chrtran(x, "0123456789", ""), "")
replace all MyField with chrtran(MyField, chrtran(MyField, "0123456789", ""), "")
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)