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