Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try in load statement:
Num(Keepchar(Field1,'1234567890')) as Field2
Try num(num#(Field1)) as Field2
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
thanks it worked
it also worked
thanks
thanks for this one
nice solution