Forum Discussion
Lookupvalue in same table based on two columns
Hi everyone, I have one table that contains two columns: a non-unique url and unique activity id's. These two columns are in one table and i would i like to achive a new column that return the o...
Maybe the SUBSTITUTE function?
SUBSTITUTE(<text>, <old_text>, <new_text>, <instance_num>)
New Column = SUBSTITUTE([URL],"""&[activityid]&""","{" & [activityid] & "}")Thank u so much!
- No problem, I got there eventually! 🙂