As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
I am trying to extract data from a CSV file which is TAB delimited, and I am using SUFFIX=TABT in the MAS file. For some reason, a space is being added between every character in the fields. Eventhough the actual field is 8 charcters long, I would have to change it to 17 to avoid the "data field larger than specified length" error.
Ex: a DATE field in CSV file: "20090401" DATE field outputed: " 2 0 0 9 0 4 0 1 "
Has anyone encountered this before?This message has been edited. Last edited by: Kerry,
Please read up on "SUFFIX" and the associated values associated with it in regards to CSV files. These masters (in the Tue Jun 02 2009 17:44 post) are for a tab delimited file.
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
Yeah Waz, Therein lies the first dilemma: "I am trying to extract data from a CSV file which is TAB delimited" ... "but the CSV file is tab delimited". So, it's not a CSV file... Let's wait for some data.
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
The fact that the output contains a space between each character is very strange however what is also strange is that (if you wrote it accurately) the output shows double quotes as part of the output.
This is incorrect for a TABT file as data elements should not be wrapped within double quotes.
What you have in WebFOCUS terms is a DFIX format file.
Write your master as DFIX and you will probabley find that it works. You can find out how to write it in the dev studio online help
I have seen this before. Reason in that particular case was that the text (or csv or tab delimited) file originated from a system that used a somewhat different text encoding scheme. In my case it was a unnicode enabled ms sql server 2005 system, that produced a file suited for unicode access. Which uses two bytes for every character. I had to use some file conversion program to get it right.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
Thanks guys, I guess there's just something wrong with the format of the data. I converted it to a normal tab delimited text file, and everything works correctly.
Focal Point Forums 
