|
Home > Archive > BizTalk Server Orchestration > January 2005 > prepending data to a schema
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
prepending data to a schema
|
|
| BillOlmstead@comcast.net 2005-01-21, 5:50 pm |
| In an orchestration, I am reading in a flat file that contains multiple
records (File Adapter, pipeline, and schema are defined) and output an
xml file. It all works fine.
However, now I want to alter one of the fields of every record to
prepend an asterisk (*) to the data from the flat file. Is there a
functoid that can do this ? Or should a transform be used ? Do I have
to loop through every recrod ? Conceptually, how would this best be
accomplished?
Note that the each of the fields is comma delimited and is surround
with double quotes and each record (line of the file) is CRLF
delimited:
e.g.
"1","data1","3","4","5"<CRLF>
"6","data2","8","9","10"<CRLF>
| |
| Matt Milner 2005-01-21, 8:47 pm |
| The easy answer is to use the string concatenate functoid in map, but there
are probably other alternatives.
Matt
<BillOlmstead@comcast.net> wrote in message
news:1106344038.013992.273400@z14g2000cwz.googlegroups.com...
> In an orchestration, I am reading in a flat file that contains multiple
> records (File Adapter, pipeline, and schema are defined) and output an
> xml file. It all works fine.
>
> However, now I want to alter one of the fields of every record to
> prepend an asterisk (*) to the data from the flat file. Is there a
> functoid that can do this ? Or should a transform be used ? Do I have
> to loop through every recrod ? Conceptually, how would this best be
> accomplished?
>
> Note that the each of the fields is comma delimited and is surround
> with double quotes and each record (line of the file) is CRLF
> delimited:
> e.g.
>
> "1","data1","3","4","5"<CRLF>
> "6","data2","8","9","10"<CRLF>
>
| |
| Bill Olmstead 2005-01-22, 2:47 am |
| I looked at the string concatenate functoid, but it didn't appear that
I could prepend static text. Have you done this before ?
Matt Milner wrote:
> The easy answer is to use the string concatenate functoid in map, but
there[vbcol=seagreen]
> are probably other alternatives.
>
> Matt
>
>
> <BillOlmstead@comcast.net> wrote in message
> news:1106344038.013992.273400@z14g2000cwz.googlegroups.com...
multiple[vbcol=seagreen]
an[vbcol=seagreen]
have[vbcol=seagreen]
| |
|
| It appeared that the concatenate String functoid would concatneate
different source fields into the destination schema
| |
| Nabeel Prior 2005-01-22, 5:48 pm |
| Bill, at what stage of the process are you wanting to prepend the *?
If you want to prepend before the flat file is parsed into XML you will
require a pipeline component. If you are looking to prepend once the XML
has been created you should be able to use the string concat functoid in the
map. To add the asterisk to the source field:
1. Place the string concat functoid on the grid.
2. Display the input parameters window, and at the top of the window click
on the icon that looks like a square with a star in the top-right of the
square.
3. this should have added a new line to the parameters list, and you can
type in the * here.
4. close this window, and link the source field to the functoid.
--
Kind Regards,
Nabeel Prior
Web: http://www.brainjar.co.za
Blog: http://www.brainjar.co.za/blog.aspx
"Bill" <BillOlmstead@comcast.net> wrote in message
news:1106373444.438665.36290@f14g2000cwb.googlegroups.com...
> It appeared that the concatenate String functoid would concatneate
> different source fields into the destination schema
>
| |
|
| Thanks, that worked.
Nabeel Prior wrote:
> Bill, at what stage of the process are you wanting to prepend the *?
>
> If you want to prepend before the flat file is parsed into XML you
will
> require a pipeline component. If you are looking to prepend once the
XML
> has been created you should be able to use the string concat functoid
in the
> map. To add the asterisk to the source field:
> 1. Place the string concat functoid on the grid.
> 2. Display the input parameters window, and at the top of the window
click
> on the icon that looks like a square with a star in the top-right of
the
> square.
> 3. this should have added a new line to the parameters list, and you
can[vbcol=seagreen]
> type in the * here.
> 4. close this window, and link the source field to the functoid.
>
> --
>
> Kind Regards,
>
> Nabeel Prior
> Web: http://www.brainjar.co.za
> Blog: http://www.brainjar.co.za/blog.aspx
>
>
> "Bill" <BillOlmstead@comcast.net> wrote in message
> news:1106373444.438665.36290@f14g2000cwb.googlegroups.com...
|
|
|
|
|