Use of trim and Data-type Conversion through Functoid

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Use of trim and Data-type Conversion through Functoid

Viewing 2 reply threads
  • Author
    Posts
    • July 27, 2010 at 2:31 AM #25385
      community-content

        I have to build a schema from a flat file in which a set of columns have amount tagged as “$ 400”. While building the schema, i have to use the data type for these things as string.But, while mapping, i want to have only 400, not the “$” sign and also, the data type has to be changed to decimal.

        One of my colleague suggested the use of trim and conversion functoid as the panacea.

        But, we haven’t worked on it yet. How is that to be achieved?

        Thanks in advance.

      • July 27, 2010 at 2:58 AM #25387
        community-content

          Hi.

          For this I also use the string functoid.

          First a “string find” fanctoid with “$”-sign you looking for.

          Then a “substraction or addition functoid” to move the pointer to the right position

          After this I use a “string left or string right functoid” to the rest of the value I want.

          In your case I would suggest to use at last a “String right trim” to remove leading spaces behind your “$”-sign.

          I hope this helps.

          Wolfgang  

        • November 19, 2020 at 10:56 PM #50496
          biztalkgurus

            First Frost ~ Sarah Addison Allen ~ 9781250190970

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