Combine two text fields line by line
I want to combine text from two fields on a line by line basis. I have two multiline text fields, call them "Dates" and "Alpha". "Dates" is a column of dates, formatted "MM/DD/YYYY" "Alpha" ...
Forum Discussion
That would not result in the line by line concat as above, based on my experience with excel.
- I see no reason why not? You say that the two tables have an equal number of records. So place the two original data field columns side by side, enter the formula in at the head of column three and copy the formula down. Therefore the new field will be generated line by line.
- This issue is that the multiline text for each field value would be in once cell. You would have to bust each multiline text value out into individual cells first to concatenate in the manner you describe.
- The above is correct; each set of dates and alphas is in one cell, so extract and reload this way won't work.
