How to suppress leading zeros

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to suppress leading zeros

Viewing 2 reply threads
  • Author
    Posts
    • January 18, 2007 at 1:10 PM #17305
      community-content

        Hello,

          is there a way to suppress leading zeros when converting a flat file.

         I get a string like this:  0000000023

        And I just want to pass the 23 onto the database.

         

        Any ideas ?

         

        Thanks,

        Larry H.

      • January 18, 2007 at 3:38 PM #17308
        community-content

          Did you try to simply convert it to a number?

        • January 19, 2007 at 3:02 AM #17313
          community-content

            Larry,

            BizTron's idea seems pretty good.

            I was thinking (a) a map with a functoid, or (d) a custom pipeline component – both very heavy for what you want. You could also do it in an expression shape, I guess.

            When you actually put the value in the database you could also fix it then.

            John D.

            • January 26, 2007 at 6:54 AM #17441
              community-content

                The table I was inserting to was set to a decimal so it chopped off all the leading zeros.  Thanks for the replies !

          • Author
            Posts
          Viewing 2 reply threads
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.