StringSearcher regex \\r\\n

Hi @deanrother

please try ^.*\\n as StringSearcher regular expression. You can always experiment using StringSearcher RedEx Editor (please check Open RegEx Editor... for Contains Regular Expression parameter).

Would you like to split your source value into parts? If yes, you might also want to take a look at AttributeSplitter.

Here are my thoughts:

Somewhere in version 2016 or 2017 the functionality for .* changed (I struggled with it myself for a fair amount of time). It now catches newlines as well, while before it didn't (like your Espresso I guess).

So a solution could be making the .* non-greedy, that is adding a question mark to it.

The complete regex then would be '.*?\\r\\n' (without the quotes)

Hope this helps.

Just an alternative thought:

If the source is a text file (and csv is), why not use the Text reader and read by line.

If you want the lines in a list, you can follow the reader by an Aggregator and aggregate the attributes in a list.

If the source is a text attribute, you can follow @LenaAtSafe using the AttributeSplitter and split on \\n

In any case, if you want all lines to be separated, I would not use the StringSearcher and regex.

Hi @deanrother,

 

I'm use the FME version 2017 and i haved this result:

 

That this what you want?

 

StringSearcher: ([^ ]* +)

 

 

Attached your workspace edited.

 

 

Thanks, - workspace-stringsearcher.fmw

 

Danilo

Lena, this doesn't work for me. It matches everything (fig. 1). The output displayed by the Inspector bears this out (fig. 2).

I want each line as a list item, e.g.,

_list{0}.value = METER_NUM,PRODUCTION_DATE,FLOW_TIME_MINUTES,VOLUME,ENERGY,DIFF_PRESS,STATIC_PRESS,FLOW_TEMP,MOL_CO2,ENERGY_FACTOR

_list{1}.value = 1006-2001307,20170829,132.283,13.8851,,9.45286000000001,1088.28,83.9825000000001,,

_list{2}.value = 1006-2001283,20170829,1440,311.974,,27.9496,162.085,88.4964,,

 

Figure 1

Figure 2

. means any character, including \\n and \\r. So, your regex means starting from the beginning of the strings, any number of any characters, followed by <new line> - which is exactly the whole source string.

 

Could you please try AttributeSplitter? This would be your #1 choice for the task.

 

For StringSearcher one of the regex options would be [a-zA-Z0-9_.,-]*\\n . If you need to split the sample string into three strings, your regex should not start with ^ as this would automatically exclude second and third parts.

 

 

That worked. Thanks!

 

 

Perfect @deanrother . I'm happy to help you. :)