Hi ​@nmandal ,

It's hard to find the reason for the rejection and a solution unless information about your workspace. Can you elaborate how you are attempting to read the records? It would be better if you would post a screenshot illustrating the workflow on the Workbench Canvas, including the question part.

Your linestrings are in 'OGC Well Known Text’ format.

Use a GeometryReplacer to get the geometry.

Hi,
thank you and appreciate your time for me.
I am using WKT and GeometryReplacer.
All works fine except 288 feature has multiple line in a column (line breaker) as given above sample.
I do not know how to handle this issue.

Use a StringReplacer to remove the Newline character from the attribute.

Text To Replace: Newline (\n), shown as  LF 

Replacement text is empty.

Hi ​@geomancer
thank you again.
I am still getting same issue:
 

Thank you for sharing the screenshot.

I believe that the GeometryReplacer (Geometry Encoding: OGC Well Known Text) should work to convert a WKT to a geometry. And, as far as I can see the screenshot below, it's a valid LINESTRING text, unless it contains invalid spetial caracters such as a new line as ​@geomancer mentioned.

Is it true that the transformer rejected this one?

Can you provide an example linestring that doesn't work?

Or maybe the linestring is split over several features in your input data?

I am trying to attach rejected data that I load in excel, is being attached here.
Let me figure out how to upload here 

That you ​@takashi and ​@geomancer 
Here is attached zip file with rejected data.
I have formatted name and e-mail addresses for security reason but linestring data is as is ( column Z).
 

​@takashi 
Is it true that the transformer rejected this one? ==> Yes

Thank you for providing the data.

Please see the attached workspace.

I'm not sure what I am doing different, but replacing Newline (\n) with nothing works in this workspace, processing your Excel file.

Thank you, ​@geomancer ,
It is working for you, Not sure what is wrong with my workSpace.

Let me keep trying with this.

​@nmandal , thank you for sharing the Excel data, but I wasn’t able to reproduce the issue too.

A possible reason why ​@geomancer ‘s solution didn't work is, the invalid character could be any other whitespace character than \n. If so, this setting in the StringReplacer could be a workaround.

• Mode: Regular Expression Replace
• Text to Replace: \s+
• Replacement Text: <a space>

The regex \s+ matches one or more any whitespace character(s) including <space>, \t, \n, and \r etc.

Still not working for me. I am re checking entire data. 

The excel file you shared doesn’t actually have line breaks in the line string data. It’s just wrapped for display

Process was:

Pull data into table ‘A’ using API call
Use Table ‘A’ as source to split data for 3 feature class, point, line and polygon.

Now, pulling data directly from API for line, same data, it works.
Looks like moving data to table might have create some kind of issue.
Any way it works now.
Thank you ​@takashi and ​@geomancer for your attentioon.