This only happens in the description field

When I am publishing to ical and the event shows up on ical everywhere there is a ":" such as in a time it shows up with a "\" before it so it shows up as 4\:00 not the end of the world but kind of looks crappy on the formatting is this a known problem that i missed in the forums? Or if I have "We need to do these things:" It shows up as "We need to do these things\:"

Any help will be appreciated John

Woa. Sorry to hear that... is this in the iCal export or when subscribing to iCal?

[quote="John Sindelar"]Woa. Sorry to hear that... is this in the iCal export or when subscribing to iCal?[/quote]

This is in the iCal export...it shows up in iCal after i do the import from the .ical that i am exporting from my filemaker file...

bump

Hey sorry for the late reply. I'm actually not sure which approach to take to this since we're using the same iCal assembler in the rest of the calendar, and there we escape the ":"s because iCal uses them as delimiters. In FMP we "read" these in a script and can un-escape them. No such operation in iCal so I'm not sure which is the least invasive method of repairing this.

I'm still looking at it but am on the road for a few days. Will be back this weekend and should have an answer then.

Again, I apologize for the delay.

Hey John I appreciate you touching base with me...no biggie just let me know your thoughts....its just ugly when it comes to formatting wise.

Well this was easier than I thought and it seems we were just being overly cautious. We don't need to be escaping those colons in the first place.

Edit the script "Write One FileMaker Event in iCal Format" and edit the calc for the last line: the "Exit Script" result line.

You'll see a long calc in there. Towards the end of the calc you'll see comments for the Summary and Description. Both use a long substitute to look for (what we thought) would be offensive characters. You can simplify the substitutions for Summary and Description by turning them from this:

Substitute ( $scical_Summary ; [ "," ; "\," ] ; [ "¶" ; "\n" ] ; [ ";" ; "\;" ] ; [ ":" ; "\:" ] )

To this:

Substitute ( $scical_Summary ; [ "¶" ; "\n" ] )

The one for Description becomes:

Substitute ( $scical_Description ; [ "¶" ; "\n" ] )

That's it.

Sorry it took so long to work this out.

thank you so much this fixed it !!!!