Hello,
I am trying to split my data that only contains one column into multiple columns based on their names. Here is a sample of the data-
Field1 |
order=1 |
Date=1/1/2023 |
Time=12:00 |
Period=Jan |
Amount[NONE][NONE]100.00 |
[Null] |
order=2 |
Date=2/1/2023 |
Time=12:00 |
Period=Feb |
Amount[NONE][NONE]100.00 |
USD Amount[NONE][NONE]56.00 |
[Null] |
order=3 |
Date=3/1/2023 |
Time=12:00 |
Period=Mar |
Amount[NONE][NONE]100.00 |
Each segment is split with a value [NULL]. Can someone suggest the most efficient way of doing this?
Thankyou
if you wanted to remove 'NONE' from the AMount and USD_Amount columns you could use the data cleansing tool to remove punctuation like so:
to leave just the numeric values