Topic
  • 1 reply
  • Latest Post - ‏2012-12-07T16:25:02Z by SystemAdmin
SystemAdmin
SystemAdmin
1299 Posts

Pinned topic TEM relevance concatenation issue / question.

‏2012-12-06T20:45:24Z |
Here is some relevance code I have that is working in the fixle 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.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.
Updated on 2012-12-07T16:25:02Z at 2012-12-07T16:25:02Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1299 Posts

    Re: TEM relevance concatenation issue / question.

    ‏2012-12-07T16:25:02Z  
    I have no idea how this post got in "Rational Publishing Engine (including Telelogic DocExpress", I've never even been in this part of the forum. Reposting in correct forum.