3 Replies Latest reply: Nov 30, 2012 4:26 AM by Ronny RSS

    Using Replace Function

    Ronny
      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