Forum Discussion
Thank you JackLacava, you've confirmed my suspicions. In my case, it sounds like I need to either move the work done in the complex expressions to the Connector rule itself, or "cleanse" the data in the Connector rule to remove the commas to avoid the parsing corruption. Just as an fyi, I can't use UD's because the data being imported is for TXM so it's being imported into attributes. Thanks so much!
So how have you fixed this situation ? I have similar problem too
- HeatherB_eCap6 months agoContributor III
Hi MardayT, in my connector business rules, I use Replace statements to remove commas from all fields that might contain it. Then, you can use the args.line.split command in complex expressions to reference field values. Note that connector data sources appear to sometimes append empty spaces to the end of field field values, so I usually include .Trim statements as well to get rid of those. Hope that helps!
Related Content
- 2 years ago
- 4 months ago
- 3 months ago