The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

How do I split strings?

kobeqkobeq Member Posts: 2 Newbie
in Help

First off I used the JSON to Data operator, then I selected an attribute called reviews, it contains a string with the review and the Reviewer.

Format: "Review" Reviewer

it may also have ratings like 4.0/5. How do I split the review inside the "" from the reviewer. My goal is to split them both and turn the review attribute into an array that contains them both but separated. I may also want to separate the rating or disregard it.

Answers

  • rjones13rjones13 Member Posts: 204 Unicorn
    edited October 21

    Hi @kobeq,

    I would recommend looking at using the Split operator. I've attached a very small example making some assumptions around your data.

    Best,

    Roland

    split-example.rmp

Sign In or Register to comment.