Delete a value

[#1]

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.

[MayilVahanan]

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

[edg_baltazar]

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!

[#4]

Hi,

Try this->

LOAD

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

Resident T1;

Regards

Apurva