Index Query

[us1aslam1us]

Hi,

I think Anupams solution in the other post should work for you.

viewtopic.php?t=102188&highlight=

Thanks
Sam

[praburaj]

That is i did. but it is not working. plz help me. How can i do that?

[ray.wurlod]

There is no "Raise Error" in DataStage BASIC expressions. You do not appear to have a complete set of matching Else clauses. Every If must have a Then and an Else when used in an expression.

Can you re-post your code, single spaced and properly indented, surrounded by Code tags to preserve the indenting? I am having too much difficulty trying to read your code as it stands.

To determine whether there is more than one "*" it is sufficient to use the Index() function to seek the second occurrence.

Code: Select all

Index(InLink.TheField, "*", 2)

This will return 0 if there is no second occurrence, or a non-zero value (the character position in the string of the second occurrence) if found.

[kduke]

Do it in a routine. I think it would be a lot easier using a Case statement.

[kumar_s]

Have DCount() function in the constraint to count and reject or allow the record based on the number of delimeter '*' found.
In derivation,

Code: Select all

If Link.InputCol[1,3] =  'LPG' Then 'NPG':Link.InputCol[4,Len(Link.InputCol)] Else Link.InputCol