I have this string: "House, Road, Town, County"
Can I use something like rtrim to get rid of everything AFTER the second comma?
And the string is dynamic, with different houses, roads and so on..
Thanx Kate
But the house road and so on are already a complete string. Here are two examples:
"Alban House, Nomanslandfarm, Wheathampstead, Hearts"
and
"10 Calverton Road, Luton, Beds"
So everything after the second comma has to go
Can I use something like rtrim to get rid of everything AFTER the second comma?
And the string is dynamic, with different houses, roads and so on..
Thanx Kate
But the house road and so on are already a complete string. Here are two examples:"Alban House, Nomanslandfarm, Wheathampstead, Hearts"
and
"10 Calverton Road, Luton, Beds"
So everything after the second comma has to go