Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Only show value after 'specific character'?

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

1 Solution

Accepted Solutions
Not applicable
Author

To get anything after the # sign:

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



View solution in original post

3 Replies
Not applicable
Author

To get anything after the # sign:

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



khadeer
Specialist
Specialist

PFA

Not applicable
Author

Hi All,

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

Thanks again!

Nicholas