Jump to content

Import text file and separate


This topic is 6474 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi Everyone!

I am attempting to import records. My source file is a text file. I need two number fields: Number field one = units, Number field two = percent. In the text file that was sent to me these two numbers are not comma or space separated. :( example a: 7584025.0000 should equal 7584 units & 25 percent. example b: 5100.0000 should equal 5 units & 100 percent. example c: 57085.5508 should equal 57 units & 85.5508 percent. Are you getting the picture?

I quess I need two calculation fields that would break apart this one big number into my two needed numbers?:)

Any ideas? It's probably an easy fix for the local FileMaker genius, but it's over my head.

Thanks, kcep

Link to comment
Share on other sites

Hi Again,

Ok I'm back.

Some of the numbers I'm importing are negative, and this throws off the calculation.

example a: -1050.0000 should equal -1 unit and 50%

example b: -12100.000 should equal -12 units and 100%.

Any thoughts?

Sorry for being a pest.

Kind regards, kcep

Link to comment
Share on other sites

This topic is 6474 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.