nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding Carriage Return for formatting purposes in ArcPro Table

Confetti

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.

Najděte více příspěvků označených jako

Analysis

Desktop

Accepted answers

Confetti

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!

All comments

BenjamenWetherill

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.

Confetti

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!

Confetti

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.

Luke_Pinner

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.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.