I am new to IFS… I can not get vldtstr:strReplaceAll('*12345*', '*', '') to produce ‘12345’ what am I doing wrong here. Do I need an escape key for the ‘*’? vldtstr:strReplaceAll('*12345*', '3', '') produces ‘*1245*’ as expected. I am trying to strip off the ‘*’ for barcoding purposes in the report designer.
+8Hi Steve
Do try other options, considering StrReplaceAll() is not working for ‘*’. ( not sure why though , the function is defined well )
Trim is one such option. The solution is copied from Functions (ifs.com)
| StrTrim(string,char) | Returns string with all specified characters (both trailing and leading) | string : A string value you specify. This function removes the character specified by char from this string. |
|
+1I gave up on the StrReplaceAll() function, it just doesn’t work with the ‘*’. I was able to use the StrLTrim and StrRTrim() functions to work around it though. These functions do recognize the ‘*’.
vldtstr:strRTrim(vldtstr:strRTrim(vldtstr:strLTrim(concat(tns:SHOP_ORDER_REP/tns:ORDER_NO,'-',tns:SHOP_ORDER_REP/tns:RELEASE_NO), '*'),'*'),'-') *12345-* = 12345
Thank you for the reply
Steve Ball
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.