Skip to content
TheChatArchiveThe Chat Archive
Qwenqwen-max-2025-01-25· Alibaba (Qwen)Hugging Face LMArena Human Preference 140K

LINE NUMBER LS- 79006-14"-1S1G DG-78003-3"-1P1 IG-RB75001-1"-U1G IG-75001-2"-U1G…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with Googlegemma-3-27b-it’s answer.
  1. User

    LINE NUMBER LS- 79006-14"-1S1G DG-78003-3"-1P1 IG-RB75001-1"-U1G IG-75001-2"-U1G IG-RB75001-1-U1G-1"-U1 NA-98006-1"-3PS1G NA-98006-3/4"-3PS1G PW-98008-1"-1P1G PW-98008-1"-3P1B SH-98003-2"-6S1G-HI LS-98033-3"-1S1G-HI LS-980XXX-3"-1S1 O-98043-3"-3P1B-HI O-75092-4"-3P1G O-78081-2"-3P1G O-78023-3"-3P1-PP25 O-78070-2"-1P1G O-78070-3/4"-1P1G O-78051-2"-3P1G O-78007-4"-3P1G O-78004-3"-1P1ZG RV-78027-6"-1P1G RV-78027-4"-1P1G O-78068-6"-1P1G RV-98012-10"-1P2G 3P1B-HI-1" RV-RB98002-3"-1P2 RV-98013-3"-1P2G O-98040-1"-3P1B-HI RV-98032-2"1P2G O-98131-1"-6H2B RV-98007-3"-1P2G RV-98007-2"-6P1B RV-98006-3"-1P2G RV-98001-12"-1P2G RV-98032-4"-1P2G O-98042-3"-3P1B-HI RV-3P1B-HI-8" RV-1"3P1B-HI O-98011-3"-6P1B-HI O-RB98001-2"-6P1B O-98040-3"-3P1B-HI O-98040-2"-3P1B-HI RV-79038-2"-3XIYG-HI RV-79038-1.5"-3XIYG RV-79038-2"-3XIYG. I NEED TO EXTRACT THE TEXT AFTER "- SYMBOL TO AGAIN THE - THIS SYMBOL ENDING . HOW I MAKE EXCEL FORMULA

  2. Qwen Assistant

    To extract the text between the first and second hyphens (-) in each line of your data, you can use a combination of Excel functions like MID, FIND, and LEN. Here's how you can create the formula step by step:


    Step-by-Step Formula Explanation

    1. Find the position of the first hyphen (-): Use the FIND function to locate the position of the first hyphen in the string.

      FIND("-", A1)
      
    2. Find the position of the second hyphen (-): To find the second hyphen, use the FIND function again, but this time start searching after the first hyphen.

      FIND("-", A1, FIND("-", A1) + 1)
      
    3. Extract the text between the two hyphens: Use the MID function to extract the substring starting after the first hyphen and ending before the second hyphen. The length of the substring is the difference between the positions of the second and first hyphens, minus 1.

      MID(A1, FIND("-", A1) + 1, FIND("-", A1, FIND("-", A1) + 1) - FIND("-", A1) - 1)
      

    Final Formula

    Assuming your data starts in cell A1, the complete formula to extract the text between the first and second hyphens is:

    =MID(A1, FIND("-", A1) + 1, FIND("-", A1, FIND("-", A1) + 1) - FIND("-", A1) - 1)
    

    Example Output

    Input TextExtracted Text
    LS-79006-14"-1S1G79006
    DG-78003-3"-1P178003
    IG-RB75001-1"-U1GRB75001
    IG-75001-2"-U1G75001
    IG-RB75001-1-U1G-1"-U1RB75001
    NA-98006-1"-3PS1G98006

    Notes

    1. Error Handling: If some lines do not have two hyphens, the formula will return an error. To handle this, wrap the formula with IFERROR:

      =IFERROR(MID(A1, FIND("-", A1) + 1, FIND("-", A1, FIND("-", A1) + 1) - FIND("-", A1) - 1), "No Match")
      
    2. Dynamic Ranges: If your data spans multiple rows, drag the formula down to apply it to all rows.

    3. Special Cases: If there are additional complexities (e.g., inconsistent formats), you may need to adjust the formula or preprocess the data.


    Final Answer

    The formula to extract text between the first and second hyphens is:

    =MID(A1,FIND("−",A1)+1,FIND("−",A1,FIND("−",A1)+1)−FIND("−",A1)−1)\boxed{=MID(A1, FIND("-", A1) + 1, FIND("-", A1, FIND("-", A1) + 1) - FIND("-", A1) - 1)}

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.