cancel
Showing results for 
Search instead for 
Did you mean: 

String Parsing

Former Member
0 Kudos

Hi all,

I have a report that looks like this:

     requestor          date                            item_to change

john, doe (group1)

     john, doe          8/27/2015                    &Wrong Client&Other&

     john, doe          9/15/2015                    &Duplicate Entry&

Jane, doe

     jane, dane          11/12/2015               &Date of Service&Service Code&

What I want to do is Parse the item_to_change field, so when there are more than two & I will pull the second word out and
repeat the same information in the row below. So the report would look like this:

     requestor          date                             item_to_change

john, doe (group1)

     john, doe          8/27/2015                         &Wrong Client&

     john, doe          8/27/2015                         &other&

     john, doe          9/15/2015                         &Duplicate Entry&

Jane, doe

    

     jane, doe          11/12/2015                        &Date of Service&

     jane, doe          11/12/2015                         &Service Code&

I know how to parse the string with Split, but is there a way to copy the row with the and insert my desired word into the row below?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Nate,

No, not in CRD. The problem is it a new row of data.

One way would be to use a formula field and break the text up and format it and set the formula object to Can Grow.

You would see the new line but not the name and date. But come to think oif it you may be able to add them in the formula and space the fields accordingly so it looks like a new row of data.

Other than that I can't think of any other way....

Posibly a Stored Procedure to break the text up and add it as a new row of data...

Don

Answers (0)