jenmcclary
Programmer
Help. I have spent hours searching for a solution to this on tek-tips already. I have been trying to use the wildcard * but with no success.
I need to replace the 162 between the _ and the . in the following string: "100 -nmin( (ROUND( MERGEDATA_162.FNU_FREQPERC_F ,0) + ROUND( MERGEDATA_162.FNU_FREQPERC_U,0)),100)".
However, the value 162 will be different in each string I do this to so I can't search for 162. Also, the value won't always be three characters long.
I have tried with no success:
StringFix(rs2!expression, "_" & ~* & ".", ReplaceRptID) and
StringFix(rs2!expression, "_*.", ReplaceRptID) and
StringFix(rs2!expression, "_~*.", ReplaceRptID) and
StringFix(rs2!expression, "_" & * & ".", ReplaceRptID).
StringFix is a function that takes the three values and does the replace. What happens is either the * gives me an error or the replace doesn't do anything.
I am using Access 2000.
Can someone help?
Thanks,
Jennifer
I need to replace the 162 between the _ and the . in the following string: "100 -nmin( (ROUND( MERGEDATA_162.FNU_FREQPERC_F ,0) + ROUND( MERGEDATA_162.FNU_FREQPERC_U,0)),100)".
However, the value 162 will be different in each string I do this to so I can't search for 162. Also, the value won't always be three characters long.
I have tried with no success:
StringFix(rs2!expression, "_" & ~* & ".", ReplaceRptID) and
StringFix(rs2!expression, "_*.", ReplaceRptID) and
StringFix(rs2!expression, "_~*.", ReplaceRptID) and
StringFix(rs2!expression, "_" & * & ".", ReplaceRptID).
StringFix is a function that takes the three values and does the replace. What happens is either the * gives me an error or the replace doesn't do anything.
I am using Access 2000.
Can someone help?
Thanks,
Jennifer