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>

[ Post a follow-up to this message ]

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>
>

[ Post a follow-up to this message ]

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] 

[ Post a follow-up to this message ]

It appeared that the concatenate String functoid would concatneate
different source fields into the destination schema

[ Post a follow-up to this message ]

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
>

[ Post a follow-up to this message ]

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... 

[ Post a follow-up to this message ]