String Function

[#1]

Hello friends,

Need your help !!!

I have to fetch cost and time highlighted below  in bold letters  from a given 2  strings

ex:-Revised estimated for AB01BE5212 - delivery time: 09 - Jan - 16 04:00 PM, cost: Rs 10,520.92 + taxes.

      Revised estimated for BR91YI0923 - Delivery Date and Time: 06 - Jul - 16 07:34 PM, cost: Rs 18,106.72 + taxes

[tresesco]

Try like:

TextBetween(lower(YourString), 'time'  , 'cost') as Time

Num(TextBetween(lower(YourString), 'rs'  , '+')) as Cost

[sdmech81]

Hi Snehal,

Use subfield function.

Just check in community how it works.It will solve your purpose.First check whether the strings coming to you are consistent or not.If so,subfield is good to go.

Still doubt please get in touch.

--sachin

[fashid]

Hi Snehal,

Check the qvw i have used subfeild function ! to get the time .

Hopefully u can get amount also.

Regards,

Nadeem

[#5]

Thanx Its working

[tresesco]

Please close the thread by marking the correct answer 'Correct'.