Remove preceding Commas or Dots in string

rupaliqlik — Wed, 26 Jul 2017 16:36:54 GMT

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 .

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

stalwar1‌kaushik.solanki‌

Re: Remove preceding Commas or Dots in string

sunny_talwar — Wed, 26 Jul 2017 16:43:13 GMT

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$);

topic Remove preceding Commas or Dots in string in QlikView

Remove preceding Commas or Dots in string

Re: Remove preceding Commas or Dots in string