Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am working on customer data where the mobile number filed needs to be clean before matching to other tables. I want to clean numbers that start from +91 or 91 which is country code. The following data and output example will clear all that its to be look like so some data points have +91 at starts and some have only 91 and some data point consist of space after country code. i want final output to be only a 10 digit mobile number please help me I am new to qlik sense.
Ex.
Data output
1. +919898989898 = 9898989898
2. 919898989898 = 9898989898
3. 91 9898989898 = 9898989898
Maye be
right(Field,10) as NewField
output :
Maye be
right(Field,10) as NewField
output :