Hi, I'm new to using EG and I'm amending a flow built by someone who has since left. It's EG 4.3 (so a bit elderly) and the input dataset structure has changed since the flow was originally built.. I'm trying to combine address data to fit and it seems simple enough but I'm struggling. Any help that I can try would be gratefully received please! Data example: Field 1 Field 2 14 Anywhere Street, Town, County LR12 6HG I need to add the postcode into the same field as the first part of the address but with a comma after the county and before the postcode. The output should look like: Field 1 14 Anywhere Street, Town, County, LR12 6HG The output will be feeding into a subsequent code node so has to have the correct input structure or it fails. I don't know how to SAS code to try and amend the code node so I'm stuck! I've found heaps of guidance for removing commas but not for adding one in. Many thanks
... View more