Aligning information in an IF statement

[Miri Yosef]

Hi,

Does anyone have an idea how could I have the info bellow aligned:
<IF (Not IsEmpty({{.TownCountyTaxDescription#}}))>{{.TownCountyTaxDescription#}}: {{.TownCountyPeriod#}}
Full Tax: ${{.TownCountyFullTaxAmount#}} <IF (IsEmpty({{.TownCountySecondInstallmentDue#}}))>Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
<ELSE>

1st Inst: ${{.TownCounty1stInstallmentAmount#}} Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.TownCountySecondInstallmentDue#}}))>2nd Inst: ${{.TownCounty2ndInstallmentAmount#}} Due {{.TownCountySecondInstallmentDue# M}}/{{.TownCountySecondInstallmentDue# D}}/ {{.TownCounty2ndInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.TownCountyThirdInstallmentDue#}}))>3rd Inst: ${{.TownCounty3rdInstallmentAmount#}} Due {{.TownCountyThirdInstallmentDue# M}}/{{.TownCountyThirdInstallmentDue# D}}/ {{.TownCounty3rdInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.TownCountyFourthInstallmentDue#}}))>4th Inst: ${{.TownCounty4thInstallmentAmount#}} Due {{.TownCountyFourthInstallmentDue# M}}/{{.TownCountyFourthInstallmentDue# D}}/ {{.TownCounty4thInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $

</IF>
<IF (Not IsEmpty({{.CityTaxDescription#}}))>{{.CityTaxDescription#}}: {{.CityTaxPeriod#}}
Full Tax: ${{.CityFullTaxAmount#}} <IF (IsEmpty({{.CitySecondInstallmentDueDate#}}))>Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}
<ELSE>

1st Inst: ${{.City1stInstallmentAmount#}} Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.CitySecondInstallmentDueDate#}}))>2nd Inst: ${{.City2ndInstallmentAmount#}} Due {{.CitySecondInstallmentDueDate# M}}/{{.CitySecondInstallmentDueDate# D}}/ {{.City2ndInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.CityThirdInstallmentDate#}}))>3rd Inst: ${{.City3rdInstallmentAmount#}} Due {{.CityThirdInstallmentDate# M}}/{{.CityThirdInstallmentDate# D}}/ {{.City3rdInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $

</IF>
<IF (Not IsEmpty({{.SchoolTaxDescription#}}))>{{.SchoolTaxDescription#}}: {{.SchoolTaxPeriod#}}
Full Tax: ${{.SchoolFullTaxAmount#}} <IF (IsEmpty({{.School2ndInstallmentDueDate#}}))>Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.SchoolFullTaxPaymentStatus#}}
<ELSE>

1st Inst: ${{.School1stInstallmentAmount#}} Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.School1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.School2ndInstallmentDueDate#}}))>2nd Inst: ${{.School2ndInstallmentAmount#}} Due {{.School2ndInstallmentDueDate# M}}/{{.School2ndInstallmentDueDate# D}}/ {{.School2ndInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.School3rdInstallmentDueDate#}}))>3rd Inst: ${{.School3rdInstallmentAmount#}} Due {{.School3rdInstallmentDueDate# M}}/{{.School3rdInstallmentDueDate# D}}/ {{.School3rdInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $

</IF>
<IF (Not IsEmpty({{.VillageTaxDescription#}}))>{{.VillageTaxDescription#}}: {{.VillageTaxPeriod#}}
Full Tax: ${{.VillageFullTaxAmount#}} <IF (IsEmpty({{.VillageTaxSecondDueDate#}}))>Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.VillageFullTaxPaymentStatus#}}
<ELSE>

1st Inst: ${{.Village1stInstallmentAmount#}} Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.Village1stInstallmentPaymentStatus#}}
</IF>
<IF (Not IsEmpty({{.VillageTaxSecondDueDate#}}))>2nd Inst: ${{.Village2ndInstallmentAmount#}} Due {{.VillageTaxSecondDueDate# M}}/{{.VillageTaxSecondDueDate# D}}/ {{.Village2ndInstallmentPaymentStatus#}}
</IF>
Tax W/O Exemption: $

</IF>
Water / Sewer: <IF ({{.TypeOfWater#}}=”Public”)>{{.TypeOfWater#}} (Account #)
Amount: ${{.WaterAmount#}} Due {{.WaterDueDate# M}}/{{.WaterDueDate# D}}/ {{.WaterPaymentStatus#}}
<ELSE><IF ({{.TypeOfWater#}}=”Private”)>{{.TypeOfWater#}}
<ELSE><IF ({{.TypeOfWater#}}=”Vacant Land”)> N/A - Vacant Land
<ELSE><IF ({{.TypeOfWater#}}=”Under Construction”)>Public When Improved
<ELSE><IF ({{.TypeOfWater#}}=”Nassau / Suffolk”)>Not Searched – Homeowner should present bill / receipt @ closing.
<ELSE><IF ({{.TypeOfWater#}}=”Missing Info”)>To Follow
<ELSE><IF ({{.TypeOfWater#}}=”Condo”)>Common Charges
<IF></IF></IF></IF></IF></IF></IF></IF></IF>

An example of the way I want it to look is:
200 Town / County Tax: : 1/1-12/31 200
Full Tax: $.00
1st Inst: $.00 Due 1/1/ Paid
2nd Inst: $.00 Due 7/1/ Paid
Tax W/O Exemption: $

Thanks

[danvanf]

That's a tough example, I believe one just needs to be crazy about where they put hard returns. Can't really test your formula, with the custom fields. Could you show us the what the output of your formula looks like? What is being misaligned?

Here's my best guess without any testing.

Code: Select all

<IF (Not IsEmpty({{.TownCountyTaxDescription#}}))>{{.TownCountyTaxDescription#}}: {{.TownCountyPeriod#}} 
Full Tax: ${{.TownCountyFullTaxAmount#}} <IF (IsEmpty({{.TownCountySecondInstallmentDue#}}))>
Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
<ELSE>1st Inst: ${{.TownCounty1stInstallmentAmount#}}
Due {{.TownCountyFirstInstallmentDue# M}}/{{.TownCountyFirstInstallmentDue# D}}/ {{.TownCounty1stInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.TownCountySecondInstallmentDue#}}))>2nd Inst: ${{.TownCounty2ndInstallmentAmount#}} Due {{.TownCountySecondInstallmentDue# M}}/{{.TownCountySecondInstallmentDue# D}}/ {{.TownCounty2ndInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.TownCountyThirdInstallmentDue#}}))>3rd Inst: ${{.TownCounty3rdInstallmentAmount#}} Due {{.TownCountyThirdInstallmentDue# M}}/{{.TownCountyThirdInstallmentDue# D}}/ {{.TownCounty3rdInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.TownCountyFourthInstallmentDue#}}))>4th Inst: ${{.TownCounty4thInstallmentAmount#}} Due {{.TownCountyFourthInstallmentDue# M}}/{{.TownCountyFourthInstallmentDue# D}}/ {{.TownCounty4thInstallmentPaymentStatus#}}
</IF>Tax W/O Exemption: $
</IF><IF (Not IsEmpty({{.CityTaxDescription#}}))>{{.CityTaxDescription#}}: {{.CityTaxPeriod#}} 
Full Tax: ${{.CityFullTaxAmount#}} <IF (IsEmpty({{.CitySecondInstallmentDueDate#}}))>
Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}<ELSE>1st Inst: ${{.City1stInstallmentAmount#}} Due {{.CityFirstInstallmentDueDate# M}}/{{.CityFirstInstallmentDueDate# D}}/ {{.City1stInstallmentPaymentStatus#}}</IF>
<IF (Not IsEmpty({{.CitySecondInstallmentDueDate#}}))>2nd Inst: ${{.City2ndInstallmentAmount#}} Due {{.CitySecondInstallmentDueDate# M}}/{{.CitySecondInstallmentDueDate# D}}/ {{.City2ndInstallmentPaymentStatus#}}</IF>
<IF (Not IsEmpty({{.CityThirdInstallmentDate#}}))>3rd Inst: ${{.City3rdInstallmentAmount#}} Due {{.CityThirdInstallmentDate# M}}/{{.CityThirdInstallmentDate# D}}/ {{.City3rdInstallmentPaymentStatus#}}</IF>
Tax W/O Exemption: $
</IF><IF (Not IsEmpty({{.SchoolTaxDescription#}}))>{{.SchoolTaxDescription#}}: {{.SchoolTaxPeriod#}}
Full Tax: ${{.SchoolFullTaxAmount#}} <IF (IsEmpty({{.School2ndInstallmentDueDate#}}))>Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.SchoolFullTaxPaymentStatus#}}<ELSE>1st Inst: ${{.School1stInstallmentAmount#}} Due {{.SchoolFirstInstallmentDueDate# M}}/{{.SchoolFirstInstallmentDueDate# D}}/ {{.School1stInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.School2ndInstallmentDueDate#}}))>2nd Inst: ${{.School2ndInstallmentAmount#}} Due {{.School2ndInstallmentDueDate# M}}/{{.School2ndInstallmentDueDate# D}}/ {{.School2ndInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.School3rdInstallmentDueDate#}}))>3rd Inst: ${{.School3rdInstallmentAmount#}} Due {{.School3rdInstallmentDueDate# M}}/{{.School3rdInstallmentDueDate# D}}/ {{.School3rdInstallmentPaymentStatus#}}
</IF>Tax W/O Exemption: $
</IF><IF (Not IsEmpty({{.VillageTaxDescription#}}))>{{.VillageTaxDescription#}}: {{.VillageTaxPeriod#}} 
Full Tax: ${{.VillageFullTaxAmount#}} <IF (IsEmpty({{.VillageTaxSecondDueDate#}}))>Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.VillageFullTaxPaymentStatus#}}
<ELSE>1st Inst: ${{.Village1stInstallmentAmount#}} Due {{.VillageTaxFirstDueDate# M}}/{{.VillageTaxFirstDueDate# D}}/ {{.Village1stInstallmentPaymentStatus#}}
</IF><IF (Not IsEmpty({{.VillageTaxSecondDueDate#}}))>2nd Inst: ${{.Village2ndInstallmentAmount#}} Due {{.VillageTaxSecondDueDate# M}}/{{.VillageTaxSecondDueDate# D}}/ {{.Village2ndInstallmentPaymentStatus#}}
</IF>Tax W/O Exemption: $
</IF>Water / Sewer: <IF ({{.TypeOfWater#}}=”Public”)>{{.TypeOfWater#}}	(Account #)
Amount: ${{.WaterAmount#}} Due {{.WaterDueDate# M}}/{{.WaterDueDate# D}}/ {{.WaterPaymentStatus#}}
<ELSE><IF ({{.TypeOfWater#}}=”Private”)>{{.TypeOfWater#}}
<ELSE><IF ({{.TypeOfWater#}}=”Vacant Land”)> N/A - Vacant Land
<ELSE><IF ({{.TypeOfWater#}}=”Under Construction”)>Public When Improved
<ELSE><IF ({{.TypeOfWater#}}=”Nassau / Suffolk”)>Not Searched – Homeowner should present bill / receipt @ closing.
<ELSE><IF ({{.TypeOfWater#}}=”Missing Info”)>To Follow
<ELSE><IF ({{.TypeOfWater#}}=”Condo”)>Common Charges
<IF></IF></IF></IF></IF></IF></IF></IF></IF>

Hope it formats good for you,

Dan Van Fleet

[Miri Yosef]

Hi Mr. Van Fleet,

I need the repetitive words within the lines to be aligned. example is attached

The words that should be aligned are : the $ sign, the Due dates and the status (Paid/Open)

[danvanf]

Hi Miri,
Oh shucks, call me Dan. <Smile>
So our first decision is if you want the $ signs lined up, or the decimal in the number lined up. Since I generally prefer to read numbers, when the decimal is aligned vertically, that is how this solution is generated. To change, simply change the Decimal tab to a Left Tab in the attached.

What I see is your document has to many tab stops. With tabs and merge documents, the fewer the better. If you want things to remained aligned, you can not use more than one tab to separate items. Spaces never work to align columns. As I'm sure you're aware, the document will potentially look quite goofy in design mode, the tab separators will pull it all together and print time. So I deleted all the tab stops, then added a decimal tab at 1.63", a Left Tab at 2" and a Left Tab at 3.5", and went through the formula removing a few Hard Returns, and separating items with a Tab rather than a space.

I'm having problems with Select right now, so I can't look at the attached document, but it will come pretty close to the mark.

Dan Van Fleet

[dokata]

Hi,

Would a table with a single row also work? I have one wrapped in a FOR statement to have the columns align because I'm not using the standard tabs. To get rid of the extra line problem I change the size of the carriage return (aka end of line) character to a very small font size of 1.

[danvanf]

Yep sure would, I just don't like tables, and avoid them whenever possible.

Dan

[dokata]

I know what you mean. Thank you Dan

~ Debby

[Miri Yosef]

Thank you Dan