<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="67"/>
        <last_saved_by value="Oryx_Digital_Ltd_using_Easy_Data_Transform_v1_45_0_on_Windows_10_Version_2009_at_2023_12_05_18_17_20"/>
        <locale value="en_GB"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="C%3A%5CUsers%5Candy%5CDesktop%5Cadvent-of-code.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-90^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90-45" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="0" ignore_empty_cols="0" trim="1" file_type="0" id="1137" custom_delimiter="%2A" ignore_repeated_delim="0" text="1abc2%0Apqr3stu8vwx%0Aa1b2c3d4e5f%0Atreb7uchet" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="1138" name="Replace_Multi" pos="388.8^-45" pos_v12="388.8-45">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="16" name="Replace" value="2%5CD"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1139" name="Extract" pos="628.2^-164.7" pos_v12="628.2-164.7">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="6" name="Using" value="Text"/>
                <parameter type="8" name="Length" value="1"/>
                <parameter type="6" name="From" value="Start"/>
                <parameter type="8" name="Offset" value="0"/>
                <parameter type="7" name="Matching" value="%5E.%2A%24"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1140" name="Extract" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="6" name="Using" value="Text"/>
                <parameter type="8" name="Length" value="1"/>
                <parameter type="6" name="From" value="End"/>
                <parameter type="8" name="Offset" value="0"/>
                <parameter type="7" name="Matching" value="%5E.%2A%24"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1143" name="Join" pos="867.6^-45" pos_v12="867.6-45">
            <parameters>
                <parameter type="0" name="Column_1" value="2"/>
                <parameter type="5" name="Include_Non_Matching_1" value="0"/>
                <parameter type="0" name="Column_2" value="2"/>
                <parameter type="5" name="Include_Non_Matching_2" value="0"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="5" name="Detailed_Report" value="0"/>
            </parameters>
        </transform>
        <transform id="1144" name="Concat" pos="1107^-45" pos_v12="1107-45">
            <parameters>
                <parameter type="1" name="Columns" value="13"/>
                <parameter type="7" name="Delimiter" value=""/>
                <parameter type="5" name="Keep_Empty" value="0"/>
            </parameters>
        </transform>
        <transform id="1145" name="Stats" pos="1346.4^-45" pos_v12="1346.4-45">
            <parameters>
                <parameter type="1" name="Columns" value="4"/>
                <parameter type="6" name="Calculation" value="Sum"/>
                <parameter type="8" name="Percentile" value="90"/>
                <parameter type="6" name="On" value="Columns"/>
            </parameters>
        </transform>
        <transform id="1146" name="Row_Num" pos="149.4^-45" pos_v12="149.4-45">
            <parameters>
                <parameter type="7" name="New_Name" value="Row%20Num"/>
                <parameter type="8" name="Start_At" value="1"/>
                <parameter type="8" name="Increment" value="1"/>
                <parameter type="8" name="Every" value="1"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="1137" end_id="1146"/>
        <connection start_id="1138" end_id="1139"/>
        <connection start_id="1138" end_id="1140"/>
        <connection start_id="1139" end_id="1143"/>
        <connection start_id="1140" end_id="1143"/>
        <connection start_id="1143" end_id="1144"/>
        <connection start_id="1144" end_id="1145"/>
        <connection start_id="1146" end_id="1138"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
