how to identify text

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

Accepted answers

All comments

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.

or you can do like this

Hope this helps you.

Thanks,
Harsha

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

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

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

Muh_Arief

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

Harsha

Muh_Arief

oke. many thanksss

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…