Jump to content

Search the Community

Showing results for tags 'text formatting'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome
    • Start Here!
    • News
  • Software-Related Talk
    • Documentation
    • Getting Started
    • The JavaScript Library
    • FusionPro® VDP Creator
    • FusionPro® VDP Producer
    • FusionPro® VDP Server (API)
    • FusionPro® Expression®
    • MarcomCentral®
  • Support
    • Issues, Questions, Etc.
    • Digital Workflow Documents
    • Fonts
  • Off Topic
    • Customer Polls
    • Job Board (Moderated)
    • Reviews, Rants, and General Musings

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Location


Occupation


FusionPro VDP software version


OS


Acrobat Version


Homepage


ICQ


AIM


Yahoo


MSN


Skype


User Title

Found 4 results

  1. I have a problem in using native excel files with text formatted as "Date" When I open the file in Excel the column "Date" is filled like 27-04-2012 but after importing it as data source into FusionPro it becomes 27/04/2012 in the output How can this be solved without altering the native excel file?
  2. I've been using simple rules for internal client templates and so far this has been straightforward but right now, I'm at a loss to what to for a more complex rule. Disclaimer is I'm not a developer and more of a HTML/CSS person so I've been going in blind for a lot of the more complex (to me) JavaScript (I have been using the W3 School site to try to learn it) - So please bear with me. Currently I'm working on a project on Fusion pro that requires the street address and city of one of our clients. And the format is basically this: <Street Address><Ste or Office number> | <City> However, some of our client addresses are incredibly long and fill the whole line and that causes the line to break and <City> to go to another line. The problem is that the "|" also breaks to the next line and aesthetically it's not the greatest. So what I'm trying to figure out is if the combined address field is longer than the textbox and forces <City> to break to the next line, I'd like to suppress the "|" and have the break as is so it would effectively be: <Street Address><Ste or Office number> <City> I looked through the forums and I saw the threads about using Text Measure, and I've used simple suppression rules before - I'm just at a bit of a loss at how to effectively combine the two so that the suppression rule is triggered when the address fields spans the whole text box length. Thanks!
  3. Hello, I am new and jumping in head first per usual. I am working on an invite for a client and that will allow them to have multiple sub events (reception, dinner, lecture, movie, etc.) under the date of the main event on the invitation. They are required to enter one and at maximum allowed to have four. The sub events are broken in a 1 | 2 & 3 | 4 format. Format Example: Event 1 00:00 p.m. | Event 2 00:00 p.m. Event 3 00:00 p.m. | Event 4 00:00 p.m. *note two spaces on either side of pipeline (|) FusionPro Rules if (Field("Event1_title") != "" && Field("Event2_title") != "") return Field("Event1_title") + ' ' + Field("Event1_time") + ' ' + Field("Event1_ap") + ' ' + ' | ' + ' ' + Field("Event2_title") + ' ' + Field("Event2_time") + ' ' + Field("Event2_ap"); else if (Field("Event1_title") != "" && Field("Event2_title") == "") return Field("Event1_title") + ' ' + Field("Event1_time") + ' ' + Field("Event1_ap"); else if (Field("Event1_title") == "" && Field("Event2_title") != "") return Field("Event2_title") + ' ' + Field("Event2_time") + ' ' + Field("Event2_ap"); else return ''; if (Field("Event3_title") != "" && Field("Event4_title") != "") return Field("Event3_title") + ' ' + Field("Event3_time") + ' ' + Field("Event3_ap") + ' ' + ' | ' + ' ' + Field("Event4_title") + ' ' + Field("Event4_time") + ' ' + Field("Event4_ap"); else if (Field("Event3_title") != "" && Field("Event4_title") == "") return Field("Event3_title") + ' ' + Field("Event3_time") + ' ' + Field("Event3_ap"); else if (Field("Event3_title") == "" && Field("Event4_title") != "") return Field("Event4_title") + ' ' + Field("Event4_time") + ' ' + Field("Event4_ap"); else return ''; Text Generated out of MarcomCentral Portal when I test my template: http://www.rboweb.com/WASHU/IMGS/EXAMPLES/example.jpg It works and I'm not receiving any errors, but it's loosing my double spacing on either side of my pipeline in just the first rule only on MC and I can't figure out why. Validating the code in FP gives me the correct output and the second rule is formatting correctly. You can see that I have already attempting appending the second space separately to see if that fixed it. Any thoughts?
  4. I am sure this has been asked and discussed in maybe a different way. But I have search the forums and can't find a simple solution. I have 5 data fields with dollar amounts in them. None have commas, or dollar signs. In a perfect world I would just use the Number to Currency wizard for all 5 fields that FusionPro gives however.... Not all the data in those fields are numbers, some is text and they change whereas sometimes the "Other $_______ may be in field named AMT1 position. Example: Amt1= 25 Amt2= 50 Amt3=75 Amt4=100 Amt5=Other $________ Example2: Amt1= Other $________ Amt2=(Blank--will be suppressed) Amt3=(Blank--will be suppressed) Amt4=(Blank--will be suppressed) Amt5=(Blank--will be suppressed) Example3: Amt1= 25 Amt2= 50 Amt3=Other $________ Amt4=(Blank--will be suppressed) Amt5=(Blank--will be suppressed) I need to make it where the rule searches the field for numbers only and convert to currency formatting. And if it has text do not format.
×
×
  • Create New...