2 Replies Latest reply on Oct 17, 2016 12:52 PM by Michael Staton

    Remove Text from Data Source?

    Michael Staton

      I'm trying to join two data sources.  The issue I'm running into, one of the data sources has the information listed but it has a prefix in front with a "$\".  If I could remove the "$\" then the fields would match and I think I could get a join.


      Is this the best way to go about this?


      I tried the following.


      REPLACE((REPLACE(ATTR([UserName]),"$\", ""))," ", "")


      but my return field doesn't have anything.


      Also is there a program or something you can use to try and help right these statements?  That would be sweet!