regular expression in datastage

[Sgiri1]

I need to use regular expression to strip words from the i/p sequential file stage using regular expression. which stage in datastage can be used for regular expressions?

[ray.wurlod]

Sequential File stage. Use a Filter command, perhaps with grep, sed or awk. The stage then reads the output of the filter command.

[kduke]

Someone posted a PX routine to do this as well. Do a search.