This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i need to reconvert something like this
try in load statement:
Num(Keepchar(Field1,'1234567890')) as Field2
View solution in original post
Try num(num#(Field1)) as Field2
This is an example of Rob Wunderlich's technique, check CLEANED_TEXT after cleaning from spaces.
MAPPING LOAD repeat(' ', RecNo()), ' 'AutoGenerate 10 // up to 10 spaces;SAMPLE:LOAD * Inline[TEXTHELLO AND WELCOME THIS IS A SAMPLE TEST I AM NOT SURE];DATA2:LOAD MapSubString('SpaceMap', trim(TEXT)) as CLEANED_TEXTResident SAMPLE;
I hope this helps!
thanks it worked
it also worked
thanks for this one