Remove excess spaces from a string of words

Anything related to Z12 Tools, ask for help and support, or give your feedback.
Post Reply
Admin
Site Admin
Posts: 8
Joined: Thu Sep 05, 2019 19:11
Location: England
Contact:

Remove excess spaces from a string of words

Post by Admin » Fri Sep 06, 2019 19:33

Z12's Word Trimmer - The easiest and fastest way to remove excess spaces from a string of words and optionally delimit the words.

From this:

Code: Select all

Rec_ID      Rec_Date                Run_Number  File_Type       Previous_File_Reference File_Reference      Line_Number Partner_Code         Product_Line         Service_Code Product_Warranty_Code Request_Flag Request_Date Request_Partner_Code Request_Reference_Source Request_Reference    Customer_Call_Date Customer_Failure_Code                         Customer_Escalation_Reason_Code Rer_Flag Rer_Code   Rer_Intervention_Reference     Customer_Type Customer_Partner_Code Customer_Country_Code Customer_Name                                                                                                            Customer_Address                                                                                                                                                                                                                                                 Customer_Zip_Code Customer_Phone                           Intervention_Partner_Code Intervention_Reference_Source Intervention_Reference Product_Number                                Product_Type Product_Option Product_Part_Number                                Product_Serial_Number                         Born_On_Date Collect_Defective_Flag Collect_Defective_Committed_Date Collect_Defective_Actual_Date Collect_By_Partner_Code        Receive_Defective_Flag Receive_Defective_Date Receive_By_Partner_Code Forward_Defective_Flag Forward_Defective_Date Forward_To_Partner_Code Repair_Flag Repair_Date Primary_Symptom_Code Repair_NFF_Flag Scrap_Defective_Product_Flag Scrap_Code Refurbish_Product_Flag Refurbish_Change_Serial_Flag Refurbish_New_Product_Number Refurbish_New_Serial_Number Exchange_Product_Flag Exchange_Product_Number Exchange_Product_Serial_Number Shipment_Flag Ship_Product_Date Delivery_Flag Delivery_Committed_Date Delivery_Actual_Date Delivery_Partner_Code          On_Hold_Flag On_Hold_Code                                                                                                                                                                                             On_Hold_WD_Number Closed_Month Part_Commodity_Code_1                              Part_Defect_Code_1   Repair_Action_1      Defective_Part_Vendor_Name_1                                 Defective_Part_Vendor_Number_1 Defective_Part_Serial_Number_1                     Defective_Part_PC_Doctor_Failure_Code_1 Ordered_Part_Number_1 Part_Exchange_Flag_1 Part_Commodity_Code_2                              Part_Defect_Code_2   Repair_Action_2      Defective_Part_Vendor_Name_2                                 Defective_Part_Vendor_Number_2 Defective_Part_Serial_Number_2                     Defective_Part_PC_Doctor_Failure_Code_2 Ordered_Part_Number_2 Part_Exchange_Flag_2 Part_Commodity_Code_3                              Part_Defect_Code_3   Repair_Action_3      Defective_Part_Vendor_Name_3                                 Defective_Part_Vendor_Number_3 Defective_Part_Serial_Number_3                     Defective_Part_PC_Doctor_Failure_Code_3 Ordered_Part_Number_3 Part_Exchange_Flag_3 Part_Commodity_Code_4                              Part_Defect_Code_4   Repair_Action_4      Defective_Part_Vendor_Name_4                                 Defective_Part_Vendor_Number_4 Defective_Part_Serial_Number_4                     Defective_Part_PC_Doctor_Failure_Code_4 Ordered_Part_Number_4 Part_Exchange_Flag_4 Part_Commodity_Code_5                              Part_Defect_Code_5   Repair_Action_5      Defective_Part_Vendor_Name_5                                 Defective_Part_Vendor_Number_5 Defective_Part_Serial_Number_5                     Defective_Part_PC_Doctor_Failure_Code_5 Ordered_Part_Number_5 Part_Exchange_Flag_5 ON_HOLD_REASON_CP ON_HOLD_REASON_CD ON_HOLD_REASON_BH ON_HOLD_REASON_BHP ON_HOLD_REASON_CNTF ON_HOLD_REASON_PASS ON_HOLD_REASON_ITW ON_HOLD_REASON_PSH ON_HOLD_REASON_CFE ON_HOLD_REASON_ENG ON_HOLD_REASON_FM ON_HOLD_REASON_RA ON_HOLD_REASON_CCID ON_HOLD_REASON_ST Premium_Unit Service_Category                                   Carrier_Collect_From_S2S_Date                      Customer_Collect_From_S2S_Date                     XXX  Closed_Date_System                                 Closed_Week Repair_Line          RL_Country_Code Split      Parts_CID  Parts_Non_CID Parts_CO   Parts_SW   Parts_RS   Parts_NP   LineID      UnitID      LooperCount UnitStatusID RmaID       PartID      AIO_Packaging Service_Type AWB_Collection                                     AWB_Delivery                                       Part_Not_In_BOM Actual_Repair_Collection_Date Actual_Defective_Delivery_Date Shop_Date  Som_Codes                                                                                                                                                                                                Platform                                           Engineer                                           C_Code_1st_Level                                                                                                                                                                                         C_Code_2nd_Level                                                                                                                                                                                         C_Code_3rd_Level
To this:

