Regarding Content validation

[veera24]

Hai Everyone,

Example:

Filed name: POLICYNO
Value of POLICYNO: 1234, 1234-01,1234-02,342345,464556-02.

Is there is any Substring function exist in Datastage to get the value before "-" in the above said example.

Thanks in advance....

[ray.wurlod]

Yes and it's exactly the same function as in your other post.