Discussion board where members can get started with QlikView.
I have a field that i want to load in my tables.
It is like "123456******7890".
I want to create a new field be removing one of the asterisks
and another by removing the first digit after the asterisks ( in this example the digit 7).
Go to Solution.
Look into the QV string functions section in the HELP file.
Your two expressions for the new fields might look like
replace(Number,'******','*****') as NewNumber1,
left(Number,len(Number)-4)&right(Number,3) as NewNumber2,
Depending on the format of the Number field, you might also want to look into index(),findoneof() etc.
If your string has a variable lenght and the field name is for example myField you can use
Hi there, thank you for your reply.
The field has a fixed length of 16 digits. Using the code that you gave me it completely removes the last four digits.
I just want yo remove the fourth from the last and keep the last three.
LOAD * INLINE [
replace(F1,'******','') as Number1,
replace(F1,'7','') as Number11,
left(F1,len(F1)-10) & right(F1,4) as Number2