Hi guys, here is my problem. I need a query(s) to preform the following tasks. Each part represents a what a query needs to do, if the parts can be combined to prefom the same task(s) with less queries, that is also acceptable.
Part1
--------------------------------------
I have a fields called Index0 and Index1. Index0 contains data, and Index1 is null. I need to add a field called MM that replaces Index0, then insert a new field after MM called Index0, which will be null. The data then would result in the MM field.
It would look like this:
Before:
Index0 Index1
After:
MM Index0 Index1
----------------------------------------
Part2
===============================
MM contains data in this formats:
002 1000100050597
002 1000100050599
002 23800001224
002 00200000519
002 2020003587
002 00200035788
Using a query, the 002 to at the beggining of the field needs to be removed, includding the space after it, so that the final result would be:
MM
1000100050597
1000100050599
23800001224
00200000519
2020003587
00200035788
This query must be carefull not to manipulate the rest of the data after the "002 ", since the beggining of that data may start with 002.
Part 3
+++++++++++++++++++++++++++++++
The process in Part2 needs to also be applied to data in that can begin with "003 ", 004 ", and "005 ". For example:
MM
003 11300080530
003 0030008014
004 00400005825
002 00200035788
004 005005303526
005 003100103524
005 005000354
002 1000100050599
If the query can succesfully work for removing just one type of prefix, as in Part2, then i can just make a query for each prefix. If it is at all possible to remove just prefixes "002 ","003 ", 004 ", and "005 " without risking the integrity of the data following the prefix, this would be a much bigger help.
++++++++++++++++++++++++++++++++++++++++++++++++
-Thanks guys!
Part1
--------------------------------------
I have a fields called Index0 and Index1. Index0 contains data, and Index1 is null. I need to add a field called MM that replaces Index0, then insert a new field after MM called Index0, which will be null. The data then would result in the MM field.
It would look like this:
Before:
Index0 Index1
After:
MM Index0 Index1
----------------------------------------
Part2
===============================
MM contains data in this formats:
002 1000100050597
002 1000100050599
002 23800001224
002 00200000519
002 2020003587
002 00200035788
Using a query, the 002 to at the beggining of the field needs to be removed, includding the space after it, so that the final result would be:
MM
1000100050597
1000100050599
23800001224
00200000519
2020003587
00200035788
This query must be carefull not to manipulate the rest of the data after the "002 ", since the beggining of that data may start with 002.
Part 3
+++++++++++++++++++++++++++++++
The process in Part2 needs to also be applied to data in that can begin with "003 ", 004 ", and "005 ". For example:
MM
003 11300080530
003 0030008014
004 00400005825
002 00200035788
004 005005303526
005 003100103524
005 005000354
002 1000100050599
If the query can succesfully work for removing just one type of prefix, as in Part2, then i can just make a query for each prefix. If it is at all possible to remove just prefixes "002 ","003 ", 004 ", and "005 " without risking the integrity of the data following the prefix, this would be a much bigger help.
++++++++++++++++++++++++++++++++++++++++++++++++
-Thanks guys!
