Gossamer Forum: Products: Gossamer Links: Discussions: Clean number

Dec 16, 2009, 5:19 AM

nir

User (396 posts)

Dec 16, 2009, 5:19 AM

Post #1 of 7

Shortcut

Clean number

If I have number like 07693086 that begin with 0 or 007693086 that begin with 00, who can I get the number without the 0 in the binging even if there 000; the zero in the middle or the end must stay.
So I will send this number 007603086 and get 7603086

Dec 16, 2009, 5:38 AM

Andy

Veteran / Moderator (18441 posts)

Dec 16, 2009, 5:38 AM

Post #2 of 7

Shortcut

Re: [nir] Clean number In reply to

Should be pretty simple :)

remove_leading_zeros

Code:
sub { 
   my $num = $_[0]; 
  $num =~ s/^0+//g; 
  return $num; 
}

Then call with:

<%remove_leading_zeros($number_field)%>

Cheers

Andy (mod)
andy@ultranerds.co.uk

Dec 17, 2009, 5:34 AM

nir

User (396 posts)

Dec 17, 2009, 5:34 AM

Post #3 of 7

Shortcut

Re: [Andy] Clean number In reply to

Thanks

In globule what is the code to see if the number 14600159 is in 00014600159
I try this but it not work
$cond->add('num' => Like => $temp);

Dec 17, 2009, 7:17 AM

Andy

Veteran / Moderator (18441 posts)

Dec 17, 2009, 7:17 AM

Post #4 of 7

Shortcut

Re: [nir] Clean number In reply to

$cond->add('num' => Like => "%$temp"); ...should work

However, that would also match:

222214600159

...etc

I'm not sure how you would make % actually only match if the number if "0".

Cheers

Andy (mod)
andy@ultranerds.co.uk

Dec 20, 2009, 6:04 AM

nir

User (396 posts)

Dec 20, 2009, 6:04 AM

Post #5 of 7

Shortcut

Re: [Andy] Clean number In reply to

Thanks:)

Dec 27, 2009, 11:31 AM

nir

User (396 posts)

Dec 27, 2009, 11:31 AM

Post #6 of 7

Shortcut

Re: [Andy] Clean number In reply to

Is there a way that this global will clean the first and the end zero. like 00930084700 will be 9300847?

Dec 27, 2009, 11:25 PM

Andy

Veteran / Moderator (18441 posts)

Dec 27, 2009, 11:25 PM

Post #7 of 7

Shortcut

Re: [nir] Clean number In reply to

Simple:

Code:
sub { 
  my $num = $_[0]; 
  $num =~ s/^0+//g; 
  $num =~ s/0+$//g; 
  return $num; 
}

Cheers

Andy (mod)
andy@ultranerds.co.uk