Spacing

[smilingjohn]

Hi All, 

I have fetched the data from Oracle DB and converted into  QVD . 

I have field called Dept when i load the data , I see 2 two TSTS as shown in the screenshot below . 

One is with space and the other is witout space . How do i make it as one entry . 

Thanks in Avdnace 

[smilingjohn]

Hi Communtiy,

Any help on this ?

[QFabian]

hi!, trying to use this in your script :

trim(Dept) as Dept ,

[smilingjohn]

Trim dont work still it shows double values

[QFabian]

where is showing the unexpected value?, a filter?

[smilingjohn]

thhis showing in list box as well as in the table and charts . it is shwoing 2 values one with sapce and and with no space

[smilingjohn]

Hi All

Can't we remove the double entry

[FakeJupiter · Accepted solution]

Hi.

Tell me more about the field.

Are all values supposed to be 4 letters long?

If so, try this in script:

left(Dept, 4) as Dept

If that doesn't help, you can try:

keepchar (Dept,'abcdefghijklmnopqrstuvwxyz' ) as Dept

[smilingjohn]

Thanks @FakeJupiter  ,

No , there are of different length and many . 

I want it to appear it as single values , I tried with trim function but still no effect . the output shows 2 values  with space .

[FakeJupiter]

Did the keepchar function I posted before work?