What?
This is a quick note to show you how to convert a given comma delimited string into a database table:
Given: "Title,Forenames,Surname"
Return:
ID Value
------ ----------------
...
What?
I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room.
The Problem?
When I select specifying the statement "WHERE IN (c.RoomImages)", ...
... delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the Shopify Product ID (not of the variant but of the product). In which case, I need ...
... v_FormattedString;
// yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland
// split into a list (string delimited by commas)
l_StringParts = v_FormattedString.toList();
// ...
... What Creator understands: FAILS
How?
So the way to push this value over to Creator is by converting the list to a string... notably comma delimited:
// Reading CRM:
l_MyMultiPicklist = List:String();
l_MyMultiPicklist.add("Option1");
l_MyMultiPicklist.add("Options ...
... each column:
1. Specify that the data is delimited
2. Specify the data is delimited by commas
3. Specify which columns should be imported as text (the long numbers and phone numbers) ...
... a G-Suite Administrator (see 2b). Scope is a string of scope urls delimited by a space (in this example only one). ISS is the client email taken from the JSON key downloaded from Google.
// Build ...
... value delimited by a period/dot. Base64 decode the second part and this will reveal the user's name and email (along with other profile settings) which you will have to be careful on ensuring this is NOT ...
... start with a function that just converts a string of words delimited by spaces to a table:
CREATE FUNCTION dbo.[ufn_StringToTable]
(
@StringInput VARCHAR(MAX)
)
RETURNS @OutputTable TABL ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.