Hi.
I have a lookup which contains a list of URLs and 3 more fields loaded from a CSV file:
Example:
URL, value1, value2, value3
/til/showCode.html,Personal,,Update code,
/soc/showUpdateData.html,Personal,ShowUpdate,Update profile,
/rel/changeCert.html,Admin ,Users,Change Certif,
And I have 4 multivalue fields in my logs which could contains the URLs of the list:
Example:
Field1
Value1:
/til/showCode.html (mcount n=25)
/soc/showUpdateData.html
Value2:
/soc/showUpdateData.html (count m=100)
GET/back/return.html (mcount n=200)
Field2
Value1:
/soc/showUpdateData.html | 8 3 NA
/soc/showUpdateData.html | 7 17 NA
GET/til/sd/security | 2 5 NA
Value 2:
POST/authent.html | 2 4 NA
/rel/changeCert.htm | 8 23 NA
I need to replace in the fields which could contain URLs with values that exist in the lookup. So, I need to replace the URLs with the values value1+value2+value3 in the lookup:
Field1
Value1:
Personal Update code (mcount n=25)
Personal ShowUpdate Update profile
Value2:
Personal ShowUpdate Update profile (count m=100)
GET/back/return.html (mcount n=200)
Field2
Value1:
Personal ShowUpdate Update | 8 3 NA
Personal ShowUpdate Update | 7 17 NA
GET/til/sd/security | 2 5 NA
Value2:
POST/authent.html | 2 4 NA
Admin Users Change Certif | 8 23 NA
Thanks very much for helping me.
... View more