Problems importing csv with timestamp

[rscosworth1998]

I am importing data from a barcode reader. The bar code reader application can generate output in various formats. I have tried csv and xls. The problems i have is that the text file shows the timestamp for the barcode as hh:mm:ss mm/dd/yyyy. When i import this into excel it converts it to mm/dd/yyyy hh:mm:ss which if I import this file works with my calculated fields. If I import staight from the file the calculations fail. Below is a line from the import file.

I guess there are 2 solutions

1. Get the import to reverse the order to work with my calcs.

2. Create a calculation that swaps the data around.

Any ideas

[Lee Smith]

Someone that is more familiar with how the Bar Code process works, might have a simpler way to do it, but you could create two fields, one for time and one for date and parse it out using GetASTime and GetASDate

GetAsTime ( LeftWords ( Text ; 1 ))

GetAsDate ( RightWords ( Text ; 1 ))

HTH

Lee

Edited August 6, 2008 by Guest

[Matthew F]

I vote for number 2 using the following calculation to convert the BarCode time stamp to a FileMaker time stamp. ('TextField' is the imported time stamp):

Timestamp ( GetAsDate ( RightWords( TextField; 1 ) ) ; GetAsTime ( LeftWords( TextField; 1 ) ) )

[Lee Smith]

:

or

LOL