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

[felcar2013]

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

[tresesco · Accepted solution]

try in load statement:

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

[Gysbert_Wassenaar]

Try num(num#(Field1)) as Field2

[Anonymous]

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]

thanks it worked

[felcar2013]

it also worked

thanks

[felcar2013]

thanks for this one

nice solution