Yes, it is a custom function. You need FileMaker Advance for custom function. Go to File, Manage, Custom functions. You can import the function by clicking import.
"FM PRO 12 (not advanced)""2. Is there a workaround?"You can enter a tab char in a text by pressing both CTRL and TAB or simply using Char ( 9 ) in calculations.So the script step coul become:Set Variable [ $lines; Value:"Address" & Char ( 9 ) & "City" & Char ( 9 ) & "State" & Char ( 9 ) & "Zipcode" & ....}
Thank you both for the advice
@S Chamblee. I do not have advanced, so I guess what your saying is there is no way to get that function on my database, unless I upgrade.
@raybaudi. Thanks Ray, that does help the first half of the problem. The $lines field does show the spaces. But the second part, copy/then pasting into the field for mapping, the fields all run together instead of separating into columns. The paste is done on the BatchGeo site.
the fields all run together instead of separating into columns
If you are successfully using char (9) to include tab characters, you can use the appearance tab in the inspector to specify tab stops for each tab character to arrange the data into columns.
You can also get columns of data without using a calculation simply by arranging the fields and layout text in rows and columns on your layout.
Thanks Phil & to all that responded. Turns out Ray had the solution, I used it in $lines, but forgot to change it in another field calculation. Works great!
Thanks all......again..........and again...