Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this:
Table:
LOAD SubField(FieldNumbers, '-', 1) * 1 & '-' & SubField(FieldNumbers, '-', 2) as FieldNumbers;
LOAD * Inline [
FieldNumbers
0009533544-2
0005345344-0
0012445665-4
0013445332-K
];
Try this:
Table:
LOAD SubField(FieldNumbers, '-', 1) * 1 & '-' & SubField(FieldNumbers, '-', 2) as FieldNumbers;
LOAD * Inline [
FieldNumbers
0009533544-2
0005345344-0
0012445665-4
0013445332-K
];
maybe
Table:
LOAD
Replace(Ltrim(Replace(FieldNumbers, '0', ' ')), ' ', '0');
LOAD * Inline [
FieldNumbers
0009533544-2
0005345344-0
0012445665-4
0013445332-K
];
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