• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

I need help moving a decimal place

New Here ,
Sep 08, 2008 Sep 08, 2008

Copy link to clipboard

Copied

Good morning all. I have the following that needs manipulating. The first set of numbers is the raw data I have access too.

Latitude: 3.13929
Longitude: -8.14461

I need it formatted like this:

Latitude: 31.3929
Longitude: -81.4461

I need to move that decimal place to the right one spot. Any ideas? I have thought of REPLACE, create new value and insert but my head hurts. I just need some ideas.

Thanks
Terry
TOPICS
Advanced techniques

Views

408

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 08, 2008 Sep 08, 2008

Copy link to clipboard

Copied

Mulitply it by 10.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 08, 2008 Sep 08, 2008

Copy link to clipboard

Copied

Multiply it by 10:

<cfset Latitude = 3.13929>
<cfset NewLatitude = Latitude * 10>
<cfset Longitude = -8.14461>
<cfset NewLongitude = Longitude * 10>

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Fordwebs, LLC
http://www.fordwebs.com


"WhozitsPop" <webforumsuser@macromedia.com> wrote in message
news:ga3elo$1ju$1@forums.macromedia.com...
> Good morning all. I have the following that needs manipulating. The
> first set
> of numbers is the raw data I have access too.
>
> Latitude: 3.13929
> Longitude: -8.14461
>
> I need it formatted like this:
>
> Latitude: 31.3929
> Longitude: -81.4461
>
> I need to move that decimal place to the right one spot. Any ideas? I
> have
> thought of REPLACE, create new value and insert but my head hurts. I just
> need
> some ideas.
>
> Thanks
> Terry
>
>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 08, 2008 Sep 08, 2008

Copy link to clipboard

Copied

Brilliant and I feel like a 1st grader now :)
Thanks Dan.

Terry

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 09, 2008 Sep 09, 2008

Copy link to clipboard

Copied

WhozitsPop wrote:
> Brilliant and I feel like a 1st grader now :)
> Thanks Dan.
>
> Terry

Don't be *too* hard on yourself. I think decimals come in Second Grade. :)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 09, 2008 Sep 09, 2008

Copy link to clipboard

Copied

LATEST
Ha! That's an excellent point.
Terry

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation