Try out the attach application. You will get a small idea. I have a small query for the above case.
You mention that you need to check starting from 1234 --- 1238 but in the third case the number is bigger one 556687-556695.
Is there any consitent way of looking into the sample data.
In my application I am not able to retrieve the type for this case.
Hope we can discuss and sort out the issue.
Sample_test.qvw 119.2 K
thanks for reply.
each row define new range and type I just explained row 1 to clarify (in my example row 3 means :
that I want to map(replace) any number that start with 556687 or 556688 .... or 556695 to string type3.)
ranges are numeric with unspecific length.
for example :
112233556699890567895463 is type4
ok. I said that each row in map is new range of starting numbers, with any length.
so it can be XXXXXXabc-XXXXXXxyz
the length of X and "abc" is diffrent for each row.
if we expand this example :
we want to map numbers that start with :
1234* to type1 1235* to type1 1236* to type1 1237* to type1 1238* to type1 1239* to type2 556687* to type3 556688* to type3 556689* to type3 556690* to type3 556691* to type3 556692* to type3 556693* to type3 556695* to type3
in input data.