Parsing a Field

[bbeshlian]

Hello,

I have a field named Code_Description and I want to parse the code into a separate field. The contents of the field are separated by an "_".

Current State:

Code_Description

CDL_Commercial Drivers License

Desired State:

Code	Code_Description
CDL	CDL_Commercial Drivers License

I modified a piece of code that was shared with me when I asked about parsing a comma separated filed. The code validates but nothing is returned. Here is the modified code:

IsNull(Left([@field:Code_Description],(Patindex('%_%', [@field:Code_Description])-1)),' ')

Any thoughts? Thanks in Advance.

[Kurumi]

Can you give a sample data and your expected result? Also, include the DataTypes of your field? 

Thanks!

[NailDyanC]

Hi,

As I understand your workflow, you want to extract the text "Code" in the word "Code_Description", right? If that is the case, you may try this formula:

SUBSTRING([@field:Code_Description],0, CHARINDEX('_',[@field:Code_Description]))

On 7/26/2019 at 10:46 AM, bbeshlian said:

Hello,

I have a field named Code_Description and I want to parse the code into a separate field. The contents of the field are separated by an "_".

Current State:

Code_Description

CDL_Commercial Drivers License

Desired State:

Code	Code_Description
CDL	CDL_Commercial Drivers License

I modified a piece of code that was shared with me when I asked about parsing a comma separated filed. The code validates but nothing is returned. Here is the modified code:

IsNull(Left([@field:Code_Description],(Patindex('%_%', [@field:Code_Description])-1)),' ')

Any thoughts? Thanks in Advance.