Split part in Qlikview

[#1]

Hi,

I have data something like keerthi(3222).

I need to display Keerthi and 3222 separately.

Please help me with this

Thanks,

Keerthi KS

[#2]

Thanks Sasidhar. Its been a year working on Qlikview and forgot most of the functions.

[PrashantSangle]

Hi,

You can use maxstring()

Regards

[Kushal_Chawda]

As your field may be not fixed better approach would be as follows

Load *,

mid(Data,1,Index(Data,'(',-1)-1) as Name,

mid(Data,Index(Data,'(',-1)+1,Index(Data,')',-1)-(Index(Data,'(',-1)+1)) as Number

Inline [

Data

Keerthi (Raj) & Kumar (Raj) (234511)

];

[MayilVahanan]

Hi

Hope, the number occur at last.

LOAD *, Left(Data,FindOneOf(Data, Num)-2) as Start;

LOAD *, KeepChar(Data, 1234567890) AS Num Inline

[

Data

Keerthi (Raj) & Kumar (Raj) (2345)

];

[Ralf-Narfeldt]

A bit more complicated. Assumption is that there is a (1234) value at the end of each field value. If this is not true, it gets even more complicated.

PurgeChar(SubField(Input, '(', -1), ')') gives 2345

Left(Input, Index(Input, '(', -1) -1) gives Keerthi (Raj) & Kumar (Raj)

It's always hard to make this kind of cleaning without seeing a full data set, to see all patterns.

[sasiparupudi1]

Hi Keerthi,

It looks like everybody is using their imaginations and giving  many solutions to the posed question..Wouldnt it be better if you loaded a sample data file for us?

Sasi

[#8]

Please find the attached for data. Number at the end should get separately.

In the sample data. There is a name(Full name along with partner name) followed by Unit number.

I want the name and Unit number separately

[MayilVahanan]

Hi

Try like this

LOAD *, If(Isnull(Num) or Len(Num) = 0, Data, Left(Data,FindOneOf(Data, Num)-2)) as Start;

LOAD *, KeepChar(Data, 1234567890) AS Num Inline

[

Data

Keerthi (Raj) & Kumar (Raj) (2345)

Keerthi

];

[#10]

Please find the attached QVW

[jagan]

Hi Keerthi,

Who will create sample data for the attached image?  Instead of attaching the screenshot of the data, you can attach direct values in Excel or any other format.  It is always good to attach data in excel and your expected values against it.

So that it would be easier to understand the requirement and minimizes the number of replies.

Check below link, hope it helps you in getting the answers faster.

Qlik Community Tip: Posting Successful Discussion Threads

Regards,

Jagan.