<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="72"/>
        <last_saved_by value="Oryx_Digital_Ltd_using_Easy_Data_Transform_v2_0_0_on_Windows_10_Version_2009_at_2024_11_01_14_22_17"/>
        <locale value="en_GB"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="C%3A%5CUsers%5Candy%5CDesktop%5Cstates.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="867.6^1032.3" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="Clipboard" schema_extra_cols="0" pos_v12="867.61032.3" watching="0" medium="1" auto_fixed_widths="1" schema_missing_cols="0" header="1" ignore_empty_cols="0" schema_reorder_cols="0" trim="1" file_type="10" id="312" custom_delimiter="%2A" ignore_repeated_delim="0" text="address%20%0A%20632%20Del%20Monte%20Ave.%20Powhatan%2C%20VIRGINIA%2023139%0A%09%0A%20%20%20%20733%20Wood%20St.%20Passaic%2C%20NJ%2007055%0A%09%0A%20%20%20%20763%20Mammoth%20Court%20%20%20%20%20Dunedin%2C%20fl%20%0A%09%0A%20%20%20%2025%20Randall%20Mill%20Street%20Santa%20Cruz%20CA%0A%09%0A%20%20%20%20755%20magnolia%20avenue%20norristown%2C%20pa%2019401%0A%09%0A%20%20%20%209%20S.%20Vine%20Ave.%20Pembroke%20Pines%2C%20Florida%2033028%0A%09%0A%0918%20Snake%20Hill%20Street%20Tallahassee%2C%20FL%2032303%0A%09%0A%20%20%20%20179%20Prince%20Ave.%2C%20Billings%2C%20Montana%2059101%0A%09%0A%20%20%20%208570%20Arcadia%20Street%2C%20Sewell%2C%20NJ%2008080%0A%09%0A%20%20%20%209335%20Fordham%20Ave.%20Lebanon%2C%20PA%2017042%0A%09%0A%20%20%20%2078%20Brickyard%20St%20West%20Hempstead%2C%20New%20York%2011552%0A%09%0A%20%20%20%207272%20Front%20St.%20Grove%20City%20OH%2043123" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-90^1152" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="Clipboard" schema_extra_cols="0" pos_v12="-901152" watching="0" medium="1" auto_fixed_widths="1" schema_missing_cols="0" header="1" ignore_empty_cols="0" schema_reorder_cols="0" trim="1" file_type="0" id="316" custom_delimiter="%2A" ignore_repeated_delim="0" text="State%09Abbreviation%0AAlabama%09AL%0AAlaska%09AK%0AArizona%09AZ%0AArkansas%09AR%0ACalifornia%09CA%0AColorado%09CO%0AConnecticut%09CT%0ADelaware%09DE%0ADistrict%20of%20Columbia%09DC%0AFlorida%09FL%0AGeorgia%09GA%0AHawaii%09HI%0AIdaho%09ID%0AIllinois%09IL%0AIndiana%09IN%0AIowa%09IA%0AKansas%09KS%0AKentucky%09KY%0ALouisiana%09LA%0AMaine%09ME%0AMaryland%09MD%0AMassachusetts%09MA%0AMichigan%09MI%0AMinnesota%09MN%0AMississippi%09MS%0AMissouri%09MO%0AMontana%09MT%0ANebraska%09NE%0ANevada%09NV%0ANew%20Hampshire%09NH%0ANew%20Jersey%09NJ%0ANew%20Mexico%09NM%0ANew%20York%09NY%0ANorth%20Carolina%09NC%0ANorth%20Dakota%09ND%0AOhio%09OH%0AOklahoma%09OK%0AOregon%09OR%0APennsylvania%09PA%0ARhode%20Island%09RI%0ASouth%20Carolina%09SC%0ASouth%20Dakota%09SD%0ATennessee%09TN%0ATexas%09TX%0AUtah%09UT%0AVermont%09VT%0AVirginia%09VA%0AWashington%09WA%0AWest%20Virginia%09WV%0AWisconsin%09WI%0AWyoming%09WY" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="318" name="Remove" pos="388.8^1032.3" pos_v12="388.81032.3">
            <parameters>
                <parameter type="11" name="Columns" value="13"/>
            </parameters>
        </transform>
        <transform id="319" name="Stack" pos="628.2^1152" pos_v12="628.21152">
            <parameters>
                <parameter type="6" name="Align_Cols" value="Column%20number"/>
                <parameter type="5" name="Only_First_Cols" value="0"/>
                <parameter type="5" name="Add_Separators" value="0"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
            </parameters>
        </transform>
        <transform id="321" name="Calculate" pos="149.4^1391.4" pos_v12="149.41391.4">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="Length"/>
                <parameter type="0" name="Column1" value="2"/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="322" name="Sort" pos="388.8^1391.4" pos_v12="388.81391.4">
            <parameters>
                <parameter type="2" name="Columns" value="-3"/>
                <parameter type="5" name="Rank_Add" value="0"/>
                <parameter type="6" name="Rank_Types" value="Minimum"/>
                <parameter type="0" name="Rank_By" value="0"/>
                <parameter type="5" name="Intelligent_Sort" value="1"/>
                <parameter type="5" name="Locale_Aware_Sort" value="0"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="323" name="Lookup" pos="1107^1152" pos_v12="11071152">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Lookup"/>
                <parameter type="0" name="Top_Lookup_Column" value="1"/>
                <parameter type="0" name="Bottom_Lookup_Column" value="1"/>
                <parameter type="0" name="Bottom_Value_Column" value="2"/>
                <parameter type="6" name="Match_Type" value="Top%20matches%20bottom%20regex"/>
                <parameter type="8" name="Fuzziness" value="80"/>
                <parameter type="6" name="Bottom_Values_Used" value="First"/>
                <parameter type="6" name="Fuzzy_Bottom_Values_Used" value="First%20best"/>
                <parameter type="7" name="Delim" value="%2C"/>
                <parameter type="6" name="If_No_Match" value="Use%20no%20match%20value"/>
                <parameter type="7" name="Non_Matching_Value" value="%2ANO%20MATCH%2A"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
            </parameters>
        </transform>
        <transform id="324" name="Copy" pos="149.4^1032.3" pos_v12="149.41032.3">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="325" name="Rename_Cols" pos="-90^1391.4" pos_v12="-901391.4">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2AFull%20or%20abbrev"/>
            </parameters>
        </transform>
        <transform id="326" name="Substitute" pos="628.2^1391.4" pos_v12="628.21391.4">
            <parameters>
                <parameter type="7" name="New_Name" value="State%20regex"/>
                <parameter type="12" name="Script" value="%5Cb%24%28Full%20or%20abbrev%29%5Cb"/>
            </parameters>
        </transform>
        <transform id="335" name="Reorder" pos="867.6^1391.4" pos_v12="867.61391.4">
            <parameters>
                <parameter type="4" name="Columns" value="4123"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes>
        <note id="327" comment="Addresses" pos_v12="867.6912.6" color="255%1F255%1F179" arrow="3"/>
        <note id="328" comment="States" pos_v12="-329.41152" color="255%1F255%1F179" arrow="2"/>
        <note id="329" comment="Regex%20lookup%20table" pos_v12="867.61511.1" color="255%1F255%1F179" arrow="1"/>
        <note id="331" comment="Result" pos_v12="11071032.3" color="255%1F255%1F179" arrow="3"/>
    </notes>
    <connections>
        <connection start_id="312" end_id="323"/>
        <connection start_id="316" end_id="324"/>
        <connection start_id="316" end_id="319"/>
        <connection start_id="318" end_id="319"/>
        <connection start_id="319" end_id="325"/>
        <connection start_id="321" end_id="322"/>
        <connection start_id="322" end_id="326"/>
        <connection start_id="324" end_id="318"/>
        <connection start_id="325" end_id="321"/>
        <connection start_id="326" end_id="335"/>
        <connection start_id="335" end_id="323"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
