alternative to Oconv

[hitmanthesilentassasin]

Hi,

I was trying to replace the control characters for which oconv does the job:

Code: Select all

oconv(inputfield, "MCP)

However, is there an alternate to this to be done in parallel transformer as I am having trouble with basic transformer timestamp columns.

I have tried the Convert function which truncates all the remaining characters after the control character.

I dont know the list of control characters hence, need to restrict to all the complete printable ascii characters.

Thanks for your help!!

[ray.wurlod]

There is no easy alternate for the Parallel Transformer stage.

You could build a list of all non-printing characters (using Char() functions) in the initialization expression of a stage variable and a corresponding list of that many dots in the initialization expression of another stage variable, and use the Convert() function with these stage variables as the first two arguments.

[hitmanthesilentassasin]

that doesn't look so neat way, anyway it confirms that there is no alternate to that. thanks for your response :D

[chulett]

I am having trouble with basic transformer timestamp columns.

What kind of problem, exactly? Sometimes best to start with the problem rather than your perceived solution to it.

[priyadarshikunal]

I faced problems with timestamp with microsecond when passing through a basic transformer, it was in version 8.0 and cant remember what I did to get through it.


However, what is the point in using a basic transformer if it can be done using double convert easily.

[ray.wurlod]

Double convert can only easily eliminate unwanted characters. The original requirement was to convert them to ".".