Join actions for arrays
A common problem when working with arrays is how to combine the values into one string. This is often used when working with CSV or XML files, and especially when working with Excel spreadsheets. In the following example, we are converting a one-dimensional array into a string, using commas to make it Comma Separated Value (CSV) format so that it can be used in Excel or as part of a system data import:
Figure 5.15 – Join action converting an array to a string
Of course, it is always handy to be able to split a string and one of the reasons for this would be to do the reverse of the preceding steps.