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

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!

Backfill_TAF_50STN_Fcst_PyInput.txt

Data Investigation

Accepted answers

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 😀👍

All comments

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 😀👍

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

Happy to help 🙂 @yashs

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703