Remove preceding Commas or Dots in string

[rupaliqlik]

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

stalwar1‌kaushik.solanki‌

[sunny_talwar]

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