Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Adding new line character to schedule.

6 ANTWORTEN 6
Antworten
Nachricht 1 von 7
halukuzuner
424 Aufrufe, 6 Antworten

Adding new line character to schedule.

Due to submission requirements I need to combine parameters. It is easy in Revit. But I want to add new line character between each parameter in order to see them in one cell in Excel. Is there a way to do it with Revit's native functionality?

 

halukuzuner_0-1686147099025.png

 

6 ANTWORTEN 6
Nachricht 2 von 7
ToanDN
als Antwort auf: halukuzuner

Add them to Separators in the combine parameters dialog.

Nachricht 3 von 7
halukuzuner
als Antwort auf: ToanDN

I have already added separator. Separator doesn’t add new line.

Nachricht 4 von 7
anze.kumar
als Antwort auf: halukuzuner

Maybe you have an issue because the line is sometimes a representation of "minus" (shorter line) and other times as "separator" (longer line).

anzekumar_0-1686157094426.png

 

Nachricht 5 von 7
halukuzuner
als Antwort auf: halukuzuner

It is not about minus sign. In the picture “/“ used as separator.

Nachricht 6 von 7
ralphdenhaan
als Antwort auf: halukuzuner

Hi,

 

I don't think this is possible in the Revit Native software (when using combined parameters). But you are working in Excel, right? Excel has formulas to fix your problem. Use this formula in a new column and use the "/" as a separator:
 

 

 

=SUBSTITUTE(A1;"/";CHAR(10))

 

 

 

Make sure the cell's formatting is set to "Wrap Text".

 

ralphdenhaan_0-1686165396885.png

 

Select Accept as Solution and Likes are always welcome. 


Ralph den Haan, (Lazy) BIM Specialist


LinkedIn | LazyBIM Blog


 

Nachricht 7 von 7
halukuzuner
als Antwort auf: ralphdenhaan

I can do it in Excel. But my wonder is if it is possible in Revit. It is repetitive job. I don’t want to do the same job in excel every time.

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report