I need a table in a layout where each Value in the cell is proceeded by a carriage return. How is this accomplished? The current format in the final data frame is adjust by a python script using .agg(', '.join) to get the commas.
Instead of:
11 D3, 11 D4, 11 C3, 11 C4
I want:
11 D3
11 D4
11 C3
11 C4
By changing the column width, it adjusts the other columns as well and I do no want the others to be shortened. I am not against solutions in excel, but I don't see why this can't be handled in Pro. Thanks.
Solved! Go to Solution.
I'm unsure if I can include this in my original Notebook but .replace() worked as a Python 3 expression in the field calculator. Consider this case closed!
Have you tried inserting a newline .agg('\n'.join) instead of a comma? If that doesn't work, you may need to reduce the column width and enable word wrapping.
I have tried this. The result is adding \n as a string so that I get 11 D3\n11 D4\n11 C3\n11 C4. The issue with shortening the columns is that I cannot individually shorten the one column, it would shorten the other column as well which would not be desired. Also because of the variance in 1-2 character 'words' separated by spaces, it would be almost impossible for them to all start a new line at the correct character.
I'm unsure if I can include this in my original Notebook but .replace() worked as a Python 3 expression in the field calculator. Consider this case closed!
I've found that Shift-Enter and "<br>" seem to work within ArcPro.
But, "<br>" doesn't pass from ArcPro to Excel in the Table to Excel tool. I need to pass a carriage return from ArcPro to Excel and then to Google MyMaps. Shift-Enter does seem to work.