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

Question

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

Viewing 2 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

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: 247180 More actions · Answer 2

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")