Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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!
Hi,
Try this->
LOAD
SubField(Trim(Testing),'"',2) as Testing1
Resident T1;
Regards
Apurva