topic Re: Only show value after 'specific character'? in QlikView

Only show value after 'specific character'?

Mon, 07 Jan 2013 17:42:10 GMT

Hi All,

I tried to find this answer in the community but could not find anything.

I am pulling information from sharepoint and some of the data comes through with extra Numbers and characters, for example "1201;# ABCD Funding 2013-II,ltd." I tried using purgechar(Legal_Name, '0123456789;#') but the problem i run into is that i need all the information after the # including the 2013. The data is consistent when pulled through, so i am looking for a way to pull in the data after '#'. I can't use the right count function becasue the initial 1201 number may be different.

Thank you for your help!

Nicholas

Re: Only show value after 'specific character'?

Mon, 07 Jan 2013 17:49:14 GMT

To get anything after the # sign:

=Right(YourField,Len(YourField)-Index(YourField,'#'))

Re: Only show value after 'specific character'?

khadeer — Tue, 08 Jan 2013 05:19:10 GMT

PFA

Re: Only show value after 'specific character'?

Tue, 08 Jan 2013 16:23:36 GMT

Hi All,

Thank you for yoru help. I was able to get the function working correctly.

Thanks again!

Nicholas