topic String Function in QlikView

String Function

Thu, 04 Aug 2016 05:58:55 GMT

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

Re: String Function

tresB — Thu, 04 Aug 2016 06:06:30 GMT

Try like:

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

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

Re: String Function

sdmech81 — Thu, 04 Aug 2016 06:13:49 GMT

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

Re: String Function

fashid — Thu, 04 Aug 2016 06:36:31 GMT

Hi Snehal,

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

Hopefully u can get amount also.

Regards,

Nadeem

Re: String Function

Thu, 04 Aug 2016 07:13:30 GMT

Thanx Its working

Re: String Function

tresB — Thu, 04 Aug 2016 12:42:15 GMT

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