DSXchange

Thanks guys. FIELD worked like a charm!

In a Transformer stage

I have a field defined as Varchar (50) which contains values like

CBAIB\jon
CBAIB\fred
PBS\jon
XXXX\xxx

I need to strip off the \ and all characters preceding it so the output will look like

jon
fred
jon
xxx

Can someone point me in the right direction?

Thanks in advance.

Thanks, guys.

I tried:

FieldName[1:1] = 7

FieldName[1,1] = 7


Don't laugh................... I am an old mainframe programmer....

We have a pipe-delimited source file. One of the fields is defined as integer. We want to filter the file and only keep records where the 1st character of this integer field is 7 e.g 7, 777, 700000 I can't seem to get this to work in a Filter stage. Can anyone give me some tips? Thanks in advance.

New to datastage.

I want to temporarily "disconnect" last few stages from a job during testing.

We have been making a copy of the job and manually deleting the last few stages.

Is there a 'better' way?

Is it possible to somehow tell it only run certain stages?

Thanks in advance.