Code: Select all

Rec_ID, Rec_Date, Run_Number, File_Type, Previous_File_Reference, File_Reference, Line_Number, Partner_Code, Product_Line, Service_Code, Product_Warranty_Code, Request_Flag, Request_Date, Request_Partner_Code, Request_Reference_Source, Request_Reference, Customer_Call_Date, Customer_Failure_Code, Customer_Escalation_Reason_Code, Rer_Flag, Rer_Code, Rer_Intervention_Reference, Customer_Type, Customer_Partner_Code, Customer_Country_Code, Customer_Name, Customer_Address, Customer_Zip_Code, Customer_Phone, Intervention_Partner_Code, Intervention_Reference_Source, Intervention_Reference, Product_Number, Product_Type, Product_Option, Product_Part_Number, Product_Serial_Number, Born_On_Date, Collect_Defective_Flag, Collect_Defective_Committed_Date, Collect_Defective_Actual_Date, Collect_By_Partner_Code, Receive_Defective_Flag, Receive_Defective_Date, Receive_By_Partner_Code, Forward_Defective_Flag, Forward_Defective_Date, Forward_To_Partner_Code, Repair_Flag, Repair_Date, Primary_Symptom_Code, Repair_NFF_Flag, Scrap_Defective_Product_Flag, Scrap_Code, Refurbish_Product_Flag, Refurbish_Change_Serial_Flag, Refurbish_New_Product_Number, Refurbish_New_Serial_Number, Exchange_Product_Flag, Exchange_Product_Number, Exchange_Product_Serial_Number, Shipment_Flag, Ship_Product_Date, Delivery_Flag, Delivery_Committed_Date, Delivery_Actual_Date, Delivery_Partner_Code, On_Hold_Flag, On_Hold_Code, On_Hold_WD_Number, Closed_Month, Part_Commodity_Code_1, Part_Defect_Code_1, Repair_Action_1, Defective_Part_Vendor_Name_1, Defective_Part_Vendor_Number_1, Defective_Part_Serial_Number_1, Defective_Part_PC_Doctor_Failure_Code_1, Ordered_Part_Number_1, Part_Exchange_Flag_1, Part_Commodity_Code_2, Part_Defect_Code_2, Repair_Action_2, Defective_Part_Vendor_Name_2, Defective_Part_Vendor_Number_2, Defective_Part_Serial_Number_2, Defective_Part_PC_Doctor_Failure_Code_2, Ordered_Part_Number_2, Part_Exchange_Flag_2, Part_Commodity_Code_3, Part_Defect_Code_3, Repair_Action_3, Defective_Part_Vendor_Name_3, Defective_Part_Vendor_Number_3, Defective_Part_Serial_Number_3, Defective_Part_PC_Doctor_Failure_Code_3, Ordered_Part_Number_3, Part_Exchange_Flag_3, Part_Commodity_Code_4, Part_Defect_Code_4, Repair_Action_4, Defective_Part_Vendor_Name_4, Defective_Part_Vendor_Number_4, Defective_Part_Serial_Number_4, Defective_Part_PC_Doctor_Failure_Code_4, Ordered_Part_Number_4, Part_Exchange_Flag_4, Part_Commodity_Code_5, Part_Defect_Code_5, Repair_Action_5, Defective_Part_Vendor_Name_5, Defective_Part_Vendor_Number_5, Defective_Part_Serial_Number_5, Defective_Part_PC_Doctor_Failure_Code_5, Ordered_Part_Number_5, Part_Exchange_Flag_5, ON_HOLD_REASON_CP, ON_HOLD_REASON_CD, ON_HOLD_REASON_BH, ON_HOLD_REASON_BHP, ON_HOLD_REASON_CNTF, ON_HOLD_REASON_PASS, ON_HOLD_REASON_ITW, ON_HOLD_REASON_PSH, ON_HOLD_REASON_CFE, ON_HOLD_REASON_ENG, ON_HOLD_REASON_FM, ON_HOLD_REASON_RA, ON_HOLD_REASON_CCID, ON_HOLD_REASON_ST, Premium_Unit, Service_Category, Carrier_Collect_From_S2S_Date, Customer_Collect_From_S2S_Date, XXX, Closed_Date_System, Closed_Week, Repair_Line, RL_Country_Code, Split, Parts_CID, Parts_Non_CID, Parts_CO, Parts_SW, Parts_RS, Parts_NP, LineID, UnitID, LooperCount, UnitStatusID, RmaID, PartID, AIO_Packaging, Service_Type, AWB_Collection, AWB_Delivery, Part_Not_In_BOM, Actual_Repair_Collection_Date, Actual_Defective_Delivery_Date, Shop_Date, Som_Codes, Platform, Engineer, C_Code_1st_Level, C_Code_2nd_Level, C_Code_3rd_Level
At the click of a button

Post Reply