SVG_HTML_to_Text ( _svg_text ; _orig_text ;

Converts FMs svg to FM formatted Text

Average rating: 5.0 (2 votes) Log in to vote

Ralph - Show more from this author
C8 Development
http://C8D.de

Sample input:

\"font-family: 'Times New Roman Bold';font-size: 20px;color: #000000;font-weight: bold;text-align: center;\", begin: 1, end: 5
\"font-family: 'Times New Roman Bold';font-size: 36px;color: #000000;font-weight: bold;text-align: center;\", begin: 6, end: 26

für

#Vorname# #Nachname#

Sample output:

für¶¶#Vorname# #Nachname#

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

//INPUT
//_svg_text = Text that was GetAsSVG (Text) applied
//_orig_text = Original Text formatted or not
//_count = "" 

//converts svg Text into FileMaker formatted Text
//Wandelt svg Text ist formatierten FileMaker Text um 

//needs ParseData CF -> http://www.briandunning.com/cf/559
//thanks to Hal Gumbert, MacFL http://www.macfl.com
 
//need color_convert_hex CF -> http://www.briandunning.com/cf/2036
//thanks to Thomas Siebert, seabird http://www.t-seabird.de
 
//needs HTMLencoded2Text to decode the ü stuff -> FileMaker Custom Functions | Displaying Function HTMLencoded2Text
//thanks to Fabrice Nordmann


Let([
_count=If ( IsEmpty(_count) ; 1 ; _count +1);

//decode the ü stuff with HTMLencoded2Text
_t=HTMLencoded2Text (_svg_text); 

//parse svg <stylelist> section with ParseData CF
_styles=ParseData ( _t ; "<stylelist>¶" ; "</stylelist>" ; 1 ); 
_c_s=ValueCount ( _styles );
_r1= GetValue ( _styles; _count);

//get formattings
_font=ParseData ( _r1 ; "font-family: '" ; "';" ; 1 );
_font_size=ParseData ( _r1 ; "font-size: " ; ";" ; 1 );
_font_color=ParseData ( _r1 ; "color: #" ; ";" ; 1 );
_font_weight=ParseData ( _r1 ; "font-weight: " ; ";" ; 1 );
_font_u=ParseData ( _r1 ; "text-decoration:" ; " ;" ; 1 );
_pos1=ParseData ( _r1 ; "begin: " ; "," ; 1 );
_pos2=ParseData ( _r1 ; "end: " ; "<" ; 1 );

//get position of formatted text. Position of the original text
_t_out=Middle ( _orig_text ; _pos1 ; If (_pos2≠_pos1;_pos2-_pos1+1;" ") );

//apply formatting
_t_f_out=TextFont ( _t_out ; _font );
_t_f_out=TextSize ( _t_f_out ; _font_size );
//translate HEX Color to rgb decimal color_convert_hex CF
_t_f_out=TextColor ( _t_f_out ; color_convert_hex ( _font_color ; "decimal" ) ) ;

_t_f_out=If ( not IsEmpty (_font_weight); TextStyleAdd ( _t_f_out ;  Bold ) ; _t_f_out);
_t_f_out=If ( not IsEmpty (_font_u); TextStyleAdd ( _t_f_out ;  Underline ) ; _t_f_out)
];//

_t_f_out  &If (_pos2=_pos1;¶ ) & If ( GetAsNumber(_count) < GetAsNumber(_c_s) ; SVG_HTML_to_Text ( _svg_text; _orig_text; _count))

)

This function converts SVG-Text from FileMakers function GetAsSVG back into FileMaker formatted Text.
My purpose was to transfer FileMaker formatted Text via JBDC/XML with MirrorSync. Usually Text formatting is disregarded when syncing with Mirrorsync.

I used the following CFs, so they are prerequisites:

ParseData CF -> http://www.briandunning.com/cf/559

color_convert_hex CF -> http://www.briandunning.com/cf/2036

HTMLencoded2Text -> http://www.fmfunctions.com/functions_display_record.php?functionId=178

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

SVG_HTML_to_Text ( _svg_text ; _orig_text ;

Comments

Support this website.

Support this website.