I am trying to create clean data to go into air table. I have successfully used the HTML Mark Down, Regex, and Split Text functions to get to here. Which allows me to pull out key data for the fields I need. This has successfully posted to AirTable.
Now i would like to see if i can clean the data more, mainly removing the ‘|’ and the ‘>’ and ‘---|---’ from the fields. I figured this would be easiest in the Python Code tool however, the simple replace function I am used to using doesn’t seem to be working any advice?
| Hourly GBP £15.00
| London, UK
| Ground Floor Burgess Business Park, Parkhouse St, London SE5 7TJ
> Shift Details!
| Ground Floor Burgess Business Park
| TEST JOB
| 09:00 - 18:00 on 2022-08-25