 |
|||||
|
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
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. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Thai help needed urgently; single quote problem
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Thai help needed urgently; single quote problem Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Thai help needed urgently; single quote problem | Login/Join |
| Member |
I am trying to set the following word to a variable: แจ้งเตือนชั้นเรียนสำหรับนักเรียน I enclose it in single quotes like this: DEFINE FILE X HEAD2/A100 = 'แจ้งเตือนชั้นเรียนสำหรับนักเรียน'; END When I try to print it, I get the following error message: (FOC257) MISSING QUOTE MARKS: 'แจ้งเตือน What can I do to fix it? I've tried isolating what I think is the offending character and using quote marks around it, but I'm unable to come up with a winning formula. Thanking you in advance....This message has been edited. Last edited by: <Kathryn Henning>, WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | ||
|
| Expert |
i would try getting the BYTVAL for each of the characters and then representing them each as &#nn; EG the bytval for an apostrophe (aka single quote)is 39 i.e. APOSTROPHE/I4 =BYTVAL('''','I4'); so its variable representation would be & # 3 9 ; (spaces added to get it to show up on this board) i'ld be curious to see a string of bytvals for this Thai word. maybe, rather than trying to measure each, you have a translation somewhere. character for character. i found this by googling, "Handbook of Natural Language Processing". looks intense.This message has been edited. Last edited by: susannah,
| |||||
|
| Member |
I considered doing what you're suggesting, but when I looked at the hex list of Thai characters, I was dismayed to note how many characters are extremely similar in appearance to my untrained eye. In addition, I am unsure how to use punctuation. The character that is causing the problem has two lines above it which appear to be punctuation, although removing the punctuation still doesn't allow the offender to appear in my text field. As one of my Indian colleagues once remarked: "This is causing me to break my head." WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Virtuoso |
This is causing me to break my head Love it! | |||
|
| Virtuoso |
have you tried concatenating different sections together. | |||
|
| Member |
I tried that first. I was able to make concatenation work with problems in French and Japanese, but this Thai problem is just not cooperative. I even tried changing from single quotes to double, with no success. WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
so isolate that offending character and see what the BYTVAL function can do with it. another question: is this a one-time thing? ie, is this Thai character string a constant thing? or are you always going to have to take a parm that is a thai character string?
| |||||
|
| Expert |
Have you tried (though I assume you're already doing this): -SET &WORD1 = 'แจ้งเตือนชั้นเรียนสำหรับนักเรียน'; DEFINE FILE CAR HEAD2/A100 = '&WORD1'; END Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
I isolated the bytval for that 7th character didn't do us any good its 63 and 63 is a questionmark so my only suggestion is that you take a screen shot of this thing and make it an image.
| |||||
|
| Member |
Check out this webpage to see how similar the Thai characters are: http://www.alanwood.net/unicode/thai.html Although I know which one it is, I can't be sure which hex value to choose. The Thai character string will be a constant. I'm casting letters to dealerships around the world. These character strings form headings or explanatory texts. I might have to ask the business analysts to ask our Thai users which characters are which -- or to give a translation that avoids them -- but it seems rather weasely. It would make my ego happier to find an elegant solution, as I know most of you can understand. WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
i tried exactly that, frankie, and i got a string of ????? displayed.
| |||||
|
| Expert |
ah they are contants,sort of. take a screen shot and make images to display in your headings. not as satisfying, but hey. reading your link, most of us don't have Thai language support installed in our browsers , so nothing we do is going to reveal anything other than ???. [i say 'most' of us b/c Waz is prob'ly still asleep  ... but he might well have something]This message has been edited. Last edited by: susannah,
| |||||
|
| Member |
I hadn't tried the -SET before, but it yielded the same results. Susannah, I'm intrigued by your images idea. How would that work? Rignt now I'm printing by concatenating the language text to display with the data item, and spitting it out, pretty much line by line. How would that work with images? WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
so, lets say you want to display an image of the flag of the COUNTRY right next to the COUNTRY field in the CAR file report. .. DEFINE FILE CAR FLAG/A100='<IMG SRC=approot/vis/flag' | COUNTRY | '.jpg height=12>'; END TABLE FILE CAR BY COUNTRY BY FLAG PRINT CAR MODEL END.. assuming you've created the flag files and named them flagENGLAND.jpg, flagITALY.jpg, (don't aske about W GERMANY, that ain't the point )... now... you say you're bursting these reports to dealers and emailing...so if you put html links to images in these reports, the dealers will have to be linked to your server to pull them down...so your images will have to be on a publicly available site (change the link to a full href and to a site not behind your firewall).... now (part b)... you would probably want to avoid that and instead create pdfs, which have the images embedded, which is a whole different can o' worms. deep breath.
| |||||
|
| Member |
Wow. I like the technique! But I would probably have to go the PDF route. I am thoroughly ensconced behind a firewall. In the meantime, I've broken down and created a case. Maybe IBI will have an alternative. (Or, maybe the great and powerful Waz will arise with an answer we've not considered!) WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
If the string is in a heading, could you put the string directly in the heading, instead of in a variable - the missing quote marks error shouldn't get triggered... HEADING "แจ้งเตือนชั้นเรียนสำหรับนักเรียน" Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Member |
By jingo, you're right!!! Now all I have to do is figure out how to structure the report to use a giant heading... I can see that it oculd be possible with a little effort! WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
Went into Paint and created the THAI Image:  Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Member |
Whoopee! WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Member |
Thanks, Tom! That looks pretty cool. I think I'm going with Francis' suggestion, though. WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
Hi Sharon, Sure, no worries! WebFOCUS has many roads up the mountain... Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Member |
On a less urgent note... how do I change the topic to SOLVED? WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
hmm that doesn't work in 768 i just get the ???????? i think that solution is going to be character-set dependent... do you have a cooler browser up there in Toronto? moi, i'm only in ie8.
| |||||
|
| Expert |
he's closer to Thailand than the rest of us.... 
| |||||
|
| Expert |
Well, I ran down to the Golden Thai restaurant around the corner - it works there, but not at the office Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Virtuoso |
Sharon to mark as Solved, Go in and Edit your orginal post heading. It's real high tech  | |||
|
| Virtuoso |
If the only thisng you needed is a picture, then fine. However if you need the characters, then you probably will have to go to unicode. Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Member |
Here's an update to the issue, and it works although I don't know why. That Thai string I was having problems with was in a -INCLUDE file that I was using in my program as a DEFINE. As it turns out, it works just fine if I do NOT use -INCLUDE but instead cut and paste the whole thing into the file! Perhaps that Thai character was seen as an "end of file" marker? I don't know, but this is the solution in case anyone else runs into it. WebFOCUS 7.3 on Windows 2003 server, FOCUS 7.3.7 on IBM Mainframe | |||
|
| Expert |
well, it was a fun one to work on with you.. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Thai help needed urgently; single quote problem
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Thai help needed urgently; single quote problemCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |