Hello :)
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?
Item 1
Company
Item 10
| Hourly GBP £15.00
Item 11
Location
Item 12
| London, UK
>
Item 13
Address
Item 14
| Ground Floor Burgess Business Park, Parkhouse St, London SE5 7TJ
Item 15
Note
Item 16
|
> Shift Details!
>
> |
Item 2
| Ground Floor Burgess Business Park
> ---|---
>
Item 3
Job Name
Item 4
| TEST JOB
>
Item 5
Shift
Item 6
| Day
>
Item 7
Schedule
Item 8
| 09:00 - 18:00 on 2022-08-25
>
Item 9
Pay