how to identify text

Highlighted
Occasional Contributor

how to identify text

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

6 REPLIES 6
Highlighted
Frequent Contributor

Re: how to identify text

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

 

Highlighted
Occasional Contributor

Re: how to identify text

on the second pictures, can you show the formula for line item "Commission position start" and refund and reschedule position"? thank you
Highlighted
Frequent Contributor

Re: how to identify text

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

 

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

 

 

Highlighted
Occasional Contributor

Re: how to identify text

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

Highlighted
Frequent Contributor

Re: how to identify text

Harsha_D_0-1587704373881.png

 

Highlighted
Occasional Contributor

Re: how to identify text

oke. many thanksss