Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Extracting Quantity

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to be able to extract the quantity (the number before the comma) and amount (the numbers after the comma. The info is downloaded from a mainframe system in a text file. Example:

    ,00000000000000004.0000,0000000000040.00,

    I want to be able to strip out 4.0 for quantity and 40.00 for amount. Utilizing the left and right functions will take forever. Any help would be greatly appreciated.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about just using Data>Text to columns , with comma as the delimiter? Then format the two columns you'll be left with as you want.

    Rgds
    Alex

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •