Notifications
Clear all
Topic starter
Hello Chuggers,
Any help on this would be awesome. I am currently pulling into a VFE form a data display with DOCUMENT.VISITID. Our value in the visitID field looks something like this: 600002142.500002029. In the data display I only want it to show the part after the period. So, I only want to see 500002029.
Can anyone share with me how to grab just part of this string?
Thanks,
Crystal
Posted : July 17, 2017 6:57 am
This is a little messy, but it might work.
{sub( DOCUMENT.VISITID , match(DOCUMENT.VISITID,"."), size(DOCUMENT.VISITID)- match(DOCUMENT.VISITID,"."))}
You may want to add some error checking if document.visitid is blank.
-James
Posted : July 17, 2017 10:58 am
{sub( DOCUMENT.VISITID , match(DOCUMENT.VISITID,".")+1, size(DOCUMENT.VISITID)- match(DOCUMENT.VISITID,"."))}
Edit to get rid of the decimal point.
Posted : July 17, 2017 11:02 am
Topic starter
This worked perfectly James. Thank you so much!!!
Posted : July 18, 2017 2:41 am
The way I would normally handle this is by splitting it on the period.
local arrVisitId = getfield(DOCUMENT.VISITID, ".", "")
return arrVisitId[2]
Posted : July 20, 2017 8:56 am
This one is much more elegant.
-James
Posted : July 21, 2017 2:00 am
