Not sure if I’ve worded that 100% correctly but basically values are being returned like so in a basic text column:
I was using the extract if text matches at first but then realised people often use custom number plates so that would not work(since thats one of the things we’re trying tp pull).
I attempted using ChatGPT and they said you can treat it as an array and extract like that however their javascript code isn’t working. Could anyone come up with a code/have any idea how to pull singluar data from that screenshot.(ie if we just wanted to pull the TOYOTA part or anything else)
Not sure I fully understand what you are asking, but what I’m getting out of this is that you have text that is percent delimited. You want to convert it into an array, and then retrieve values out of the array.
You can use a Split Text column to split it into an array.
Then use a Single Value column to retrieve values out of that array. As long as the number of array items is consistent and everything is in the same order, it should be a problem.
I’m impressed that you went to the trouble of typing that all out (or did you use some other sneaky method?)
@MattGlides - you could have saved Jeff a whole bunch of typing if instead of giving a screenshot of the data, you gave an actual sample of the data that could be copy/pasted
I just select the image or take a screenshot, select ‘Search image with Google Lens’, and it does the rest. Also incredibly useful for translating text in screenshots on the fly.
I used Google Lens a lot when I went to Quebec last summer, which is primarily French. Hold the camera up to a menu or any sign and it translates to English in real time.
Thank you I didn’t even think of that, ended up using a bit of my knowledge and chatgpts to come up with this:
And it seems to be working:
I don’t know if your way is more efficient/will cause less issues in testing(only done 2 cars so far) so we’ll see! Thank you.
My way is probably a bit more efficient because it’s not performing a javascript split multiple times. With my way you split once and then use several Single Value columns to retrieve each value from the array. Easier to maintain too.
