<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="72"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_v1_48_0_on_macOS_14_7_at_2024_10_21_22_15_40"/>
        <locale value="de_DE"/>
        <id value="7c000508317307010a7576013809"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2FDownloads%2Fpb_comments.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" ignore_excel_hidden_cols="0" schema_in_use="0" name="Clipboard" schema_extra_cols="0" pos_v12="-90-45" 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="1353" custom_delimiter="%2A" ignore_repeated_delim="0" text="Vorname%2CNachname%0ANataliya%2CDaskalov%0AAmar%2CDaoud%0A%22Gajic%2CMilka%22%2C%0A%22Ismail%2CHourtzan%22%2C" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="1354" name="Split" pos="149.4^-45" comment="Splitt%20the%20column%20%22Vorname%22%20into%20multiple%20columns%20for%20each%20%2C%20in%20the%20fiels%20Vorname.%20In%20this%20exampel%2C%20max%202%20columns%20could%20be%20more.%0AThe%20resulting%20field%20are%20name%20Vorname%201%20...%20Vorname%20N" pos_v12="149.4-45">
            <parameters>
                <parameter type="0" name="Columns" value="1"/>
                <parameter type="6" name="Delimiter_Type" value="Text%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%2C"/>
                <parameter type="7" name="Lengths" value="2%2C1%2C%2A"/>
                <parameter type="6" name="Into" value="Columns"/>
                <parameter type="6" name="Order" value="Current"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="1355" name="If" pos="388.8^-45" comment="The%20if%20transformation%20creates%20a%20new%20Column%2C%20withe%20the%20name%20given%20in%20the%20%20field%20%22New%20column%20name%22%2C%20here%20%22clean%20Vorname%22.%0AFrom%20my%20perspective%20this%20if%20tranfromation%20is%20not%20needed%2C%20as%20the%20field%20Vorneme%201%20includes%20everytime%20the%20wished%20result.%20Therefore%20I%20put%20in%20the%20bottom%20part%20a%20renmae%20instead." pos_v12="388.8-45">
            <parameters>
                <parameter type="7" name="New_Name" value="clean%20Vorname"/>
                <parameter type="10" name="If" value="*StartIf*320*EndIf*%24%28Vorname1%29%24%28Vorname%29"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1356" name="If" pos="628.2^-45" comment="The%20IF%20statment%20creates%20teh%20nwe%20column%20%22Clean%20Nachname%22.%0A%0AIn%20case%20the%20original%20existin%20filed%20Nachname%20is%20not%20empty%2C%20it%20takes%20the%20value%20of%20this%20original%20field%20%28in%20EDT%20you%20address%20%20witht%20the%20%24%20sign%20and%20following%20brackets%20the%20name%20of%20the%20field%20you%20want%20to%20use.%0AIf%20the%20field%20is%20empty%20it%20takes%20the%20field%20from%20the%20split%20column%20Vorname2%20%20%24%28Vorname2%29" pos_v12="628.2-45">
            <parameters>
                <parameter type="7" name="New_Name" value="Clean%20Nachname"/>
                <parameter type="10" name="If" value="*StartIf*220*EndIf*%24%28Nachname%29%24%28Vorname2%29"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1357" name="Remove" pos="867.6^-45" comment="In%20this%20last%20remove%20steps%20all%20columns%20are%20removed%20%28which%20are%20not%20ticked%29%20and%20only%20the%20two%20columns%20remains" pos_v12="867.6-45">
            <parameters>
                <parameter type="11" name="Columns" value="56"/>
            </parameters>
        </transform>
        <transform id="1359" name="If" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="7" name="New_Name" value="Clean%20Nachname"/>
                <parameter type="10" name="If" value="*StartIf*220*EndIf*%24%28Nachname%29%24%28Vorname2%29"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1360" name="Remove" pos="867.6^74.7" pos_v12="867.674.7">
            <parameters>
                <parameter type="11" name="Columns" value="35"/>
            </parameters>
        </transform>
        <transform id="1361" name="Rename_Cols" pos="388.8^74.7" comment="The%20field%20Vorname1%20should%20include%20in%20any%20case%20the%20wished%20Vornanem%2C%20ther%20for%20I%20replaced%20the%20if%20statement%20with%20a%20rename%20an%20neme%20the%20field%20%22Cean%20Vorname%22" pos_v12="388.874.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2AClean%20Vorname%2ANORENAME%2A"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="1353" end_id="1354"/>
        <connection start_id="1354" end_id="1355"/>
        <connection start_id="1354" end_id="1361"/>
        <connection start_id="1355" end_id="1356"/>
        <connection start_id="1356" end_id="1357"/>
        <connection start_id="1359" end_id="1360"/>
        <connection start_id="1361" end_id="1359"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
