on 11-20-2015 9:23 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.