raghuprabhu
Registered User.
- Local time
- Yesterday, 18:14
- Joined
- Mar 24, 2008
- Messages
- 154
Hi Everyone...
Attached is a small database with one table with two columns as shown below.
Service Service No.
1 F327445
1 421547
1 8014432
2 O22771
2 L185244
2 O852424
3 O321322
3 R552552
3 O8471254
Basically I want to do the following
If service is 1 remove the alphabet from the first place in service number
If service is 2 remove the what ever the alphabet and replace it with A unless the numerical parts starts with 8 then replace with O
If service is 2 remove the what ever the alphabet and replace it with N unless the numerical parts starts with 8 then replace with O
I want the outlook as follows....
Service Service No.
1 327445
1 421547
1 8014432
2 A22771
2 A185244
2 O852424
3 N321322
3 N552552
3 O8471254
thank you..
Attached is a small database with one table with two columns as shown below.
Service Service No.
1 F327445
1 421547
1 8014432
2 O22771
2 L185244
2 O852424
3 O321322
3 R552552
3 O8471254
Basically I want to do the following
If service is 1 remove the alphabet from the first place in service number
If service is 2 remove the what ever the alphabet and replace it with A unless the numerical parts starts with 8 then replace with O
If service is 2 remove the what ever the alphabet and replace it with N unless the numerical parts starts with 8 then replace with O
I want the outlook as follows....
Service Service No.
1 327445
1 421547
1 8014432
2 A22771
2 A185244
2 O852424
3 N321322
3 N552552
3 O8471254
thank you..