topic Re: Delete a value in QlikView

Delete a value

Tue, 26 Jun 2012 18:35:27 GMT

I have the following values within a column.

"2012-05-25 08:23:10

"2012-05-25 08:23:20

"2012-05-25 08:23:34

"2012-05-25 08:23:43

"2012-05-25 08:24:02

"2012-05-25 08:24:14

"2012-05-25 08:24:49

"2012-05-25 08:25:01

"2012-05-25 08:25:14

"2012-05-25 08:25:25

"2012-05-25 08:25:46

"2012-05-25 08:25:59

"2012-05-25 08:26:09

I need to delete only the " all rows.

Re: Delete a value

MayilVahanan — Tue, 26 Jun 2012 18:57:08 GMT

Hi,

Try this,

T1:
Load * Inline
[
Testing

"2012-05-25 08:23:10
"2012-05-25 08:23:20
"2012-05-25 08:23:34
"2012-05-25 08:23:43
"2012-05-25 08:24:02
"2012-05-25 08:24:14
"2012-05-25 08:24:49
"2012-05-25 08:25:01
"2012-05-25 08:25:14
"2012-05-25 08:25:25
"2012-05-25 08:25:46
"2012-05-25 08:25:59
"2012-05-25 08:26:09

];

Load Right(Testing,Len(Testing)-1) as ValidDate Resident T1;

Hope it helps

Re: Delete a value

edg_baltazar — Wed, 27 Jun 2012 03:25:51 GMT

Hi Osvaldoberg! you can use purgechar function it's very easy...

here is the syntax...

PurgeChar(s1, s2)

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

So when loading the field where is contained this data that you want to clean just use this

PurgeChar(field,'"') as field

Regards!

Re: Delete a value

Wed, 27 Jun 2012 06:29:30 GMT

Hi,

Try this->

LOAD

SubField(Trim(Testing),'"',2) as Testing1

Resident T1;

Regards

Apurva