Skip to Content
0
Former Member
Jul 02, 2007 at 08:25 PM

Select Expert

11 Views

Post Author: waterboy550

CA Forum: General

I have made a report using one data source. This data source is a txt file with many different rows and columns. I have used formula fields to break each row of numbers into its own field. Here is my problem. About half of the rows have 0s in random places. I would like to get rid of these 0s and move the numbers up to fill in for the missing 0s. ExampleOriginal data What I want Selection expert (because there where 0s in the second row at column 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 and 4 the whole column gets2 0 2 0 2 2 2 0 2 3 2 3 2 2 2 3 0 3 3 3 3 3 0 3 removed and not just the 0 3 3 3 3 3 0 3 4 3 4 3 3 individual number)4 0 4 4 4 0 0 0 4 4

I've tried to use select expert, but if i say skip all values in row 2 that are 0s, then this will take away that column from all the rows of numbers, not just that row.

does anyone know anyway to do this?