Hi, I have just had the same experience, especially if you try to use other functions within the concat function. I ended up using target SQL function instead and that worked fine for me. I would definitely recommend that, will save you lots of time.
Regards Jiri Pospisil From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Gandhi, Sulabh Sent: 04 July 2011 14:41 To: [email protected] Subject: Concat function in AIE ** Hi All, I have query regarding concat function in AIE. I am using concat function as [function|concat("FOLKSAM","/",upper($employee.City$),"/",upper($employee.StreetAddress$))] but it concatenate only first 2 parameters like "FOLKSAM/CITY NAME", it does not concatenate 4th (/)and 5th (StreetAddress)parameter. I also tried using nested concat function as[function|concat("FOLKSAM","/",concat(upper($employee.City$),"/",upper($employee.StreetAddress$)))] but it also doesn't work and records are not created in the form. Is it the correct way of using concat function, please suggest. Thanks in advance. Regards, Sulabh Gandhi | One ITSM 4th Floor, DLF IT Park,Block 5, Manapakkam, Chennai - 600089 | India T :+44 20700 36138 [email protected]<mailto:[email protected]> | www.logica.com<http://www.logica.com/> Logica Pvt Ltd, registered in India (registered number U30007KA1998PTC023830) Registered Office: 124-125, Divyasree Technopolis, Off Airport Road, Bangalore - 560 037 Think green - keep it on the screen. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited and/or LCH.Clearnet SA. If you are not an intended recipient please delete this e-mail and notify [email protected]. LCH.Clearnet Limited, LCH.Clearnet SA and each other member of the LCH.Clearnet Group accept no liability, including liability for negligence, in respect of any statement in this email. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited and/or LCH.Clearnet SA makes no contractual commitment save where confirmed by hard copy. Cet e-mail et toutes les pièces jointes (ci-après le "message") sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, est interdite, sauf autorisation expresse de LCH.Clearnet Limited et/ou LCH.Clearnet SA. Si ce message vous a été adressé par erreur, merci de le détruire et d'en avertir immédiatement [email protected]. LCH.Clearnet Limited, LCH.Clearnet SA et les autres entités du groupe LCH.Clearnet Group, ne peuvent en aucun cas être tenues responsables au titre de ce message à moins qu’il n’ait fait l’objet d’un contrat signé. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com LCH.Clearnet SA, Siège Social, 18 rue du Quatre Septembre, 75002 Paris, Chambre de Compensation conformément au Code Monétaire et Financier. ************************************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
