topic Re: How to trim last 10 characters in a filed ? in QlikView

How to trim last 10 characters in a filed ?

Mon, 15 Jun 2015 16:11:39 GMT

Hi,

How to trim the last 10 digits from the below data?

Field:

xxxxx1234569878

yyyy1235409876

zzzzzzz6547876534

Expected results:

Filed:

xxxxx

yyyy

zzzzzzz

Thanks

stigchel — Mon, 15 Jun 2015 16:13:53 GMT

Use the Purgechar function e.g.

PurgeChar(Field,'0123456789') as NewField

sunny_talwar — Mon, 15 Jun 2015 16:17:46 GMT

It may be an issue if the first part of thr string contains number also, may be an alternative could be:

=Left('xxxxx1234569878', Len('xxxxx1234569878')-10) (Generically =Left(Field, Len(Field)-10))

Best,

Sunny

Mon, 15 Jun 2015 16:20:07 GMT

Thanks,

But i also have data like

Filed:

3ddd1234786098,

cc56hh3457689087

In this case i want the results as

3ddd

cc56hh

sunny_talwar — Mon, 15 Jun 2015 16:20:38 GMT

Try this:

=Left('xxxxx1234569878', Len('xxxxx1234569878')-10) (Generically =Left(Field, Len(Field)-10))

Mon, 15 Jun 2015 17:16:27 GMT

Thanks alot

sunny_talwar — Mon, 15 Jun 2015 17:21:44 GMT

Not a problem.

Best,

Sunny