Forum Discussion

dmouser's avatar
dmouser
Frequent Visitor
8 years ago

Culling for different data across a text string

Good morning all.  We've inherited a set of data sourced from SharePoint.  One of the key pieces of data we need to access and interact with is burried within a column populated from a workflow (whic...
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi dmouser ,

 

"What we'd like to achieve is returned Updated Date values for offices where a specific status is present. "

 

<--- Could you please clarify more details about "returned Updated Date values"? What's the logic of your expected result. If possible, can you give me some sample data for analysis and test?

 

Regards,

Jimmy Tao

  • dmouser's avatar
    dmouser
    Frequent Visitor
    8 years ago

    I need to be able to extract the third date value from strings of select data per the example below.  However, it's one long continious block.

    ",Correspondence,Assignment Process, Entire Deliverable,2017-12-26T15:33:42,,2017-12-26T15:33:42
4903,Correspondence,Assignment Process, Entire Deliverable,2017-12-26T15:33:42,,2017-12-26T15:33:42
4903,Correspondence,Office Completion,XYZ,2017-12-26T15:33:42,2018-01-12T16:00:00,2018-01-04T13:43:48
4903,Correspondence,Office Completion,ABC,2017-12-26T15:33:42,2018-01-12T16:00:00,2018-01-04T13:43:48"

    The structure is:

    ID, Category, Action, Area/Office, Assigned Date, Created Date, Modified Date

     

    Where a Action = Office Completion, I need to be able to pull out the office (i.e. XYZ, ABC), and the modified date, whcih in this instance aligns to the date/time that office submitted their data.

     

    I tried to delimit on commas (,), but as you can see after the Modified Date there is no comma, so when I delimit that date value co-joins with the ID from "row" below it.