Got more questions? Find advice on: ASP | SQL | XML | Windows
in Search
Welcome to RegexAdvice Sign in | Join | Help

Please advise

Last post 07-08-2008, 12:03 PM by mash. 3 replies.
Sort Posts: Previous Next
  •  07-08-2008, 6:35 AM 43857

    Please advise

    I am using RegEx in framwork .Net ver 2.0.

     I need to replace separator with everywhere in the string except in time value.

    The source string:

    07022V3EX000020,FW_CLASS:SUBDOCFW_OBJECT_ID:07022V3EX000020TP2V3_PROC_SLA_START:6TP2V3_WI_APPLIC_NO:DP004TP2V3_WI_CONTEXT:CON2TP2V3_WI_DATE_CREATED:2007-01-22TP2V3_WI_DATE_TIME:2008-05-15 16:45:12TP2V3_WI_DOC_TYPE:HelloTP2V3_WI_PRIORITY:6TP2V3_WI_SCRIPT_ERROR:Err  CALC_STEP_SLA Object requiredTP2V3_WI_WORK_TYPE:SUBDOCTP2V3_WI_WORKSTEP:PROCESS DOCUMENTS,00000000000004DB

    the result string should be:

    07022V3EX000020,FW_CLASS-SUBDOCFW_OBJECT_ID-07022V3EX000020TP2V3_PROC_SLA_START-6TP2V3_WI_APPLIC_NO-DP004TP2V3_WI_CONTEXT-CON2TP2V3_WI_DATE_CREATED-2007-01-22TP2V3_WI_DATE_TIME-2008-05-15 16:45:12TP2V3_WI_DOC_TYPE-HelloTP2V3_WI_PRIORITY-6TP2V3_WI_SCRIPT_ERROR-Err  CALC_STEP_SLA Object requiredTP2V3_WI_WORK_TYPE-SUBDOCTP2V3_WI_WORKSTEP-PROCESS DOCUMENTS,00000000000004DB
     

      I wrote exp :[^(?<time>(\d{2}:\d{2}:\d{2}))]

     but it does not work. Please advise me any solution. Thanks.

     

     

  •  07-08-2008, 6:57 AM 43859 in reply to 43857

    Re: Please advise

    Raw Match Pattern:
    (?<!\d\d):

    Raw Replace Pattern:
    -

    Based on your source example.


  •  07-08-2008, 8:08 AM 43863 in reply to 43859

    Re: Please advise

    Thx it is good solution!

  •  07-08-2008, 12:03 PM 43894 in reply to 43857

    Re: Please advise

    trickymail:

      I wrote exp :[^(?<time>(\d{2}:\d{2}:\d{2}))]

     but it does not work. Please advise me any solution. Thanks.

     

     

    http://regexadvice.com/blogs/mash/archive/2008/01/31/A-touch-of-Character-Class.aspx


    Michael

    "In theory, theory and practice are the same. In practice, they are not."
    Albert Einstein
View as RSS news feed in XML