Field contains mix of numbers and letters

[#1]

In one fields in my qvd file, the information contains a mix of numbers and letters, such as for eaxmple "0001825547 Arla Foods".

When reading the qvd-file I'd like to omit the number, which *always* is 10 digits and a space, and only read "Arla Foods" when I create tables - have been pulling my hair for a few hours on this now, so any help would be greatly appreciated. [:)]

[#2]

Hello,

try this:

Load .... Mid(YourField, 11) AS YourField;

Regards, Roland

[wizardo]

hi,

im not sure if it is faster or not but its worth a shot:)

if the part of the field that you want to keep, never contains digits then you could try this function that might be faster then the mid()

purgechar ( [Your mixed field],'1234567890' )...