Wrap WRITE() function parameters

Discussions about editing and cleaning data
Forum rules
New release: CSPro 8.0
Post Reply
kakinyim
Posts: 42
Joined: January 16th, 2012, 6:38 am
Location: Remote/Virtual

Wrap WRITE() function parameters

Post by kakinyim »

I have a very long Write function parameters such as write("%s",itemList(SERIAL_NUMBER, PROVINCE, COUNTY, DISTRICT, MUNICIPALITY_LOCAL_AUTHORITY, NAME_OF_HOUSING_Homebuilders, SEX, AGE, BUILDER1_SKILLED_MALE, BUILDER1_SKILLED_FEMALE, BUILDER1_UNSKILLED_MALE, BUILDER1_UNSKILLED_FEMALE, BUILD2_1, BUILD2_2, BUILD2_3, BUILD2_4, BUILD2_5, BUILD2_6, BUILD2_7, BUILD2_OTHERSPECIFIED, BUILD3_1, BUILD3_2, BUILD3_3, BUILD3_4, BUILD4, BUILD5_1, BUILD5_2, BUILD5_3, BUILD5_4, BUILD5_5, BUILD5_OTHERSPECIFY, BUILD6, BUILD7, BUILD8_1, BUILD8_2, BUILD8_3, BUILD8_4, BUILD8_5, BUILD8_OTHERSPECIFIED, BUILD9_1, BUILD9_2, BUILD9_3, BUILD9_4, BUILD9_5, BUILD9_OTHERSPECIFIED, BUILD10, BUILD11_1, BUILD11_2, BUILD11_3, BUILD11_4, BUILD11_5, BUILD11_6, BUILD11_7, BUILD11_8, BUILD11_9, BUILD11_10, BUILD11_11, BUILD11_12, BUILD11_13, BUILD11_OTHERSPECIFIED, BUILD12, BUILD13_1, BUILD13_2, BUILD13_3, BUILD13_4, BUILD14, BUILD15, BUILD16_1, BUILD16_2, BUILD16_3, BUILD16_4, BUILD16_5, BUILD16_6, BUILD16_7, BUILD16_8, BUILD16_OTHERSPECIFIED, BUILD17_1, BUILD17_2, BUILD17_3, BUILD17_4, BUILD17_5, BUILD18_1, BUILD18_2, BUILD18_3, BUILD18_4, BUILD18_5, BUILD18_6, BUILD18_7, BUILD18_8, BUILD18_9, BUILD18_OTHERSPECIFIED, BUILD19_1, BUILD19_2, BUILD19_3, BUILD19_4, BUILD19_5, BUILD19_6, BUILD19_7, BUILD19_8, BUILD19_OTHERSPECIFIED, KEYER));

I have used reformat data tool to achieve the same results but i wanted to use write function.

How do I wrap these parameters to fit into my computer screen? What is the alternative?

Mutua
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Wrap WRITE() function parameters

Post by Gregory Martin »

Whitespace doesn't matter in CSPro, so you can break the line after any of the items. Am I understanding your question correctly? You could write:
write("%s",itemList(SERIAL_NUMBER, PROVINCE, COUNTY, DISTRICT, MUNICIPALITY_LOCAL_AUTHORITY,
        NAME_OF_HOUSING_Homebuilders, SEX, AGE, BUILDER1_SKILLED_MALE, BUILDER1_SKILLED_FEMALE,
        BUILDER1_UNSKILLED_MALE, BUILDER1_UNSKILLED_FEMALE, BUILD2_1, BUILD2_2, BUILD2_3, BUILD2_4,
        BUILD2_5, BUILD2_6, BUILD2_7, BUILD2_OTHERSPECIFIED, BUILD3_1, BUILD3_2, BUILD3_3, BUILD3_4,
        BUILD4, BUILD5_1, BUILD5_2, BUILD5_3, BUILD5_4, BUILD5_5, BUILD5_OTHERSPECIFY, BUILD6,
        BUILD7, BUILD8_1, BUILD8_2, BUILD8_3, BUILD8_4, BUILD8_5, BUILD8_OTHERSPECIFIED, BUILD9_1,
        BUILD9_2, BUILD9_3, BUILD9_4, BUILD9_5, BUILD9_OTHERSPECIFIED, BUILD10, BUILD11_1, BUILD11_2,
        BUILD11_3, BUILD11_4, BUILD11_5, BUILD11_6, BUILD11_7, BUILD11_8, BUILD11_9, BUILD11_10,
        BUILD11_11, BUILD11_12, BUILD11_13, BUILD11_OTHERSPECIFIED, BUILD12, BUILD13_1, BUILD13_2,
        BUILD13_3, BUILD13_4, BUILD14, BUILD15, BUILD16_1, BUILD16_2, BUILD16_3, BUILD16_4, BUILD16_5,
        BUILD16_6, BUILD16_7, BUILD16_8, BUILD16_OTHERSPECIFIED, BUILD17_1, BUILD17_2, BUILD17_3,
        BUILD17_4, BUILD17_5, BUILD18_1, BUILD18_2, BUILD18_3, BUILD18_4, BUILD18_5, BUILD18_6,
        BUILD18_7, BUILD18_8, BUILD18_9, BUILD18_OTHERSPECIFIED, BUILD19_1, BUILD19_2, BUILD19_3,
        BUILD19_4, BUILD19_5, BUILD19_6, BUILD19_7, BUILD19_8, BUILD19_OTHERSPECIFIED, KEYER));
Post Reply