Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Convert number in brackets/number in parentheses to numbers with sign

  1. #1

    Default Convert number in brackets/number in parentheses to numbers with sign

    Hi

    I get a file with amounts in $###.##;($###.##) from text file. How do I convert to numbers with sign and remove "$" currency?

    Thanks

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    My first try
    Attached Files Attached Files
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.