Hi guys 

are there any function or steps to remove carriage return formula from a string?
#ApptioforAll

Hello @Roland Pendon.Try the ReplaceRegex() function.
ReplaceRegex(column_name,match_expression,replacement_expression)

You could write something like ReplaceRegex(column_name,"*\n*","* *")​
I used it once upon a time, and can't quite remember the syntax, but it's worth trying/experimenting with.

Apptio's (comprehensive) help file points to Regex Cheat Sheet and to https://regex101.com

(Later)
I run a small experiment and it worked:

• I loaded an Excel file with a single column and a single row, where I had forced a <CR> with <ALT><ENTER>:
  

  My Column

  this column has 2 lines

• I then added CleanColumn=ReplaceRegex(My Column,"\n"," | ")
• This is what I got:
  
  I selected the solid bar for visibility.

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 09-06-2021 01:44
From: Roland Pendon
Subject: formula function to replace carriage return value from a string.

Hi guys

are there any function or steps to remove carriage return formula from a string?
#ApptioforAll

Hi @Guillermo Cuadrado thanks will try that and will get back to you if its working.​
Original Message:
Sent: 09-06-2021 02:46
From: Guillermo Cuadrado
Subject: formula function to replace carriage return value from a string.

Hello @Roland Pendon.Try the ReplaceRegex() function.
ReplaceRegex(column_name,match_expression,replacement_expression)

You could write something like ReplaceRegex(column_name,"*\n*","* *")​
I used it once upon a time, and can't quite remember the syntax, but it's worth trying/experimenting with.

Apptio's (comprehensive) help file points to Regex Cheat Sheet and to https://regex101.com

------------------------------
Regards, Guillermo

Original Message:
Sent: 09-06-2021 01:44
From: Roland Pendon
Subject: formula function to replace carriage return value from a string.

Hi guys

are there any function or steps to remove carriage return formula from a string?
#ApptioforAll

3 years later and this has helped us out! Thanks Guillermo :)

Original Message:
Sent: 09-06-2021 02:46
From: Guillermo Cuadrado
Subject: formula function to replace carriage return value from a string.

Hello @Roland Pendon.Try the ReplaceRegex() function.
ReplaceRegex(column_name,match_expression,replacement_expression)

You could write something like ReplaceRegex(column_name,"*\n*","* *")​
I used it once upon a time, and can't quite remember the syntax, but it's worth trying/experimenting with.

Apptio's (comprehensive) help file points to Regex Cheat Sheet and to https://regex101.com

(Later)
I run a small experiment and it worked:

• I loaded an Excel file with a single column and a single row, where I had forced a <CR> with <ALT><ENTER>:
  

  My Column

  this column has 2 lines

• I then added CleanColumn=ReplaceRegex(My Column,"\n"," | ")
• This is what I got:
  
  I selected the solid bar for visibility.

------------------------------
Regards, Guillermo

Original Message:
Sent: 09-06-2021 01:44
From: Roland Pendon
Subject: formula function to replace carriage return value from a string.

Hi guys

are there any function or steps to remove carriage return formula from a string?
#ApptioforAll

😍😍😍

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 07-26-2024 06:52
From: Oliver Smith
Subject: formula function to replace carriage return value from a string.

3 years later and this has helped us out! Thanks Guillermo :)

Original Message:
Sent: 09-06-2021 02:46
From: Guillermo Cuadrado
Subject: formula function to replace carriage return value from a string.

Hello @Roland Pendon.Try the ReplaceRegex() function.
ReplaceRegex(column_name,match_expression,replacement_expression)

You could write something like ReplaceRegex(column_name,"*\n*","* *")​
I used it once upon a time, and can't quite remember the syntax, but it's worth trying/experimenting with.

Apptio's (comprehensive) help file points to Regex Cheat Sheet and to https://regex101.com

(Later)
I run a small experiment and it worked:

• I loaded an Excel file with a single column and a single row, where I had forced a <CR> with <ALT><ENTER>:
  

  My Column

  this column has 2 lines

• I then added CleanColumn=ReplaceRegex(My Column,"\n"," | ")
• This is what I got:
  
  I selected the solid bar for visibility.

------------------------------
Regards, Guillermo

Original Message:
Sent: 09-06-2021 01:44
From: Roland Pendon
Subject: formula function to replace carriage return value from a string.

Hi guys

are there any function or steps to remove carriage return formula from a string?
#ApptioforAll