Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

how to Pick Iso Code From a String

Hi,

Can Some one Help me how can we identify 2 letter ISOCode From a Project Name Field.

For Example i have 2 project Names from below but i have to get "CA" and "US" From below Project Names.

i have thousand of values in a project Name Field  so i have to pull all ISO Codes From that Field.

It will be always after second hyphen or Third hyphen or always 10 digit number.

  

Proactive Services-2054898610-CA-LIQUOR DISTRIBUTION BRANCH
PS - HP Proactive Care-2151293980-US-Oklahoma Housing Finance Agency

Can Some one help  me to find out. For your reference i am attaching the Qlikview app.

Best Regards,

HK

1 Solution

Accepted Solutions
tamilarasu

Or

Subfield(Subfield(Purgechar(FieldName,'0123456789'),'--',2),'-',1) as FieldName

View solution in original post

6 Replies
tamilarasu

Hi HariKiran,

Try this

SubField( Mid( FieldName, FindOneOf(FieldName,'1234567890')),'-',2) as FieldName


ashwinishinde
Partner
Partner

Try This,

=SubField('Proactive Services-2054898610-CA-LIQUOR DISTRIBUTION BRANCH','-',3)

Anil_Babu_Samineni

Don't duplicate How to Pick ISO CODE from a Field

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tamilarasu

Or

Subfield(Subfield(Purgechar(FieldName,'0123456789'),'--',2),'-',1) as FieldName

View solution in original post

dunnalahk123
Creator III
Creator III
Author

Hi Anil,'

Yes, i am sorry, due to some connectivity issues i logged 2 times as i am not sure about the first one..

Thank You for all your help.

Best Regards,

dunnalahk123
Creator III
Creator III
Author

Hi Nagaraj,

Thank you for all your help and support.

Best Regards,

HK