topic Re: Expression Help in QlikView

Expression Help

abhaysingh — Tue, 18 Nov 2014 08:02:21 GMT

i have customer name and customer code together

ex-

D300098-Abhay Singh

E100094-B.Ahlawat

w9995ii - xyz

i want the names only from them.

i have tried Left and Right function but not getting proper result.

can any one help me in that.

regards

abhay

Re: Expression Help

tresB — Tue, 18 Nov 2014 08:05:27 GMT

Try with subfield(), like:

Load

SubField(YourStringField,'-', 2) as Name

Re: Expression Help

Tue, 18 Nov 2014 08:10:08 GMT

Hi,

Try this

Table:

Load code_Name,

subfield(code_Name,'-',1) as code,

trim(subfield(code_Name,'-',2)) as Name

From Table;

Re: Expression Help

Tue, 18 Nov 2014 08:11:24 GMT

try like this

keepchar(yoursting,'a-z')

Re: Expression Help

ashfaq_haseeb — Tue, 18 Nov 2014 08:12:18 GMT

Hi,

For name try this

SubField(YourField,'-', 2) as Name

For Customer code try this

SubField(YourField,'-', 1) as CustomerCode

Regards

ASHFAQ

Re: Expression Help

MK_QSL — Tue, 18 Nov 2014 08:13:03 GMT

SubField(YourFieldName,'-',-1) as Name

Re: Expression Help

abhaysingh — Tue, 18 Nov 2014 08:22:52 GMT

thanks ashfaq it is working

Re: Expression Help

ashfaq_haseeb — Tue, 18 Nov 2014 08:24:16 GMT

Please close the thread by selecting appropriate answers.

Regards

ASHFAQ

Re: Expression Help

rubenmarin — Tue, 18 Nov 2014 08:24:49 GMT

Hi, you also can try:

Trim(Mid(YourField, Index(YourField, '-')+1))

Re: Expression Help

abhaysingh — Tue, 18 Nov 2014 08:28:04 GMT

this is getting me only character "a, - , z"

Re: Expression Help

MK_QSL — Tue, 18 Nov 2014 08:36:42 GMT

Hi Abhay, Glad that you got your answer...

Just a simple question. what was wrong in tresesco and rakesh goud reply?

Or you haven't tried their replies?

Hope that whenever anyone asking questions, they should tick Helpful and Correct answer based on First Come First Serve Basis.... This would encourage to reply..

Request you to take my above words positively rather than taking personally...

Happy Qliking !

Re: Expression Help

abhaysingh — Tue, 18 Nov 2014 08:48:24 GMT

Dear manish nothing is personal in this,

i am trying to learn different different way to sort out this kind of prob.

and i just want to share the output i am getting with this expression.

heartly thanks to revert on my post,hope to be connected in future

thanks

abhay