This discussion is archived
3 Replies Latest reply: Nov 30, 2012 2:26 AM by Ronny RSS

Using Replace Function

Ronny Newbie
Currently Being Moderated
Hi All,

I have a column called latepayment and it has values like

1. payment is > 90 days
2. payment is < = 10 days

Now I want to use Replace function to replace > and < to 'greaterthan'
and 'lessthan' resp but the issue is that in replace function I can give only one argument. So what I am doing is in the fx area for the column

Replace(latepayment,'>','greaterthan')

this replaces the > sign very well with greaterthan string and show me values like

1. payment is greaterthan 90 days
2. payment is < = 10 days

but I want to replace < to 'lessthen' too, how can I do that? Can I write two replace statements? How can replace multiple string or special characters for a single column?

Please help.

Thanks,
Ronny

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points