Hi all,
I'm hoping you can help.. I've used this forum a couple of times and I am back again now i've moved onto something more complex (for me!)
I have some data which looks like:
"AL1_1,AL1_1,"
"AL1_1.AL1_1A.AL1_1AE,AL1_1AE,"
"AL1_1.AL1_1A.AL1_1AG,AL1_1AG,"
"AL1_1.AL1_1A.AL1_1AJ,AL1_1AJ,"
"AL1_1.AL1_1B.AL1_1BH,AL1_1BH,"
What i need it to look like is:
"AL1_1,AL1 1,"
"AL1_1.AL1_1A.AL1_1AE,AL1 1AE,"
"AL1_1.AL1_1A.AL1_1AG,AL1 1AG,"
"AL1_1.AL1_1A.AL1_1AJ,AL1 1AJ,"
"AL1_1.AL1_1B.AL1_1BH,AL1 1BH,"
So all underscores after the comma need to be replaced with a white space.. Is this possible at all?
Many thanks for reading
Gareth