Skip to main content
Question

Need to trim text and merge

  • July 25, 2019
  • 4 replies
  • 14 views

Forum|alt.badge.img

In reader we have below cvs with one field.

=================================

Translation was SUCCESSFUL

9.4 seconds. (CPU: 4.2s user, 2.7s system)

==================================

 

How I can get this in text like this: "Translation was SUCCESSFUL - 9.4 seconds."

May be regex or something else

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • July 25, 2019

The following regex should match everything before the brackets which you could use in a string searcher 

^[^\(]+

Or you could use a stringreplacer to replace everything in the brackets and including the brackets with nothing

\(.*\)

Forum|alt.badge.img
  • Author
  • 8 replies
  • July 25, 2019

The following regex should match everything before the brackets which you could use in a string searcher 

^[^\(]+

Or you could use a stringreplacer to replace everything in the brackets and including the brackets with nothing

\(.*\)

How I can merge to one line data in different rows. I want like this - "Translation was SUCCESSFUL - 9.4 seconds." . In one string


ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • July 25, 2019

How I can merge to one line data in different rows. I want like this - "Translation was SUCCESSFUL - 9.4 seconds." . In one string

You can use the string replacer to do this, by replacing the line feed/carriagereturn with a space


takashi
Celebrity
  • 7843 replies
  • July 26, 2019

How I can merge to one line data in different rows. I want like this - "Translation was SUCCESSFUL - 9.4 seconds." . In one string

If the source text just contains the two rows, you can achieve the goal with this workflow.