How to format the display of a text(formula) field?

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
Hi I would like to know how to display the value of a Text(formula) field to look like in the attached file. I have manage to display the values of other field inside the text(formula) field using the formula below. but its just a one continuous line on all of the values that i want to display, i would like to know what to place at the end of the line to say the this next value should be in another line. thanks in advance.





ToText ([Package # / Option #]&". P/N:" & " " &[P/N] & " (File: " & [Data info]) &" ) [" &[Date]&"]" &[Material type] & "; " & [Board THK] & " Board THK;" & [Copper THK (oz)] & " OZ; (" &[Finish/Base]& ");" &[Layer Count]&"L; "&[Array Size]&"X"&[Array Size ]&"("&[# of ups in Array]&");"&[Panel size]&"X"&[Panel size2]&"("&[# of ups per Panel]&");"&[Line/Spacing]&"(Line/space);"&[hole]&"(Hole);"&[Soldermask]&"; "&[SS]&" ;"&[Surface finish]


Photo of roderick

roderick

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
The character string to break to a new line is "\n"

The best way to format for human readability (you) is

List("\n",
Text String #1,
Text String #2,
Etc
Text String Last)