topic Re: delete right part from string and keep left in QlikView

delete right part from string and keep left

pepe2209 — Thu, 30 Jan 2014 10:26:36 GMT

Hello

I would like to keep te left part of a string value, but the length of the left part is variable. see example:

100023Feb2013

10034Jun2013

2300Jan2012

so i would like to delete the right 7 characters of the string and keep whatever is left. Being:

100023

10034

2300

your help would be much appreciated.

regards Peter

Peter_Cammaert — Thu, 30 Jan 2014 10:31:21 GMT

How about this (I'm assuming you want to apply this in your load script)?

... left(SourceField, index(SourceField, right(SourceField, 7))) AS LeftPart ...

Peter

Anonymous — Thu, 30 Jan 2014 10:32:21 GMT

Peter

Would something like this help ?

= left ( '100023Feb2013' , len( '100023Feb2013' ) -7 )

Best Regards, Bill

jvishnuram — Thu, 30 Jan 2014 10:33:33 GMT

Hi Peter,

Try this replace('100023Feb2013',Right('100023Feb2013',7),'')

Thu, 30 Jan 2014 10:34:02 GMT

Hi,

A way to do it:

Left(StringField,Len(StringField)-7)

Regards

alexandros17 — Thu, 30 Jan 2014 10:35:15 GMT

mid('10034Jun2013', 1, len('10034Jun2013')-7)

pepe2209 — Thu, 30 Jan 2014 10:42:45 GMT

Thanks for the quick response everybody.

i've used Peter Cammaert's solution

thanks again