‎2009 May 19 9:16 AM
Hi,
string fieldvalue = ' 80.99-'
after regex - string fieldvalue = ' -80.99'
is there a regex way to move the "-"(last char) to the first digit(before the first occurence of a digit) ?
and maybe move the complete value to the outer right.
thx,
Gordon
Edited by: Gordon Breuer on May 19, 2009 10:36 AM
‎2009 May 19 9:25 AM
‎2009 May 19 9:30 AM
‎2009 May 19 9:30 AM
Hi,
Use this FM CLOI_PUT_SIGN_IN_FRONT to get the Minus sign at stating of the value.
‎2009 May 19 9:44 AM
‎2009 May 19 9:44 AM
FM is not available here.
i found a way to use regex even with shifting to outer right.
replace FIRST OCCURRENCE OF regex '\<[[:alnum:]]+\>'
IN text with '-$0'.
thx!
‎2009 May 19 9:45 AM
FM is not available here.
i found a way to use regex even with shifting to outer right.
replace FIRST OCCURRENCE OF regex '\<[[:alnum:]]+\>'
IN text with '-$0'.
thx!
‎2009 May 19 9:45 AM
FM is not available here.
i found a way to use regex even with shifting to outer right.
replace FIRST OCCURRENCE OF regex '\<[[:alnum:]]+\>'
IN text with '-$0'.
thx!
‎2009 May 19 9:45 AM
FM is not available here.
i found a way to use regex even with shifting to the outer right.
replace FIRST OCCURRENCE OF regex '\<[[:alnum:]]+\>'
IN text with '-$0'.
thx!
‎2009 May 19 9:46 AM
Sorry for double posting (Server Error at my side).Please delete unwanted posts.
Thx,
Gordon
Edited by: Gordon Breuer on May 19, 2009 10:47 AM