Hi,
I think Anupams solution in the other post should work for you.
viewtopic.php?t=102188&highlight=
Thanks
Sam
Index Query
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Have DCount() function in the constraint to count and reject or allow the record based on the number of delimeter '*' found.
In derivation,
In derivation,
Code: Select all
If Link.InputCol[1,3] = 'LPG' Then 'NPG':Link.InputCol[4,Len(Link.InputCol)] Else Link.InputCol
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'