Hi,
I have some supplier names that showing up as strange characters.

eg:
SQL TABLE --> MASTER FILE
AMP’ED --> AMP’ED

I tried
DEFINE SUPPLIER_NAME_CLEAN/A100V = CTRAN(100, SUPPLIER_NAME, BYTVAL('’','I6') , 32,'A100');

but it only converts the first character to "space"
i.e.
AMP €™ED


Not sure how to deal with this situation.
the reason why I want to convert it into space so that we dont have issues when filtering reports based on "Supplier_Name"

Thanks

This message has been edited. Last edited by: BM,

If you want to convert a string to a single space use STRREP not CTRAN.

However, I would be checking why you're getting passed that string.

T

quote:

STRREP

Thanks.. STRREP worked
yes,not sure why its being passed like that

quote:

Originally posted by Tony A:
If you want to convert a string to a single space use STRREP not CTRAN.

However, I would be checking why you're getting passed that string.

T

I tried STRREP and took a look at the SQL TRACE and below is the message I see.


(FOC2567) FUNCTION STRREP CANNOT BE CONVERTED TO SQL

Is there a SQL friendly replace string function.

I was able to use SQL.REPLACE and all good

Thanks