Obtains A Specified Number Of Characters From The Beginning Of A String Unicode
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
//==================================================================== // Function: f_left() //-------------------------------------------------------------------- // Description: specified number of characters from the beginning of a string asci //-------------------------------------------------------------------- // Arguments: // string as_str : string input // integer ai_len : length to get //-------------------------------------------------------------------- // Returns: string //-------------------------------------------------------------------- // Usage: f_left("WOMEN’S TRAIL 2650 MESH GTX MOJAVE DESERT", 40) //==================================================================== Char lc_char Int li_p, li_len, li_ch String ls_str, ls_rtn ls_str = as_str If Len(ls_str) = 0 Or Len(Trim(ls_str)) = 0 Then Return ls_str li_p = 1 Do While Len(ls_str) >= li_p lc_char = Mid(ls_str,li_p,1) If Asc(lc_char) > 127 Then li_p += 3 Else li_p += 1 End If Loop If ai_len >= li_p Then Return ls_str li_len = 1 li_ch = 1 Do While li_len <= ai_len And Len(ls_str) >= li_len lc_char = Mid(ls_str,li_len,1) If Asc(lc_char) > 127 Then ls_rtn = ls_rtn + Mid(ls_str,li_ch,1) li_len += 3 li_ch += 1 Else ls_rtn = ls_rtn + Mid(ls_str,li_ch,1) li_len += 1 li_ch += 1 End If Loop Return ls_rtn |
Good Luck!
Hey Need help I had an issue I installed a language pack in windows 11 added Marathi as language Installed PB 2019 R2 MySQL 8 and unicode ansi driver but when I go to numeric column and enter text let say 70.00 and goes to new column it automatically convert it to 26275.26 or some garbage value I already ask it on forum long back but not keep the follow up. can you just read the thread and reply it back the solution. Also attached video link https://www.awesomescreenshot.com/video/14291412?key=486180210b05e9abb29ce77dd5034acd
PB Forum Link https://community.appeon.com/index.php/qna/q-a/urgent-datawindow-editmask-numeric-datatype-not-working-garbage-values-with-unicode
please check the format control panel on your computer. if you want always 1 format you can use edit marks on columns or format on columns. please review.