Oracle double byte space...

[WTFH]

They are definitely spaces, thanks for the help everyone, I've got the ClientCo to assign a permie in the US to the issue, meanwhile the IT manager out here is going to try to extract the data from their AS/400 without the spaces and send it to me again to upload.

[DimPrawn]

AS/400, blimey if it actually says that on the box it make a ZX81 look youthful.

[stek]

IBM i now....

[DimPrawn]

IBM i now....

It was renamed iSeries in 2000, keep up grandad.

Like calling your laptop now "an IBM PC compatible".

[MrMarkyMark]

They are definitely spaces, thanks for the help everyone, I've got the ClientCo to assign a permie in the US to the issue, meanwhile the IT manager out here is going to try to extract the data from their AS/400 without the spaces and send it to me again to upload.

Notepad ++ may tell a different story as eek has suggested

[mudskipper]

Dump might tell you what you're looking at.

https://www.techonthenet.com/oracle/functions/dump.php

[eek]

Notepad ++ may tell a different story as eek has suggested

Offloading it to some poor sod not on cuk sounds like a far better plan and I heartedly approve of wtfh's approach

[RonBW]

It looks like this:


ド　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 ||

ド　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　||

(I've added a || at the end to make it easier to see)

I copied your string into SQL Developer and those aren't spaces:

WITH xyz AS ( SELECT 'ド　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 ' txt FROM DUAL
              UNION
              SELECT '1          ' from dual
              UNION
              SELECT '2　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 ' txt FROM DUAL
            )
SELECT txt
,      LENGTH(txt)
,      RTRIM(txt)
,      LENGTH(RTRIM(txt))
,      TRIM(txt)
,      LENGTH(TRIM(txt))
,      ASCIISTR(txt)
FROM   xyz;

Your string includes UNICODE characters:

\30C9\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000\3000

So the last character is a space but the rest of them aren't. You could include a REPLACE to remove those non-ASCII characters if that would help:

RTRIM(REPLACE(txt,UNISTR('\3000'),' '))

[WTFH]

Ah, now that makes sense - Unicode character 3000 is an ideographic space. Tomorrow I will have a play in SQL.

Thanks!

[MrMarkyMark]

They are definitely spaces, thanks for the help everyone, I've got the ClientCo to assign a permie in the US to the issue, meanwhile the IT manager out here is going to try to extract the data from their AS/400 without the spaces and send it to me again to upload.

The other possible thing is he could have unknown characters in there, also.
I had this once and only realised they were there after I had looked at the data in a hexadecimal editor.

I copied your string into SQL Developer and those aren't spaces

A little bit of advice............in future do yourself a favour and pay for the true professionals to come in, I'm quite cheap, all told, really