Hello,I have a rich text field with a long list of GPS positions. This should be converted for different formats, for use on different map solutions. I manage to get all the positions with into a text parameter and convert it as follows:
pos := @Explode( @Text( gpsTrack ) ; @NewLine ) ;
newList := @Transform( pos ; “p” ;
“<trkpt lat="” + @Word( p ; " " ; 1 ) + “" lon="” + @Word( p ; " " ; 2 ) + “">” +
@Word( p ; " " ; 3 ) + "</ele></trkpt>" );
This will however output the data as a list, and I need to get rid of the “,” between each value. When i try to implode the value I get an empty value due to size limit.
I have also tried to use a @For loop in a calculated rich text field, but then i get a 500 error: The formula has exceeded the maximum allowable memory usage.
I think it is strange I do not get memory error on the list, which has the same size.
Anyone have ideas to how I can avoid the list in formula?