Extract numbers

[pgalvezt]

Hello,

I have this:

FieldNumbers:

0009533544-2

0005345344-0

0012445665-4

0013445332-K

I would Like to Obtain This:

9533544-2

5345344-0

12445665-4

13445332-K

Thanks!

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD SubField(FieldNumbers, '-', 1) * 1 & '-' & SubField(FieldNumbers, '-', 2) as FieldNumbers;

LOAD * Inline [

FieldNumbers

0009533544-2

0005345344-0

0012445665-4

0013445332-K

];

[maxgro]

maybe

Table:

LOAD

     Replace(Ltrim(Replace(FieldNumbers, '0', ' ')), ' ', '0');

LOAD * Inline [

FieldNumbers

0009533544-2

0005345344-0

0012445665-4

0013445332-K

];

[MarcoWedel]

Hi,

an alternative solution might be to purge the leading zeros like:

Replace(Replace(LTrim(Replace(Replace(FieldNumbers,' ','@SPACE@'),'0',' ')),' ','0'),'@SPACE@',' ')

or

Mid(FieldNumbers,FindOneOf(FieldNumbers,PurgeChar(FieldNumbers,'0')))

(see Comparing these two numbers)

hope this helps

regards

Marco