Split and Format Wrap Text

[GayatriPanigrahi]

Hi All,

I have below dataset and trying to color code "Tagged" text available in column [Name Tag] using Report Text tool.

Below formulas i used but nothing worked 

Dataset :

ID	Name	Tag	Name Tag
1234	• ABC : XYZ : ETC • ABC : XYZ : PQR	Tagged	• ABC : XYZ : ETC - Tagged • ABC : XYZ : PQR - Tagged

Option1 : Report Text 
[Name :A] [Tag]

Option2 : Report Text
[Name Tag :A] Right([Name], 7)

[Yoshiro_Fujimori]

How about using Table tool?

Table Tool Configuration

Output

[GayatriPanigrahi]

@Yoshiro_Fujimori I am trying to achieve below output 
• ABC : XYZ : ETC - Tagged  --> Highlight and color code the "Tagged" word
• ABC : XYZ : PQR - Tagged --> Highlight and color code the "Tagged" word

The end result i need to send over an email. Hence i used a Report Text to format the email but can't perform a conditional formatting.  

[Raj]

@GayatriPanigrahi 
are you looking to achieve output this way
find the workflow attached.

mark done if solved.

[GayatriPanigrahi]

@Raj  @Yoshiro_Fujimori  Expecting output as below

[Yoshiro_Fujimori]

Hi @GayatriPanigrahi ,

Could you clarify how the input dataset is structured?

Dataset :

ID	Name	Tag	Name Tag
1234	• ABC : XYZ : ETC • ABC : XYZ : PQR	Tagged	• ABC : XYZ : ETC - Tagged • ABC : XYZ : PQR - Tagged

Does the above represent one row ([Name] column contains a new line character?)

or two rows like below?

ID	Name	Tag	Name Tag
1234	• ABC : XYZ : ETC	Tagged	• ABC : XYZ : ETC - Tagged
1234	• ABC : XYZ : PQR	Tagged	• ABC : XYZ : PQR - Tagged

[Raj]

@GayatriPanigrahi 
is your requirement something like this.
find the workflow attached.

[GayatriPanigrahi]

Hi @Yoshiro_Fujimori, Data is available in one row only and i am getting result as below image. However expecting "Tagged" should come after each sentence.

Excepted Output :

[GayatriPanigrahi]

@Raj Data should be in one row only, however the solution you provided has 2row.

 Unfortunately can't share the Alteryx workflow but you can refer the my 1st post for dataset.

[Yoshiro_Fujimori · Accepted solution]

Your data is not a normalized form, which makes it difficult to deal with.

I would recommend you to review your data format for the future.

That said, to add "Tagged" for each line, you have to convert each line to a row.

If you want combine the rows back to one line, use Summarize tool.

Workflow

Output

You can join the above output back to the original table with "ID" as a key.