I need to replace an * in a data field
Field1
4541106356*01
15106987 01
1107661*01
99210*01
1108474*01
1108474*02
1108474*03
15608474*04
1108474*05
1108581*01
19097 01
1109541*01
Since the * appears in different places, I am not able to replace with a Concatenate function. Could some one please help me with this.
Thanks a lot.
Field1
4541106356*01
15106987 01
1107661*01
99210*01
1108474*01
1108474*02
1108474*03
15608474*04
1108474*05
1108581*01
19097 01
1109541*01
Since the * appears in different places, I am not able to replace with a Concatenate function. Could some one please help me with this.
Thanks a lot.