How To Extract specific key Value from the string that has key value pairs

Question

Post reply

How To Extract specific key Value from the string that has key value pairs

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Zond Sita SSC Veteran Points: 275 More actions · Answer 1

Actually you are correct. I see very few other fields has , in between values such as Name: John, Doe, Age:30

so I am trying to get rid of commas if it is in between values but not at the end of value.

hmmmmmmm... no luck yet

Best Regards

Zond Sita SSC Veteran Points: 275 More actions · Answer 2

Good Morning,

For time being I manual replaced for .INC and LLC etc where ever there is commas 🙂 as temporary fix we good here. Thank you for your support.

this is happened before the query so initially where ever the string contains , LLC & , INC i replaced it 🙂

Best Regards

Phil Parkin SSC Guru Points: 246962 More actions · Answer 3

Please expand your sample data to include some values with embedded commas, so that I can assess whether the existing code can be refined to handle them. Thank you.

Note that it will be close to impossible to handle them if the rest of the data in the row is not text qualified ("like this")

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin