How to update "part of a text field" without changing the entire contents?
Posted on 2016-09-26
I have a table 'Table1' that has a Text Field that contains data like this:
1,1P0014.241102.0000 1053591503 5806909 1230 HP23
The 3rd set of numbers in my DetailData text column is my MemberID field which is '5806909' in the above example. I need to know how to update this MemberID WITHOUT changing the contents of the rest of the Text. For example, the NewMemberId is '6006100'.
I need the change to be reflected like this:
1,1P0014.241102.0000 1053591503 6006100 1230 HP23
The "spacing" and character set cannot be changed at all.. but only the 3rd set of numbers which again is my MemberID.
How can I accomplish this within an UPDATE Script?