how to identify text

Muh_Arief
Muh_Arief
in Modeling

Muh_Arief_0-1587636414022.png

 I have two line item,  remarks And rem, remarks  is Text from data uploaded and then I want to on line item "Rem" just identify "Commission" and "Rebooking and Refund", but the problem is the words in front of it always change, I can't hardcode with mid, or right. how to fix it? any solution. thanks before

Tagged:

Answers

  • Harsha
    Harsha

    Hi @Muh_Arief ,

     

     

    You can use FIND function to find the starting position of the string you want. And then use mid to extract the word. 

     

    Example,

    I have REM line item which contains data,

    REMARKS line item has FIND("Commission", Rem) formula which returns starting position of Commission.

    Extract text line item has MID(Rem, Remarks, 10), I have specified the number of characters here as 10 because "commission" has 10.

    Harsha_D_0-1587702056325.png

     

    or you can do like this 

     

    Harsha_D_1-1587702730299.png

     

     

     

    Hope this helps you.

     

    Thanks,
    Harsha

     

  • Muh_Arief
    Muh_Arief
    on the second pictures, can you show the formula for line item "Commission position start" and refund and reschedule position"? thank you
  • Harsha
    Harsha

    Commission position start = FIND("Commission", Rem)

     

    refund and reschedule position = FIND("Rebooking and Refund", Rem)

     

     

  • Muh_Arief
    Muh_Arief

    oh oke, i will to try this. Thank you Harsha

  • Harsha
    Harsha

    Harsha_D_0-1587704373881.png

     

  • Muh_Arief
    Muh_Arief
    oke. many thanksss

Categories