replace carriage returns

HKI

 

 Hello, I have a data that I retrieve in an excel cell, this one is found in an attribute after reading the file.

in these cells I find carriage returns with other info.

I tried to do a replace all with my attribute, \n,but no success.

exemple :

Text1(\n)

Text1

Result i want :

Text1 

 

this is my replaceAll in a generate attribute

replace([Txt], "\n" , "")

 

i hope it's clear.

thank's for helping

HKI

thank's verry much, it's work better !

 

kypexin

Have you tried \r or \r\n instead? (I can't check myself right now, but it could help maybe...)

sgenzer

hello @HKI - so carriage returns are funny.  They can be represented by a variety of things in unicode.  Have you tried using \r instead of \n?  In order to debug this, I would recommend encoding the attribute (use the "Encode URL" even though it's not a URL) and see how those carriage returns are coded.  Works every time. 

Scott

 

HKI

thank's all for your answering.

but sorry i haven't see the solution.

if we take the problem differently. I want to retrieve the first row of my cell.

for exemple in the generate attribute opertor if i could use a substr () function from position 1 to a carriage return, if the Substr() function exist :-)

so my exemple will like this :

Original cell :

Text1

Text2

 

Result :

substr(cell, 1, carriage return) ==> Text1 (only)

 

 thank's for helping :-)

 

 

sgenzer

hello @HKI - so the best way for us to help you is for you to post both the excel sheet you're trying to parse, and the RapidMiner process you have built so far.  Please post the process in XML format using the </> button.  Thanks.

Scott

 

HKI

hi,

her it is my process, and my excel file

<?xml version="1.0" encoding="UTF-8"?><process version="7.5.001">
  <operator activated="true" class="read_excel" compatibility="7.5.001" expanded="true" height="68" name="Read Excel" width="90" x="45" y="34">
    <parameter key="excel_file" value="C:\Users\phki12731\Desktop\tst RapidMiner.xlsx"/>
    <parameter key="sheet_number" value="1"/>
    <parameter key="imported_cell_range" value="A1:B4"/>
    <parameter key="encoding" value="SYSTEM"/>
    <parameter key="first_row_as_names" value="false"/>
    <list key="annotations">
      <parameter key="0" value="Name"/>
    </list>
    <parameter key="date_format" value=""/>
    <parameter key="time_zone" value="SYSTEM"/>
    <parameter key="locale" value="English (United States)"/>
    <list key="data_set_meta_data_information">
      <parameter key="0" value="Nom.true.polynominal.attribute"/>
      <parameter key="1" value="Prénom.true.polynominal.attribute"/>
    </list>
    <parameter key="read_not_matching_values_as_missings" value="true"/>
    <parameter key="datamanagement" value="double_array"/>
    <parameter key="data_management" value="auto"/>
  </operator>
</process>
<?xml version="1.0" encoding="UTF-8"?><process version="7.5.001">
  <operator activated="true" class="generate_attributes" compatibility="7.5.001" expanded="true" height="82" name="Generate Attributes" width="90" x="179" y="34">
    <list key="function_descriptions">
      <parameter key="Nom" value="upper([Nom])"/>
      <parameter key="Prénom" value="replace([Prénom], &quot;\\n&quot; , &quot;*&quot;)"/>
    </list>
    <parameter key="keep_all" value="true"/>
  </operator>
</process>

sgenzer

hello @HKI ok thank you.  That XML is corrupted - it looks like pieces of two processes.  And you are using RM 7.5.1?  That's a pretty old version. I would highly recommend downloading Studio 7.6.1 (most recent version) by logging into my.rapidminer.com.

Scott

 

HKI

exactly, i have the 7.5 version. i'm trying to donload the right version right know :-)

 in the meantime, here is a preview of my process in screen copy.

thank you for helpin.

 

 

 

sgenzer

ok.  Let's wait until you upgrade to 7.6.1 and load the process there.  That will be much easier.  And I don't see the actual Excel file - just images.

 

Scott

 

HKI

 

Hi,

 I am waiting for installation validation of this version. I am not admin of my post. we have dedicated teams to do it :-)

 

 

 

sgenzer

oh dear.  OK.  Holding pattern confirmed. 

Edin_Klapic

Hi @HKI,

 

the following expression in "Generate Attributes" solves this problem on my side:

 

replaceAll(old_attribute,"\\n.*","")

 

Explanation:

• "replaceAll" can deal with regular expressions in the middle (i.e. selection part) - click on the double arrows to the right of "Text transformations" in the left (i.e. Functions) panel of "Generate Attributes"
• The regex for newline "\n" needs to be escaped by a leading backslash since a backslash is internally used to escape the following character.

Hope this helps,

Edin