I have the data below in one field. I am trying to return the data after the first hyphen.
In the case of the record with 6320020.410 - I/S DFIT - N/C ASSET, I want to end up with I/S DFIT - N/C ASSET. My attempts at using RegEx are not producing the desired results. Any help is greatly appreciaed. Thanks.
6311010 - SIT EXPENSE
6320020.410 - I/S DFIT - N/C ASSET
6320020.411 - I/S DFIT - N/C ASSET
6320040.410 - I/S DFIT - N/C LIAB PLANT
6320040.411 - I/S DFIT - N/C LIAB PLANT
Solved! Go to Solution.
Or this string function:
Trim(Right([Field1], Length([Field1]) - FindString([Field1], "-") - 1) )
Cheers,
Great idea. Thanks.