Extract first 10 digits from a string

Since ODBC for access doesn't support user defined function I would have to perform this task within ETL PRO. Can someone please tell me how to extract the first 10 digits from a string? The string was should be only phone number but its mixed with letters and characters. Please help

You can use "Left" transformation function for that or substruct

Mike

That wouldn't work. Here is an example

lets assume I have the following string : (7`14) 452-7456 none 567

how do I transform it so it becomes 7144527395

I would need to first get only the numbers in that string then use left to get only the first 10

Can we do that here ?

You can use function called "keep characters" to get rid of all non numeric characters.
Full list of functions is in the documentation.

Mike

Thank you , I actually had to use that and the left function. I did read the document. I want to use length to give me the length of the string to check how long it is but that function will give a number and that is it. I couldn't find a function that will test the length of a string and allow me to do something

I couldn't find a function that will test the length of a string and allow me to do something

You can use "calculation" for that

Mike