Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

reformat '### ##' into '#####'

hi

i need to reconvert something like this

Field1

236 23

569 74

45621

12369

x

into this:

Field2

23623

56974

45621

12369

x

thanks

1 Solution

Accepted Solutions
tresesco
MVP
MVP

try in load statement:

Num(Keepchar(Field1,'1234567890')) as Field2

View solution in original post

6 Replies
tresesco
MVP
MVP

try in load statement:

Num(Keepchar(Field1,'1234567890')) as Field2

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try num(num#(Field1)) as Field2


talk is cheap, supply exceeds demand
Anonymous
Not applicable

This is an example of Rob Wunderlich's technique, check CLEANED_TEXT after cleaning from spaces.

SpaceMap:

MAPPING LOAD repeat(' ', RecNo()), ' '
AutoGenerate 10  // up to 10 spaces
;

SAMPLE:
LOAD * Inline
[TEXT
HELLO AND            WELCOME
THIS IS A SAMPLE TEST
I       AM NOT SURE
]
;

DATA2:
LOAD MapSubString('SpaceMap', trim(TEXT)) as CLEANED_TEXT
Resident SAMPLE;

I hope this helps!

MultiView

felcar2013
Partner - Creator III
Partner - Creator III
Author

thanks it worked

felcar2013
Partner - Creator III
Partner - Creator III
Author

it also worked

thanks

felcar2013
Partner - Creator III
Partner - Creator III
Author

thanks for this one

nice solution