In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add a backspace between to text value

TarekIMEX
6 - Meteoroid

Hello everyone, I'm looking to add a backspace between two text value.

Eg :

What I have

ValueText Value
1Question 1 - Question 2 - Question 3
2Question 4 - Question 5 - Question 6
3Question 7 - Question 8 - Question 9

What I want

ValueText Value
1

Question 1

Question 2

Question 3

2

Question 4

Question 5

Question 6

3

Question 7

Question 8

Question 9

 

Thank you by advance.

2 REPLIES 2
aatalai
14 - Magnetar

@TarekIMEX not sure if you wanted it on new lines or just to delete the dash so put the m both in this workflow, hope it helps

bgreedy
7 - Meteor

You could use a formula tool to replace " - " with a new line

 

Replace([Text Value]," - ","
")

 

Labels
Top Solution Authors