Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 20 Jan 2009 at 2:36pm
Create a formula that looks something like this:
Replace({vp_personv42.homestreet}, '\', '')
This will get rid of all instances of the '\' character in the string. If '\' is a legitimate character somewhere else in the string, you can get rid of the last character in the string this way:
If Right({vp_person42.homestreet}, 1) = '\' then Left({vp_person42.homestreet}, length({vp_person42.homestreet}) - 1) else ({vp_person42.homestreet}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum