Return to FileMaker.com
I am very new to File Maker Pro 12.
In my excel cell there is a value as 123456789. From File Maker pro I want this output in the respective file maker field as UPC 1 2 3456789 during output.
Please help me by using which option I can see the output from 123456789 to UPC 1 2 3456789.
Thanks to all for your help.
A conditional format cannot produce this change. You'd need to use a calculation field with an expression such as:
"UPC " & Left ( YourField ; 1 ) & " " & Middle ( YourField ; 2 ; 1 ) & " " & Right ( Yourfield ; Length ( YourField ) - 2 )
Retrieving data ...