<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Hello JMP community,
the following script produces a 1x2 data table with character type cell values. The values in the cell are enclosed with double quotes (thanks to PMroz and MS for earlier posts on this) and then I save the table as a .txt file.
When I open the .txt file with a reader the double quotes are enclosed by additional double quotes:
sourcedId,status
"""000""","""active"""
Is there a way to save the table so that the final result looks like:
sourcedId,status
"000","active"
Orgs = New Table( "Orgs",
Add Rows( 1 ),
New Column( "sourcedId",
Character,
Nominal,
Set Values( { "\["000"]\" } )
),
New Column( "status",
Character,
Nominal,
Set Values( {"\["active"]\"} )
);
Orgs << Save As( "C:\Pathway\Orgs11.txt" );
Close(Orgs, noSave);
Many thanks in advance!
Sincerely,
MPG
Does JSL have a file stream? if the file size does become an issue...you can build the text in memory and write the file in one operation.
Thanks, that works well. The files I am working with are quite large, though the looping doesn't seem to be causing any major slowdowns.
Sincerely,
Matt
Here is a solution, that might meet your requirements. While it does not just use a Save As() function, but instead uses a Save Text File(). This takes a little more coding, but it does create the file structure you want
Names Default To Here( 1 );
Orgs = New Table( "Orgs",
Add Rows( 1 ),
New Column( "sourcedId", Character, Nominal, Set Values( {"\["000"]\"} ) ),
New Column( "status", Character, Nominal, Set Values( {"\["active"]\"} ) )
);
//Orgs << Save As( "C:\users\txjim\Orgs11.txt" );
Save Text File( "C:\users\txjim\Orgs11.txt", "sourcedId,status\!n" );
For( i = 1, i <= N Rows( Orgs ), i++,
Save Text File(
"C:\users\txjim\Orgs11.txt",
orgs:sourcedId || "," || orgs:status || "\!n",
Mode( "append" )
)
);
Close( Orgs, noSave );
