BusinessObjects Board

Find the first Number in String

I am working on a Webi report and the mapping for one of the columns I need to
Find the FIRST occurrence of a number, force a carriage return(new line)
Then check another column if it meets the criteria I need to build out the column as…

First: Test12345
Force CR: Test
12345

Check column: If Table.Thisisit = “Yes” then NEW so… do the following:

Column HeaderName
TestNEW
12345