Dear all expert,
i need to make one of the field link to a web url once end user click on it. But i duno how to use the concatenate function since the URL is quite long.
The example is as:
http://sbdevcrm.silverstone.com.my:8000/sap/bc/contentserver/020?get&
pVersion=0046&
contRep=CRMORDER&docId=DFAB31A583CDF1F1BD9E005056A1554D&
compId=Logo.jpg&
accessMode=r&
authId=CN%3DCR1&expiration=99991231235959&
secKey=MIH4BgkqhkiG9w0BBwKggeowgecCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGBxzCBxAIBATAZMA4xDDAKBgNVBAMTA0NSMQIHIBAHGQISUDAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTEwMTA3MDYzMTA0WjAjBgkqhkiG9w0BCQQxFgQUrjTK9qbkl60OovmDRfUFYN5PBCMwCQYHKoZIzjgEAwQvMC0CFQC13oWG9qN9TtekzRCqLaOg7VsdHwIUWALOOyi7L0%2BxjriG34ULOmLlNeo%3D
How can i concatenate this? what i mean is like eg.: =concatenation("http://sbdevcrm.silverstone.com.my:8000/sap/bc/contentserver/020?get&pVersion=";concatenation(Replace({CRMORDERLOIO.VERSION});"&contRep";concatenation(Replace({CRMORDERLOIO.REP});"∁ID";concatenation(Replace({CRMORDERLOIO.LOG_ID});"accessMode=r&authid=";concatenation(Replace({CRMORDERLOIO.AUTHID});"&secKey";concatenation(Replace({CRMORDERLOIO.SECID}))