Diver

SQL Query: Tab delimited and dollar amounts

Discussion created by Diver on Sep 22, 2013
Latest reply on Sep 23, 2013 by greglane

Playing with basic SQL in FileMaker, I have it return the data I want but not in the format I want.

 

The first two lines in my script's "Set field" are:

 

ExecuteSQL ("SELECT InvoiceNum, OrderDate, TotalAmount

FROM TestTable

 

This returns the proper data but formatted like:

 

12345,2013-09-22,400.1

12346,2013-09-22,299

12347,2013-09-22,199.23

 

I am not sure how to have it return a tab delimited format and use proper formatting for dollar amounts with 2 decimal places, as shown below:

 

12345 2013-09-22 400.10

12346 2013-09-22 299.00

12347 2013-09-22 199.23

 

I have experimented with || char(9) and ", " , " " and have had no success with the delimination. I have no clue on how to do the 2 decimal point accuracy.

 

I welcome any direction or examples.

Outcomes