Remove the ' s values in dimension values

[Ramu_i]

Hi All,

I have dimension, here data have Vijaya's, Rajesh's, Kamal's.

Here remove the 's in the name dimension.

Out put:

Vijaya

Rajesh,

Kamal

Thanks advance.

[abhijitnalekar]

Hi @Ramu_i ,

You can write expression as below

load *,
left(name,Index(name,'''')-1) as newName ;

Load*

Inline
[ name
Ajay's
vijay's
dk's
asdasdas's

];

[Ramu_i]

Hi Abhijitnalekar,

I tried but it's not working.

Thanks.

Ram

[BrunPierre]

What precisely was the issue with the suggestion from @abhijitnalekar? In any case, try this

Replace(name, '''s', '') as name

[Ramu_i]

Hi BrunPierre,

I got a solution.

By  using this formula,   Left(Fieldname, Len(trim(Fieldname))-2)   

Thanks ,

Ram