topic Re: How to Trim a value in QlikView

How to Trim a value

Tue, 11 Feb 2014 07:31:47 GMT

Hi,

I Have id value like "0123458....." i want this value "0123458"how to trim this "........." value.

Re: How to Trim a value

Tue, 11 Feb 2014 07:33:21 GMT

try this

left('0123456789',9)

Re: How to Trim a value

Tue, 11 Feb 2014 07:34:17 GMT

try this

left('0123458.......',7)

Re: How to Trim a value

Tue, 11 Feb 2014 07:34:58 GMT

trim(s )

Returns the string s trimmed of any leading and trailing spaces.

Example:

trim ( ' abc' ) returns 'abc'

trim ( 'abc ' ) returns 'abc'

trim ( ' abc ' ) returns 'abc'

KeepChar(s1 , s2)

Returns the string s1 less all characters not contained in string s2.

Example:

keepchar ( 'a1b2c3','123' ) returns '123'

Re: How to Trim a value

Tue, 11 Feb 2014 07:36:12 GMT

the trim function would remove all spaces. I'm not sure if you ment to remove a period or spaces in your example.

Use Qlikview help to see all 'string functions'

Re: How to Trim a value

Tue, 11 Feb 2014 07:38:08 GMT

Hi Mani,

Try to this one

Let Lside=LTrim("0123458 ");

hope this will help you

Regards,

Re: How to Trim a value

giakoum — Tue, 11 Feb 2014 07:39:34 GMT

PurgeChar(s1, s2)

Returns the string s1 less all characters contained in string s2.

Example:

purgechar ( 'a1b2c3','123' ) returns 'abc'

so in your case purgechar ( '0123458.....','.' )

Re: How to Trim a value

MayilVahanan — Tue, 11 Feb 2014 07:42:52 GMT

Try like this

=KeepChar('0123458.....',1234567890) gives number only

=PurgeChar('0123458.....','.') gives 0123458

Re: How to Trim a value

Sokkorn — Tue, 11 Feb 2014 07:44:10 GMT

Hi Mani,

Use KeepChar( '0123458.....','0123456789' ) -> returns '0123458'

Regards,

Sokkorn

Re: How to Trim a value

Tue, 11 Feb 2014 07:48:51 GMT

Hi,

=Purgechar( Purgechar( Firldname, ' . ' ), '1''2''3''4')

=PurgeChar(Firldname,0123456789.)

=KeepChar(Firldname,123456789)

Regards,

Re: How to Trim a value

sunilkumarqv — Tue, 11 Feb 2014 07:52:12 GMT

Copy and past this in your script

=PurgeChar( '0123458.....',.) it returs 0123458

Re: How to Trim a value

preminqlik — Tue, 11 Feb 2014 09:07:14 GMT

replace(fieldname,'.',null()) as Newfieldname

Re: How to Trim a value

ThornOfCrowns — Tue, 11 Feb 2014 09:22:51 GMT

That's a lot of ways to do the same thing! I personally like the KeepChar function.

Re: How to Trim a value

Tue, 11 Feb 2014 09:23:52 GMT

Thanks to all, I have one more file like,

RT25698-R

ED56248-R

GR78542-S

How to remove the -R and -S value,Please give query.

Re: How to Trim a value

ThornOfCrowns — Tue, 11 Feb 2014 09:26:09 GMT

=Left(FieldName,7) if your values are all the same length.

Re: How to Trim a value

preminqlik — Tue, 11 Feb 2014 09:43:00 GMT

here u can use subfield(fieldname,'-',1)

Re: How to Trim a value

robert99 — Tue, 11 Feb 2014 09:55:53 GMT

or if not the same length

left (fieldname,index(fieldname,'-')-1) should work