Data360 Analyze

 View Only
  • 1.  String split to columns

    Posted 06-28-2022 10:07
    Hi,

    I have following kind a dataset:

    Source data
    28/11/2020 20.27.47,744000
    28/11/2020 20.28.04,267000
    28/11/2020 21.08.10,867000
    28/11/2020 21.52.55,529000
    1/12/2020 4.24.03,394000
    1/12/2020 4.48.55,879000
    1/12/2020 4.48.42,382000

    Target dataset:
    28.11.2020
    28.11.2020
    28.11.2020
    28.11.2020
    1.12.2020
    1.12.2020
    1.12.2020

    How I can do this?

    Best Regards
    Kristian

    ------------------------------
    Kristian Westerstråhle
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: String split to columns

    Posted 06-28-2022 15:22
    Hi Kristian,

    Did you try split function?

    something like 
    out1.TargetField = in1.SourceField.split()[0]

    hope this helps





  • 3.  RE: String split to columns

    Employee
    Posted 06-30-2022 13:17
      |   view attached
    You could use regular expressions in a Transform node to extract the date string:



    See the attached example data flow (zipped).

    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    Naperville IL
    ------------------------------