(imported topic written by SystemAdmin)
Here is some relevance code I have that is working in the fixlet debugger.
Q:
(parent folder of it, name of it, size of it, (((if (length of it =1) then (“0”&it) else it) of (month of it as integer as string) & “/” & (if (length of it =1) then (“0”&it) else it) of (day_of_month of it as string) & “/” & (year of it as string)) of date (“pdt” as time zone) of it & " " & ((if (length of it =1) then (“0”&it) else it) of (hour_of_day of it as string) & “:” & (if (length of it =1) then (“0”&it) else it) of (minute_of_hour of it as string)& “:” & (if (length of it =1) then (“0”&it) else it) of (second_of_minute of it as string)) of time (“pdt” as time zone) of it) of creation time of it, (((if (length of it =1) then (“0”&it) else it) of (month of it as integer as string) & “/” & (if (length of it =1) then (“0”&it) else it) of (day_of_month of it as string) & “/” & (year of it as string)) of date (“pdt” as time zone) of it & " " & ((if (length of it =1) then (“0”&it) else it) of (hour_of_day of it as string) & “:” & (if (length of it =1) then (“0”&it) else it) of (minute_of_hour of it as string) & “:” & (if (length of it =1) then (“0”&it) else it) of (second_of_minute of it as string)) of time (“pdt” as time zone) of it) of modification time of it, (((if (length of it =1) then (“0”&it) else it) of (month of it as integer as string) & “/” & (if (length of it =1) then (“0”&it) else it) of (day_of_month of it as string) & “/” & (year of it as string)) of date (“pdt” as time zone) of it & " " & ((if (length of it =1) then (“0”&it) else it) of (hour_of_day of it as string) & “:” & (if (length of it =1) then (“0”&it) else it) of (minute_of_hour of it as string) & “:” & (if (length of it =1) then (“0”&it) else it) of (second_of_minute of it as string)) of time (“pdt” as time zone) of it) of accessed time of it) of find files “*.db” of (it; descendant folders of it) of folder “C:\nmdata”
A:
C:\nmdata, ( blah-doe,john.db ), 24, 11/26/2012 10:15:16, 11/26/2012 13:56:57, 11/26/2012 10:15:16
As you can see the majority of the code is to modify the date-time format. The problem I am running into is that I want to change the output items to be separated by a “|” instead of a comma. The reason is because some of the folders returned have commas in the name, causing the the comma separated values to parse incorrectly in Excel, scripts, etc. I’ve tried numerous way of concatenation, like adding ‘concatenation “|” of’ to the front of the code. I’ve also tried replacing the commas in the code separating the elements manually with & “|” &. This is not working for me either. I’m sure there is an issue with the context, but I’m stumped as to how to code this.