Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Remove preceding Commas or Dots in string

Hi Experts,

I have one column in my data(Name Column).But some data is not in correct format.I want to remove preceding commas and dots and keep name as it is.I tried this Mid(NAME, FindOneOf(NAME, ',  ')) but where data is like B.Mahin Abubackar Sithik is also reflect like Abubackar Sithik .


Eg

Original column Field                      Output                                 Expected

B.Mahin Abubackar Sithik              Abubackar Sithik                  B.Mahin Abubackar Sithik     (As it is )

. Aamir Sohail                                 Aamir Sohaill                         Aamir Sohail        (coming correct)

Chetankumar Prahladbhai Patel    Prahladbhai Patel                Chetankumar Prahladbhai Patel (As it is )



My logic is not working properly .Please help in this case.


Regards,

RUP

stalwar1kaushik.solanki

Tags (1)
1 Reply
Highlighted

Re: Remove preceding Commas or Dots in string

Try this

Table:

LOAD If(FindOneOf(NAME, ',.') <= FindOneOf(Upper(NAME), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'), Mid(NAME, FindOneOf(Upper(NAME), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')), NAME) AS NewName,

NAME

FROM

[..\..\Downloads\Client Name.xls]

(biff, embedded labels, table is Sheet1$);