SELECT ExtractValue(bulk_custom_field_string,"//CustomFieldValue")as CatalogValues FROM candidate_work_profiles

i am getting output as

'false No 36 January 2007 January 2010'

i want output as Separate Column

false|No|36|January 2007|January 2010

please help me

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.