Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Flatfile-Field with blanks mapping to optional xml attribute
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 7th June 11:14
andreas peters
External User
 
Posts: 1
Default Flatfile-Field with blanks mapping to optional xml attribute


Hello,

i am trying to map a fixed length flatfile-field that contains blanks
to an optional xml-attribute. The attribute is non required and
shouldn't be there, if the flatfile-field is empty (contains blanks).
If there is any un-blank content in the filed, the attribute should
appear and contain the content.

Any idea ?

Greetings,
A.
  Reply With Quote


  sponsored links


2 7th June 11:14
jan eliasen
External User
 
Posts: 1
Default Flatfile-Field with blanks mapping to optional xml attribute


There is a functoid under "Logical" that is called "Exists". It
returns true if the input exists. Try connecting the input to it and
its output to the optional field in the output-specification. Remember
to also have a link between them.
--
Jan Eliasen, representing himself and not the company he works for.
  Reply With Quote
3 7th June 11:14
evyang
External User
 
Posts: 1
Default Flatfile-Field with blanks mapping to optional xml attribute


By default, we don't maintain whitespaces after parsing. You can probably
also use String length functoid to do this in combination of logical
functoid.

Sincerely,


Everett Yang
DSI - Microsoft BizTalk Server

This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn
  Reply With Quote
4 16th June 18:58
carolr
External User
 
Posts: 1
Default Flatfile-Field with blanks mapping to optional xml attribute


On the source field specification, Parse tab, set Pad
Character to SPACE (0x20) -- this way, Biztalk will
consider blanks only as 'fillers' and not data.

Regards,
Carol

contains blanks

required and

(contains blanks).

attribute should
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666