Hi All, I have this metadata

  
FILENAME=GOJS, SUFFIX=SQLORA  , $
  SEGMENT=GOJS, SEGTYPE=S0, $
    FIELDNAME=KEY, ALIAS=KEY, USAGE=P13, ACTUAL=P7, $
    FIELDNAME=JSON, ALIAS=JSON, USAGE=TX1, ACTUAL=TX,
      MISSING=ON, $

this code

TABLE FILE GOJS
PRINT
 JSON
 WHERE KEY EQ 1
ON TABLE PCHOLD FORMAT ALPHA
END
-RUN

and this data

Key= 1
JSON=
{ "class": "go.GraphLinksModel",  "modelData": ...

I am using TX1 but it not showing records with the spaces. In other words it shows:

{
"
c
l
a
...

and I want

{
"
 
c
l
a
...

I have tried other version of TX for example

    FIELDNAME=JSON, ALIAS=JSON, USAGE=TX1, ACTUAL=TX,
      MISSING=ON, $
[CODE]

produces:

[CODE]
{    
"clas
s":  
"go.G

You will see extra space, as it pads to fill 5 characters per line.

if it included the one space that I want and not the extra ones, I would be ok.

Any ideas on how to get the spaces without the padding?

Fernando

This message has been edited. Last edited by: Fernando,

Did zou try using PARAG?

I have not tried that. Looking at the doc I see that it helps split lines. That is not quite what I want.

Fernando

Then what is it that zou want? In your example it looks like you want to split the string to have a row per charachter.

I have adjusted my metadata to use A32000. This solves my issue.

Fernando