Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue : The tab space after the string is removed after reading in by the jar #62

Open
jatinbajaj777 opened this issue Oct 29, 2020 · 3 comments

Comments

@jatinbajaj777
Copy link

The tab space after any string value in a column is removed after reading in by the jar. The length of the below data frame is different.

+---------+------------+-----------------+------------+
|Text_Only|Text_Tab_Beg| Text_Tab_Mid|Text_Tab_End|
+---------+------------+-----------------+------------+
| ABCDEFGH| ABCDEFGH|ABCDEFGH IJKLMNOP| ABCDEFGH|
+---------+------------+-----------------+------------+

Function.length gives below results

Text_Only=8
Text_Tab_Beg=9
Text_Tab_End=8

The input data is thus changed removing the end tab space

@thesuperzapper
Copy link
Collaborator

@jatinbajaj777 Can you please provide a basic SAS7BDAT file which causes this error?

@jatinbajaj777
Copy link
Author

Attaching the sample SAS7BDAT file which covers all above scenarios.

atest.sas7bdat.txt

Also, the code below to generate the SAS7BDAT file.

Text_Only     = "ABCDEFGH";
Text_Tab_Beg  = cats( '09'x, "ABCDEFGH" );
Text_Tab_End  = cats( "ABCDEFGH", '09'x );
Text_Tab_Mid  = cats( "ABCDEFGH", '09'x, "IJKLMNOP" );

@thesuperzapper
Copy link
Collaborator

@jatinbajaj777 Can you also provide that same data in a common format (like CSV) so we can see what it should look like?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants