How to Replace the "bad" data with the '*" c

[ArndW]

What happened? The function as you posted will strip out all non-displayable characters and replace them (as well as the period) with stars.

[kcbland]

You can always use the CONVERT statement, which is rather cool. It takes a string of characters and changes the each value to a correlated value in another string.

Example:

Code: Select all

CONVERT "ABC" TO "123" IN yourstring

This would change all occurrences of "A" to a "1", "B" to a "2", and "C" to a "3".

So,

Code: Select all

CONVERT "ABC" TO "123" IN "CxBxA"

produces

Code: Select all

3x2x1

You can do something like write a custom function:

Code: Select all

changestr=CHAR(a):CHAR(b):CHAR(c):CHAR(d)
**where a,b,c and d are ASCII chart numbers for your bad chars
Ans=Arg1
CONVERT changestr TO STR("*",len(changestr)) in Ans

[venugopal81]

Hi ArndW,

No change in output. I have checked with other function which you have suggested in previous posts that is
Convert(svControlSet0, svSpaces, inlink.Columnname)
Still we have received same data in output.

Thanks&regards
venu

[venugopal81]

Hi ArndW,

No change in output. I have checked with other function which you have suggested in previous posts that is
Convert(svControlSet0, svSpaces, inlink.Columnname)
Still we have received same data in output.

Thanks&regards
venu

[ArndW]

I wrote a 1-liner with your code, replacing "Input Link" with my routine variable and it worked as expected. If you cut-and-pasted your original line then you have a problem with the embedded blank between Input and Link.

[ketfos]

Hi
You can also check with the following fucntion.

Since this type of data has char values greater than 122 and less than 65,
you may use condition as

if char(Arg1) < 65 or char(Arg1) > 122 then "****" else Arg1

Ketfos