Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
Hi Abhijitnalekar,
I tried but it's not working.
Thanks.
Ram
What precisely was the issue with the suggestion from @abhijitnalekar? In any case, try this
Replace(name, '''s', '') as name
Hi BrunPierre,
I got a solution.
By using this formula, Left(Fieldname, Len(trim(Fieldname))-2)
Thanks ,
Ram