data value split

http://www.google.com/accounts/VE?service=groups2&c=CNHcx6iS7qrZ0AEQsYSqltP04cOtAQ&hl=en
I have data like
Return|Item
Cancelled|Item [CFY]
Gifts
I would like to display
if data has | then display it in two text box
like Textbox1 Return
Textbox2 Item
if data does not have | then display the "field value" in
Textbox1 and
Textbox2 should be ""
any help would be nice
thanksThe instr, left, right, and iif functions should get you there.
one piece:
=left(field,instr("|")-1)
Mike G.
<aajay78@.hotmail.com> wrote in message
news:1190911497.216601.202900@.d55g2000hsg.googlegroups.com...
> http://www.google.com/accounts/VE?service=groups2&c=CNHcx6iS7qrZ0AEQsYSqltP04cOtAQ&hl=en
> I have data like
> Return|Item
> Cancelled|Item [CFY]
> Gifts
> I would like to display
> if data has | then display it in two text box
> like Textbox1 Return
> Textbox2 Item
> if data does not have | then display the "field value" in
> Textbox1 and
> Textbox2 should be ""
> any help would be nice
> thanks
>

Data type validation

Hi all,

I want to make a conditional split based on the data type provided by the input.

For example : If the comming (Column x) is of data type (numeric) then pass , else do not pass.

(pass = Case 1

Do not pass = Case 2).

Is there any way for doing so ?

You can use conditional split transformation for this.

The following link will help you get started
http://technet.microsoft.com/en-us/library/ms137886.aspx

Thanks

|||

I think Data Convertion transform is the easiest way to do this, see this for details:

http://technet.microsoft.com/en-us/library/ms186792.aspx

You would read the data as string, then try to convert it to numeric. Configure Error Disposition to redirect row. The "pass" will go to default (green) output, the rows that do not pass will go to error output.