Skip to main content
Question

Need to trim text and merge


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

4 replies

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • 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
  • July 25, 2019
ebygomm wrote:

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+39
  • Influencer
  • July 25, 2019
bkolubenka wrote:

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
Influencer
  • July 26, 2019
bkolubenka wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings