DSXchange

:? Hi, trying to think of a way to look for the occurrence of something. If I find DBA I want to split everything after DBA into a seperate record and get rid of any spaces after DBA. eample I have one field that contains BOB MARLEY DBA JAMAICA ISLAND TOURS but need to turn it into this (2 records)....

It is using all default partitioning. It seems the issue is related to a join in the job. If I change the join to a lookup I no longer get this message.

That is the entire error message, nothing has been removed or changed. I copied that straight out of the log and pasted it. The error message does not provide much detail.

cs}}},1: Fatal Error: An index is out of bounds.

Here is the exact error message.

cs}}},1: Fatal Error: An index is out of bounds.

Thanks for reading. Here is more information Datastage PX 7.5.1 Unix 5.3 The error happens just after a funnel stage. The funnel stage is reading data from 5 files. One of the files are processed through a trasformer first before going into the funnel. DB2 tables are in the job, but the job aborts b...

What is this error trying to tell me? What might cause this error?

An index is out of bounds.


Thanks for our help!!!

How can we do this in a Transformer not Basic Transformer?

We can't use a BASIC Transformer here at our company. We are using a Transformer stage not a Basic Transformer stage. Ascential told us not to use Basic Transformer. We also have had many issues with the Basic Transformer. How can we do this in a Transformer not Basic Transformer.

Hi thanks or the info. We don't know what in the field. It's a free form filed. All we know is we need to get rid of any occurence of attn or c/o. In java we would use something like StringUtil.replace("&",xml,"&"); - in field called xml, replace all & with &amp. ...

Hi thanks or the info. We don't know what in the field. It's a free form filed. All we know is we need to get rid of any occurence of attn or c/o. In java we would use something like StringUtil.replace("&",xml,"&"); - in field called xml, replace all & with &amp. ...

Hi, we need to replace the enite string xyz. .

Example -

We currently have

attn richard
or
c/o richard

We want to remove attn and c/o and replace with spaces.

richard
richard

Convert appears to be a single character conversion instead of a substring conversion.

Thanks for reading!

In a transformer stage I want to search a string for XYZ and replace with spaces. How can I do this without building a routine?


Thanks

Thanks DSguru2B and everyone else who replied. I greatly appreciate your help.

If I go to columns tab right click on the timestamp column and select 'edit row' I can see where I can set a mask, but not sure what you mean by 'extended properties'?