How to input a particular string of text, if its missing

[yashs]

Hi!

My data isn't always consistent, and I want it to present the same way every time

My data: 

Expected output:

Basically, incase the word 'TAF' isn't present, I want to add it there.

I have attached the input file incase needed.

I'm trying to use the pseudocode

IIF ( 'TAF' not present at location, write TAF, Do nothing)

But I'm not sure how to get the location, and how to write 'TAF' exactly in the same place

I would really appreciate your help!

[atcodedog05 · Accepted solution]

Hi @yashs 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[yashs]

@atcodedog05 

The solution worked perfectly! Thank you so much for the help!

[atcodedog05]

Happy to help 🙂 @yashs 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