Solved Which function to use

[Nidhi]

I have a data item which contains the text "Start Hi There End ".

I need to extract anything which is between Start and End .Data keeps changing between Start and End .Some times nothing can be there .Ex :"Start End "
Which function to use ?

 

[VJR]

Hi Nidhi,

You will need to replace the words Start and End with an empty string in order to get the resultant string between them. Then you can Trim it if you also need to remove the spaces in them.
So you will need to use a combination of the Replace and the Trim functions. You can use a single 'Multi Calc' stage instead of several Calc stages.



PS: Since you asked "which function to use" it looks like you want to practice it on your own so respecting that I haven't pasted the direct function line here . But please feel free to post back in case of any issues in doing so.

 

[vinay]

Hi Nidhi,

You will need to replace the words Start and End with an empty string in order to get the resultant string between them. Then you can Trim it if you also need to remove the spaces in them.
So you will need to use a combination of the Replace and the Trim functions. You can use a single 'Multi Calc' stage instead of several Calc stages.



PS: Since you asked "which function to use" it looks like you want to practice it on your own so respecting that I haven't pasted the direct function line here . But please feel free to post back in case of any issues in doing so.

Hi VJR can you paste the original function with logic..Thankyou

 

[cs.andras]

Hi VJR can you paste the original function with logic..Thankyou

It would be something like this:
Trim(Replace(Replace([Data1],"End",""), "Start", ""))

 

[vinay]

Trim(Replace(Replace([Data1],"End",""), "Start", ""))

Thankyou..its working